Home > Support > Hints and Tips > Tip of the Week

Weekly Computer Tip # 199
8 June 2007

Start each week with a free tip

To subscribe, please type your email address in the box below:

fill a range of cells with the same entry (Microsoft Excel)

I'm just going to repeat that ... tip 199. One hundred and ninety nine! So next week I will clock up my 200th tip. To mark the occasion, I am asking you guys to nominate your favourite top tip(s) of all time. To view all tips go to http://www.roem.co.uk/hints.html or use my site's search engine (http://www.roem.co.uk/search.html) and simply type a few descriptive words in the search field (for instance, word tip) and hit the ENTER key to see a list of pages about Microsoft Word tips.

In the meantime, I've dug out a tip from almost four years ago (tip # 22 to be precise; see http://www.roem.co.uk/tip_22.html) in which I explained how you can use Excel's AutoFill feature to quickly fill a range either with a series of labels or values or with copies of a particular value or formula. Even though this is still one of my favourite Excel tools, I wonder whether you know about the other quick way to fill a range of cells with the same entry.

Here's how:

  1. Select the range of cells you want to fill with the same entry.
  2. Type the text or value that is to be repeated.
  3. Press [CTRL] + [ENTER].

The text or value is simply copied into all selected cells, saving you quite a few clicks compared to the AutoFill feature or a "normal" copy and paste.

Well, this was tip #199. When I originally began (back in 2003), I had no idea how long I would carry on but as it happens, I'm still enjoying researching and writing them. Which brings me to a simple, if somewhat selfish, request: if you enjoy these tips, if you have benefitted from these tips, if you have a story relating to these tips, or even if it's just been a long time since you said 'hello', please send me an e-mail. It makes all the difference to know you're out there! Oh, and don't forget to nominate that favourite tip of yours!!

Until next week.

Email this page to a friend

Enter recipient’s email address in the box below:

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   News   Disclaimer  

© Roem Ltd. All Rights Reserved
June 2007