Copy a date across a number of cells in Excel

Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 2000 and other Software topics.

How can I copy a date across a number of cells

Copy a date across a number of cells in Excel

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.

   

Comments

Nobody has commented on this tip yet. Be the first.



Name:


URL: (optional)


Comment:


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


Guru Spotlight
George Sayour