Duplicate Across a Range of Cells in Excel Spreadsheets

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).

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.