MICROSOFT OFFICE TUTOR: Add date and time data to your worksheet instantly

Are you one of those people who need to check today’s date constantly? The habit is understandable — you have a lot of information to remember and sometimes you need a little help. Or maybe you know the date and time but get tired of entering it in your spreadsheet manually.

You don’t have to worry about the present moment anymore. Excel can insert date and time information automatically using just a few quick shortcut keys. Check out Table A for valuable date entry shortcut keys.

Table A:
Date and time shortcut keys

Inserts … Windows Mac
Current date [Ctrl]; [control];
Current time [Ctrl][Shift]; [control][shift];
http://www.officeskillssociety.com/wp-content/plugins/sociofluid/images/digg_32.png http://www.officeskillssociety.com/wp-content/plugins/sociofluid/images/reddit_32.png http://www.officeskillssociety.com/wp-content/plugins/sociofluid/images/stumbleupon_32.png http://www.officeskillssociety.com/wp-content/plugins/sociofluid/images/delicious_32.png http://www.officeskillssociety.com/wp-content/plugins/sociofluid/images/technorati_32.png http://www.officeskillssociety.com/wp-content/plugins/sociofluid/images/google_32.png http://www.officeskillssociety.com/wp-content/plugins/sociofluid/images/myspace_32.png http://www.officeskillssociety.com/wp-content/plugins/sociofluid/images/facebook_32.png http://www.officeskillssociety.com/wp-content/plugins/sociofluid/images/twitter_32.png

Leave a Reply