June 26, 2009, Newsletter Issue #313: Copy a date across a number of cells in Excel

Tip of the Week

Excel´s autofill feature is really useful if you want to enter one date, drag the fill handle and have it extend the series. If you just want to copy the same value into a number of cells, then dragging normally isn´t an option.

One method of doing achieveing this is to select all the cells (including the one with the date in), hold down the Ctrl key and press the D key. If the cells are horizontal rather than vertical, hold down the Ctrl key and press the R key.

About LifeTips

Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.

Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!


Guru Spotlight
Phyllis Serbes