|
|
Search
Contextures Sites
|
||
|
|
|
|||
Contextures Inc., Copyright ©2010
All rights reserved.
Search Contextures Sites
Search Contextures Sites
Excel Quick Tips Videos 05
Create Excel List of Dates by Week
Change Number of Sheets in New Excel Files
Customize the Excel 2007 Status Bar
Enter Dates and Times in Excel
Create an Excel List of Dates by Week
Use the AutoFill handle to create a list of dates, in one week intervals. With the Series dialog box, you can set the Step interval to 7, and each date will be 7 days after the previous date.
See more Excel Data Entry Tips.
Change Number of Sheets in New Excel Files
You don't have to live with the default number of sheets in a new Excel file. Instead of having 3 blank sheets in each new workbook, you can reduce the number, or increase it.
See more Excel Tips and Tutorials.
Customize the Excel 2007 Status Bar
Add or remove the features on the Excel 2007 Status Bar. For example, add new summary functions in the AutoCalc section. Or, show the status of special keys, such as Caps Lock or Num Lock..
See more Excel Tips and Tutorials.
Enter Dates and Times in Excel
Use the TODAY function to add the current date to a worksheet, and have it update automatically when the workbook is opened or the worksheet is calculated.
Use the NOW function to add the current date and time to a worksheet, and have it update automatically when the workbook is opened or the worksheet is calculated.
To enter the current date, and have it remain static, use the keyboard shortcut, Ctrl + ;
To enter the current time, and have it remain static, use the keyboard shortcut, Ctrl + Shift + ;
See more Excel Data Entry Tips.
Contextures Inc., Copyright ©2010
All rights reserved.
Search Contextures Sites
Last updated: January 6, 2010 10:24 PM
