Tip of the week # 562
19 January 2019

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; see inc/shortcut_archive.pdf. Press CTRL + F to find text or other content in the document.

Related tips:
Tip # 530: Move or copy cells using drag and drop ( tip_530.php )
Tip # 40: Quickly repeating a formula down a column ( tip_40.html )


* Unless stated otherwise, these tips were written for Microsoft Office 2010.