If you want to duplicate an entry across a range of cells, first select the range of cells, then type in the entry and then press Control + Enter.
This will duplicate the entry across the whole selected range.
Ideal for copying formulas down a column (for example).
Duplicate Across a Range of Cells in Excel Spreadsheets
posted in: Shortcut of the Week
0
Leave a Reply