Call us on 01223 214177 or email us
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:
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.
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.