Thread: [Solved] Shortcut to haven ascending values in row/column of cells
View Single Post
 
Old 08-09-2016, 05:28 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Hard to compete with dragging the Fill Handle, but another way (if not a shortcut) is:

Enter for example today's date in A1. With A1 selected, press Fill and then Series. In the Series dialog, tick Columns, Date and Day, set step value to 1 and stop value to for example last day in August. Press OK.

But it is hardly any better than dragging the Fill Handle.
Reply With Quote