The other day I was prepping for my next Excel Introduction course (yep, even after all these years I still prepare for every single course) and realised I had totally forgotten this great time-saving tip to fill a range of cells with the same entry. You can obviously use Autofill or copy cells, but check it out and you’ll see that you can save quite a few clicks!
Here's how:
1. Select the range of cells you want to fill with the same entry.
2. Type the text, number or formula that you want to repeat.
3. Press CTRL + ENTER.
Oh, and it doesn’t have to be a contiguous range, so you can quickly stick data in cells that are not adjacent to each other. To do this, hold down CTRL while selecting each individual cell or range of cells.
By the way, I’ve added this latest shortcut to the ever-growing archive. Press CTRL + F to find text or other content in the document.
Related tips:
Move or copy cells using drag and drop
Quickly repeating a formula down a column
Upcoming courses
Microsoft PowerPoint Intermediate: Tue 29 Jan
Microsoft Excel Intermediate/Advanced: Fri 01 Feb
Microsoft Word Intermediate: Mon 04 Feb
Microsoft Excel Introduction: Fri 08 Feb
Microsoft Word Advanced: Fri 15 Feb
Microsoft Excel Intermediate: Mon 18 Feb
Microsoft Word Introduction:Mon 25 Feb
Microsoft Excel Manage and summarise data: Fri 01 Mar
21 January 2019
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk