Tame your computer - fantastic fillings

21/01/2019

public/news/thumbnail_33roem-tip-time-logo.png

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

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
Roem Limited

Independent, innovative software training company based in Cambridge. Registered supplier to local companies such as AstraZeneca, University of Cambridge, South Cambridgeshire District Council and NHS England.

Roem Limited directory information