» Filling a Range with a Series of Dates in Excel 2007
CATEGORY - Excel Editing
VERSION - Microsoft Excel 2007
To fill a range of cells with a series of dates:1. Select cell A1, press
2. Select the range A1:A10.
3. Select Home -> Fill (in Editing Group) -> Series.
4. In the Series dialog box, check the Date and Month option buttons, and then click OK.
Note: To fill a series of quarters, type 3 in Step value text box.
To fill a range of cells with a series of dates using a shortcut:
1. Select cell A1, and press
2. Point the mouse to the Fill handle in the bottom-right corner of the cell. The cursor changes to a plus symbol
3. Drag vertically by a right-click, and then release the mouse.
4. From the shortcut menu, select the series as desired.
Book Store:
Recommended Books:
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Now, Discover Your Strengths
- Business Plans For Dummies®
No comments have been submitted.
