In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she explains how to fill all selected cells with the same text, number or formula (Microsoft Excel)...
Tame your computer - fantastic fillings
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!
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.
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
Highly respected training company, specialising in Excel, Word, PowerPoint and Outlook. Since 2001 we have successfully developed and delivered training courses for public and private clients, large and small, across 23 countries around the world. We feel passionate about sharing the best of what we know with others and strive to help as many people as we can.