Search Contextures Sites
Custom Search

 

More Excel Videos

Excel Videos - Index

Names

Paste Special

Create UserForms

Mouse Shortcuts

 

 

 

 

 

 

 

Excel Quick Tips Videos 05

Create Excel List of Dates by Week   

Change Number of Sheets in New Excel Files  

Customize the Excel 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 Status Bar

Add or remove the features on the Excel 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.

Get All the Excel News

For regular Excel news, tips, videos, and special offers, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

More Excel Tutorial Videos

Excel Videos - Index

Names

Paste Special

Create UserForms

Mouse Shortcuts

 

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

 

Last updated: August 23, 2016 11:06 AM