Then choose Fill – Across Worksheets to have the selected cells copied to the other worksheets. To use the Across Worksheets option, select some cells on the current worksheet, then Shift+Click or Ctrl+Click on one or more tabs to select multiple worksheets. Clicking it will give you options to fill Down, Right, Up, or Left, which are self explanatory, as well as Across Worksheets, Series, Justify, and Flash Fill. Fill Button – With the Home tab selected on the ribbon you will find the Fill button in the Editing group at the right end of the ribbon.Both require you to first highlight a range of cells, starting will the cell containing the text or numbers you want copied to the other cells. Keyboard Shortcuts – Ctrl+D is the shortcut for Fill Down.But it can do much more.įirst let’s talk about the mechanics of using Fill, then we’ll get into what else it can do. For example, enter a name in cell A1, then highlight cells A1 through A5 and press Ctrl+D (the keyboard shortcut for Fill Down) and all the selected cells will be filled in with the name from A1. In its simplest form it’s like a faster version of copy and paste. Excel’s Fill command lets you fill an adjacent group of cells with the same text or numbers, or with text or numbers that form a series.
