Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-08-2016, 07:20 AM
Straitsfan Straitsfan is offline Shortcut to haven ascending values in row/column of cells Windows XP Shortcut to haven ascending values in row/column of cells Office XP
Advanced Beginner
Shortcut to haven ascending values in row/column of cells
 
Join Date: May 2011
Posts: 48
Straitsfan is on a distinguished road
Default Shortcut to haven ascending values in row/column of cells


Hello --

Is there any shortcut in excel 2010 to select a cell (the one I have contains a date) and then fill in successive cells with ascending dates, in my case ascending days of the same month? I can click on the lower right hand corner and drag, but I thought it would be nice to have a keyboard shortcut.
Reply With Quote
  #2  
Old 08-09-2016, 05:28 AM
xor xor is offline Shortcut to haven ascending values in row/column of cells Windows 10 Shortcut to haven ascending values in row/column of cells 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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shortcut to haven ascending values in row/column of cells Need to Print Pages with Ascending Numbers MathewPankratz Word 1 04-07-2016 04:26 PM
copy non zero values to new column Guloluseus Excel 3 01-10-2016 08:48 AM
Return Sum value of one column from cells not blank in another column zulugandalf Excel 3 08-14-2014 03:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft