Shortcut keys for MS Excel & Windows
Posted On Thursday, July 3, 2008 at at 3:15 PM by AbhishekMicrosoft 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...
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.
thks 4 sharing
regards :)
moon
Thanks for not been stingy in knowledge.. you have a good content there...
Tats quite tactful... nice.. - Amans
Wanted this in all one list and nice to see it here... - Mike
cool dude!!
thanks for sharing :)
Regards
Sarvana
nice to c that ..
Thanks
Adam
Nice yaar ... ;)
Ashutosh
Wow!!! nice list indeed
-- shekar
Keep on posting original post..
Nice
GRATE WORK! HELPED ME ALOT AND I AM REALLY LOOKING FORWARD FOR MOUSE SHORTCUTS ...