Archive for category Windows Vista

Excel/Windows: Change default date display format

By default, the “short date” display format for Windows (and thus Excel) is “M/d/yyyy.” For example, June 1, 2011 would be displayed as 6/1/2011. For varying reasons, you may want to zero-fill your dates and have June 1, 2011 read as 06/01/2011. Doing this actually involves a Windows setting, not an Excel setting. So, be prepared to have your dates displayed accordingly across the whole operating system and many other programs.

To change the default date format in Windows:

  1. Go to Start –> Control Panel and select “Regional Settings” or “Region and Language,” depending on your operating system.
  2. In the Short date format list, select the desired format:
    SS-2011.06.01-20.29.12
  3. Click OK.

Now, unless the dates in Excel were formatted using the format menu, they should now display as you’ve defined them.

Advertisements

16 Comments

Windows 7 and Vista: Quick screen zoom with keyboard shortcut

imageThis tip is courtesy this Lifehacker post and applies to all Windows 7 and Vista users. There may be times when zooming in on a program or item on the screen is desirable. In my daily life, I often zoom in when I am showing something on my screen to another person. These keyboard shortcuts make it really quick and easy to zoom in and out using the Magnifier tool in Windows 7 and Vista:

  • Windows key and + will zoom in in 100% increments
  • Windows key and – will zoom back out

With the Magnifier tool up, the following shortcuts are available, according to Lifehacker:

  • CTRL + L to bring up the lens display view
  • CTRL + D to dock the magnification area.
  • CTRL + F brings you back to the full screen mode.

For many other applications (regardless of your Windows version):

If I am using Word, Excel, Acrobat, or any number of other applications, I use CTRL + scroll wheel to zoom in and out of a document. This shortcut does not work on ALL programs, but it is very useful when it does.

13 Comments

%d bloggers like this: