![]() To autofill in Excel, hover over the cell with your formula. Click in the cell with the data and, keeping the left mouse button pressed, drag to select the rest of the cells in the row or column that you would like autofilled. ![]() Click Home %3E Fill, and choose either Down, Right, Up, or L. Using Menu : Select the cell with the formula and the adjacent cells you want to fill. ![]() The shortcut key for Flash Fill in excel is “CTRL+E”. Excel 2003: Go to Tools > Options > Edit. Autofill in excel shortcut Options > Edit.Select or unselect Enable AutoComplete for cell values.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |