Shortcut keys for MS Excel & Windows



Microsoft Excel Shortcut Keys
  • F7 Spell check selected text and or document.
  • F11 Create chart.
  • Ctrl + Shift + ; Enter the current time
  • Ctrl + ; Enter the current date
  • Alt + Shift + F1 Insert New Worksheet
  • Shift + F3 Open the Excel formula window.
  • Shift + F5 Bring up search box.
  • Ctrl + A Select all contents of the worksheet.
  • Ctrl + B Bold highlighted selection.
  • Ctrl + I Italic highlighted selection.
  • Ctrl + K Insert link.
  • Ctrl + U Underline highlighted selection.
  • Ctrl + 5 Strikethrough highlighted selection.
  • Ctrl + P Bring up the print dialog box to begin printing.
  • Ctrl + Z Undo last action.
  • Ctrl + F9 Minimize current window.
  • Ctrl + F10 Maximize currently selected window.
  • Ctrl + F6 Switch between open workbooks / windows.
  • Ctrl + Page up Move between Excel work sheets in the same Excel document.
  • Ctrl + Page down Move between Excel work sheets in the same Excel document.
  • Ctrl + Tab Move between Two or more open Excel files.
  • Ctrl + Shift + ! Format number in comma format.
  • Ctrl + Shift + $ Format number in currency format.
  • Ctrl + Shift + # Format number in date format.
  • Ctrl + Shift + % Format number in percentage format.
  • Ctrl + Shift + ^ Format number in scientific format.
  • Ctrl + Shift + @ Format number in time format.
  • Ctrl + Arrow key Move to next section of text.
  • Ctrl + Space Select entire column.
  • Shift + Space Select entire row

Microsoft Windows Shortcut Keys

  • Alt + Tab 3.X / 95 / 98 / NT / 2000 / XP Switch between open applications.
  • Alt + Shift + Tab 3.X / 95 / 98 / NT / 2000 / XP Switch backwards between open applications.
  • Alt + Print Screen 3.X / 95 / 98 / NT / 2000 / XP Create a screen shot only for the program you are currently in.
  • Ctrl + Esc 95 / 98 / NT / 2000 / XP Bring Up start button.
  • Alt + Esc 95 / 98 / NT / 2000 / XP Switch Between open applications on taskbar.
  • F2 3.X / 95 / 98 / NT / 2000 / XP Renames selected Icon
  • F3 95 / 98 / NT / 2000 / XP Starts find from desktop
  • F4 95 / 98 / NT / 2000 / XP Opens the drive selection when browsing.
  • F5 95 / 98 / NT / 2000 / XP Refresh Contents
  • Alt + F4 3.X / 95 / 98 / NT / 2000 / XP Closes Current open program.
  • Ctrl + F4 3.X / 95 / 98 / NT / 2000 / XP Closes Window in Program
  • Ctrl + (the '+' key on the keypad) 98 / NT / 2000 / XP Automatically adjust the width's of all the columns in Windows explorer
  • Alt + Enter 95 / 98 / NT / 2000 / XP Opens properties window of Selected icon or program.
  • Shift + F10 95 / 98 / NT / 2000 / XP Simulates right click on selected item.
  • Shift + Del 95 / 98 / NT / 2000 / XP Delete programs/files without throwing into the recycle bin.
  • Holding Shift 3.X / 95 / 98 / NT / 2000 / XP Boot safe mode or by pass system files.
  • Holding Shift 95 / 98 / NT / 2000 / XP When putting in an audio CD will prevent CD Player from playing.

Windows Keyboard Shortcut Keys
Below is a listing of Windows keys that can be used on computers running a Microsoft Windows operating system and using a keyboard with a Windows key. In the below list of shortcuts the windows key is represented by "WINKEY".

  • WINKEY + D Minimizes all windows and returns the user to the desktop.
  • WINKEY + M Minimizes all windows. WINKEY + SHIFT + M Undo the minimize.
  • WINKEY + E Open Microsoft Explorer.
  • WINKEY + Tab Cycle through open programs through the taskbar.
  • WINKEY + F Display the Windows Search / Find feature.
  • WINKEY + CTRL + F Display the search for computers window.
  • WINKEY + F1 Display the Microsoft Windows help.
  • WINKEY + R Open the run window.
  • WINKEY + Pause / Break key Open the system properties window.
  • WINKEY + U Open Utility Manager.
  • WINKEY + L Lock the computer (Windows XP and above only)

Coming soon...

  • Mouse Shortcuts
  • Internet Explorer Shortcut keys
  • Add this post to your favorites in times of need this can come handy when you dont remember some shortcuts.
    If you like the post , Kindly post a comment/provide rating at bottom of page.

    Posted in Labels: |

    11 comments:

    1. Anonymous Says:

      thks 4 sharing

      regards :)
      moon

    2. Linus Says:

      Thanks for not been stingy in knowledge.. you have a good content there...

    3. Anonymous Says:

      Tats quite tactful... nice.. - Amans

    4. Anonymous Says:

      Wanted this in all one list and nice to see it here... - Mike

    5. Anonymous Says:

      cool dude!!

    6. Anonymous Says:

      thanks for sharing :)

      Regards
      Sarvana

    7. Anonymous Says:

      nice to c that ..

      Thanks
      Adam

    8. Anonymous Says:

      Nice yaar ... ;)

      Ashutosh

    9. Anonymous Says:

      Wow!!! nice list indeed

      -- shekar

    10. Anonymous Says:

      Keep on posting original post..

      Nice

    11. Anonymous Says:

      GRATE WORK! HELPED ME ALOT AND I AM REALLY LOOKING FORWARD FOR MOUSE SHORTCUTS ...

     
    counter hit make Add to Technorati Favorites