Friday, June 8, 2012

Graphic Hotkeys

bulletCtrl+Alt+F1: enable attached monitor
bulletCtrl+Alt+F3: enable notebook
bulletCtrl+Alt+F12: invoke the graphics properties
bulletCtrl+Alt+Up: rotate screen 180 degrees
bulletCtrl+Alt+Left: rotate screen left 90 degrees
bulletCtrl+Alt+Down: rotate screen 0 degrees
bulletCtrl+Alt+Right: rotate screen right 90 degreeshttp://www.compulink-support.com/technotes/hotkey.htm

Tuesday, March 20, 2012

Excel negative time

To display the number correctly, do either of the following:
  • Change the date system to the 1904 date system.

    -or-
  • Use the TEXT worksheet function to change the displayed result.

Steps to Change to the 1904 Date System

In Microsoft Office Excel 2003 and in earlier versions of Microsoft Excel, follow these steps:
  1. Open, or switch to, the workbook.
  2. On the Tools menu, click Options, and then click the Calculation tab.
  3. Click to select the 1904 Date System check box.
  4. Click OK.

In Microsoft Office Excel 2007, follow these steps:

  1. Click the Microsoft Office Button, and then click Excel Options.
  2. Click the Advanced category.
  3. Under When calculating this workbook, click to select the Use 1904 date system check box, and then click OK.

Adding Excel Times Greater Than 24 Hours/Showing Excel Times Past 24 Hours

To force Excel not to default back to a new day after 24 hours we use a cell Format of 37:30:55 or a Custom format of [h]:mm:ss

http://www.ozgrid.com/Excel/times-past-24.htm

Wednesday, March 7, 2012

On Word, how can I make the first letter do that big fancy thing?

Like, you know how in books in the start of the chapter, the first letter is sometimes real big? I wanna do that!! But I don't know how. I'm using Microsoft Office Word 2003.

Best Answer
- Chosen by Voters
Go to Format, then Drop Cap. Click Dropped and change the settings as needed.

http://answers.yahoo.com/question/index?qid=20080830040129AAlTdeU

Thursday, February 16, 2012

reminder to telax your eyes

1) http://eyes-relax.en.softonic.com/ (MS Windows)

2) http://www.workrave.org/ (MS + Linux)

Friday, September 23, 2011

How to add the Print Directory feature for folders in Windows XP, in Windows Vista, in Windows 7

Source: http://support.microsoft.com/kb/321379

Windows Vista or Windows 7

Step 1: Create the Printdir.bat file

To do this, follow these steps:
  1. Click Start, click Run, type notepad, and then click OK.
  2. Paste the following text into Notepad:
    @echo off
    dir %1 /-p /o:gn > "%temp%\Listing"
    start /w notepad /p "%temp%\Listing"
    del "%temp%\Listing"
    exit
  3. On the File menu, click Exit, and then click Yes to save the changes.
  4. In the Save As dialog box, type the following text in the File name box, and then click Save:
    %windir%\Printdir.bat

    Note If you receive a dialog box that says you don't have permission to save in this location, you can save the file to the desktop. Next, you click Start, click Run, type %windir%, and then click OK. Then, you can copy the file from the desktop to the location.

Step 2: Edit the registry

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
  1. Click Start, click Run, type Notepad, and then click OK.
  2. Type the following commands in Notepad.
    Windows Registry Editor Version 5.00

    [HKEY_CLASSES_ROOT\Directory\Shell]
    @="none"

    [HKEY_CLASSES_ROOT\Directory\Shell\Print_Directory_Listing]
    @="Print Directory Listing"

    [HKEY_CLASSES_ROOT\Directory\shell\Print_Directory_Listing\command]
    @="Printdir.bat \"%1\""

    [HKEY_CLASSES_ROOT\SOFTWARE\Classes\Directory]
    "BrowserFlags"=dword:00000008

    [HKEY_CLASSES_ROOT\SOFTWARE\Classes\Directory\shell\Print_Directory_Listing]
    @="Print Directory Listing"

    [HKEY_CLASSES_ROOT\SOFTWARE\Classes\Directory\shell\Print_Directory_Listing\command]
    @="Printdir.bat \"%1\""

    [HKEY_CURRENT_USER\Software\Microsoft\Windows\Shell\AttachmentExecute\{0002DF01-0000-0000-C000-000000000046}]
    @=""

    [HKEY_CLASSES_ROOT\SOFTWARE\Classes\Directory]
    "EditFlags"="000001d2"
    On the File menu, click Save As.
  3. In the Save in list, click Desktop.
  4. In the File name box, type PrintDirectoryListing.reg, click All Files in the Save as type list, and then click Save.
  5. On the desktop, double-click the PrintDirectoryListing.reg file to add the registry keys to the Windows registry.
  6. Click OK in the message box.

Tuesday, June 7, 2011

Date format that includes day of week

You will need to use a custom formula. Go to Format-Cells, and select Custom. Type in:

dddd, mm/dd/yyyy

Source: http://www.mrexcel.com/archive/Dates/7591.html