You can also autofill cells using a pattern of values. Select these cells, move the pointer over a border of the selection until a yellow autofill handle (a dot) appears, then drag the handle over the cells you want to fill. Autofilling overwrites existing data with the content you’re adding.Īutofill cells with sequential content or patterns from adjacent cells: Type the first two items of the series in the first two body cells (not header or footer cells) of the row or column you want to fill for example, type A and B. Drag the handle over the cells where you want to add the content.Īny data, cell format, formula, or fill associated with the selected cells is added, but comments aren’t. You can quickly fill cells, or a row or column, with the same formula, data, or a logical sequence of data-for example, a series of numbers, letters, or dates.Īutofill one or more cells with content from adjacent cells: Select the cells with the content you want to copy, then move the pointer over a border of the selection until a yellow autofill handle (a dot) appears.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |