Contextures

Excel Quick Tips Videos 05

Short videos show how to create list of dates by week, set number of sheets in new file, customize status bar, use date shortcuts

Create a 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 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

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 Videos

Excel Videos Index

Names

Paste Special

Create UserForms

Mouse Shortcuts

Search Contextures Sites

 

Excel Tools Add-in

 

 

 

Last updated: December 28, 2016 1:11 PM
Contextures RSS Feed