Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

Categories

Archives

Learn how to create Excel dashboards.

Enter the Time in a Notepad File

I like to use Notepad to make notes as I work. In July, I described how I type .LOG at the top of the Notepad file, so the date and time are automatically entered when the file opens.

That's a handy feature, but I wanted to timestamp the files as I was working to, to record my start and stop times. There are date and time shortcuts in Excel and Access, but unfortunately those shortcuts don't work in Notepad.

I obviously hadn't looked too hard, because today I found the shortcut that I've been looking for -- listed right there on the Edit menu in Notepad. Now, if I want to insert the date and time, I press the F5 key, and it's automatically entered for me.

========================

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>