Click here to make this your homepage and get the latest updates
Important KBC Questions        Play KBC here        Need a virtual business assistant        Join us on Facebook        Ghar Baithe Jeeto Jackpot in KBC 2011        KBC Registration details...here        Discuss KBC questions here        UFO defender game :-)       Fashion Show - Girls Game :-)       Click here to make this your homepage and get the latest updates>       Join us on Facebook       
Search
archives
Calendar
May 2012
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  
Mobile

Advanced Excel – Shortcut keys

Here are the list of shorkut keys in excel 2007. Hope this advanced excel helps you in your studies and career.

Category Hold Press Keyword Result
Format Data Ctrl 0 column Hide columns
Format Data Ctrl 1 format Display the Format Cells dialog box
Format Data Ctrl + Shift 2 time Apply Time format
Format Data Ctrl 5 strikethrough Apply or remove strikethrough formatting
Select Cells Ctrl 6 object Alternate between hiding objects, displaying objects, and displaying placeholders for objects
Select Cells Ctrl 7 toolbar Show or hide the Standard toolbar
Outline Data Ctrl 8 outline Display or hide outline symbols
Format Data Ctrl 9 row Hide rows
Enter Data Ctrl copy Copy formula from cell above
Format Data Alt style Style dialog box
Format Data Ctrl + Shift number Apply number format
Edit Data Ctrl - delete Delete selection
Format Data Ctrl + Shift - border Remove outline borders
Format Data Ctrl + Shift ! number Apply Number format with 2 decimal places, thousands separator
Enter Data Ctrl + Shift copy Copy value from cell above
Format Data Ctrl + Shift # date Apply the Date format with the day, month, and year
Format Data Ctrl + Shift $ currency Apply Currency format
Format Data Ctrl + Shift % percent Apply Percentage format with no decimal places
Format Data Ctrl + Shift & border Apply the outline border
Format Data Ctrl + Shift ( row Unhide rows
Format Data Ctrl + Shift ) column Unhide columns
Select Cells Ctrl + Shift * region Select the current region
Move within Selection Ctrl . move Move clockwise to the next corner of the selection
Select Cells Ctrl / array Select current array
Enter Data Ctrl + Shift ; time Enter the time
Enter Data Ctrl ; date Enter the date
Select Cells Alt ; cells Select visible cells in current selection
Select Cells Ctrl [ dependent Select direct dependents
Select Cells Ctrl + Shift [ dependent Select all dependents
Select Cells Ctrl \ difference Select differences
Select Cells Ctrl + Shift \ unequal Select unequal cells
Select Cells Ctrl ] precedent Select direct precedents
Select Cells Ctrl + Shift ] precedent Select all precedents
Format Data Ctrl + Shift ^ number Apply Exponential number format
Enter Data Ctrl ` formula Toggle formula view
Edit Data Ctrl + Shift = insert Insert blank cells
Enter Data Alt = AutoSum Insert the AutoSum formula
Enter Data Ctrl A formula Display Formula Palette after typing function name in formula
Enter Data Ctrl + Shift A formula Insert the argument names and parentheses for a function after you type a function name in a formula
Select Cells Ctrl A All Select the entire worksheet
Enter Data Arrow key move Move one character up, down, left, or right
Move and Scroll Ctrl Arrow key move Move to edge of current region
Move and Scroll Arrow key move Move one cell up, down, left, or right
Select Cells Ctrl + Shift Arrow Key select Extend the selection to the last nonblank cell in the same column or row as the active cell
Select Cells Shift Arrow Key select Extend the selection by one cell
Format Data Ctrl B bold Apply or remove bold formatting
Enter Data Backspace delete Delete character to left of insertion point, or delete selection
Move and Scroll Ctrl Backspace scroll Scroll to display the active cell
Select Cells Shift Backspace select Select only the active cell when multiple cells are selected
Edit Data Ctrl C copy Copy the selection
Enter Data Ctrl D fill Fill down
Enter Data Ctrl Delete delete Delete text to the end of the line
Enter Data Delete delete Delete character to right of insertion point, or delete selection
Enter Data Alt Down Arrow AutoComplete Display the AutoComplete list
Move and Scroll Ctrl End move Move to the last cell on the worksheet
Select Cells Ctrl + Shift End select Extend the selection to the last used cell on the worksheet (lower-right corner)
Enter Data Alt Enter line break Start a new line in the same cell
Enter Data Ctrl Enter fill Fill the selected cell range with current entry
Enter Data Ctrl + Shift Enter array Enter formula as array formula
Enter Data Shift Enter complete Complete cell entry and move up in selection
Enter Data Enter complete Complete cell entry and move down in selection
Enter Data Esc cancel Cancel a cell entry
Menus Esc close Close visible menu or submenu
Windows Ctrl Esc Start Show the Windows Start menu
Menus Shift F10 shortcut Show a shortcut menu
Menus F10 menu Make the menu bar active
Windows Ctrl F10 maximize Maximize or restore the workbook window
Charts F11 chart Create a chart that uses the current range
Macros Alt F11 VBE Display the Visual Basic Editor
Macros Ctrl F11 macro Insert a Microsoft Excel 4.0 macro sheet
Worksheets Shift F11 worksheet Insert a new worksheet
Print Ctrl + Shift F13 print Display the Print dialog box
Charts Alt F2 chart Create a chart that uses the current range
Enter Data Shift F2 comment Edit a cell comment
Enter Data F2 edit Edit the active cell and position the insertion point at the end of the line
Worksheets Alt + Shift F2 worksheet Insert a new worksheet
Enter Data Ctrl F3 name Define a name
Enter Data Ctrl + Shift F3 name Create names from row and column labels
Enter Data Shift F3 function Paste a function into a formula
Enter Data F3 name Paste defined name into formula
Enter Data F4 repeat Repeat the last action
Move and Scroll Shift F4 find Repeat the last Find action (Find Next)
Windows Ctrl F4 close Close the active workbook window
Move and Scroll Shift F5 find Display the Find dialog box
Move and Scroll F5 go to Display the Go To dialog box
Windows Ctrl F5 restore Restore the active workbook window size
Move and Scroll Ctrl F6 window Move to the next workbook or window
Move and Scroll Ctrl+Shift F6 window Move to the previous workbook or window
Move and Scroll Shift F6 pane Move to previous pane in workbook that has been split
Move and Scroll F6 pane Move to next pane in split workbook
Edit Data F7 spell Display the Spelling dialog box
Windows Ctrl F7 move Carry out Move command (workbook icon menu, menu bar), or use arrow keys to move the window
Macros Alt F8 macro Display the Macro dialog box
Select Cells Shift F8 select Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range
Select Cells F8 select Turn on extending a selection by using the arrow keys
Windows Ctrl F8 size Carry out Size command (workbook icon menu, menu bar), or use arrow keys to size the window
Enter Data Ctrl + Alt F9 calculate Calculate all sheets in the active workbook
Enter Data Shift F9 calculate Calculate the active worksheet
Enter Data F9 calculate Calculate all sheets in all open workbooks
Windows Ctrl F9 minimize Minimize the workbook window to an icon
Move and Scroll Ctrl Home move Move to the beginning of the worksheet
Move and Scroll Home move Move to the beginning of the row
Select Cells Ctrl + Shift Home select Extend the selection to the beginning of the worksheet
Select Cells Shift Home select Extend the selection to the beginning of the row
Format Data Ctrl I italic Apply or remove italic formatting
Enter Data Ctrl K hyperlink Insert a hyperlink
Move within Selection Ctrl + Alt Left Arrow move Move left between nonadjacent selections
Outline Data Alt + Shift Left Arrow group Ungroup rows or columns
Select Cells Ctrl + Shift O comment Select all cells with comments
Print Ctrl P print Display the Print dialog box
Move and Scroll Alt Page Down move Move one screen to the right
Move and Scroll Ctrl Page Down move Move to the next sheet in the workbook
Move and Scroll Page Down move Move down one screen
Select Cells Shift Page Down select Extend the selection down one screen
Worksheets Ctrl + Shift Page Down select Select current and next sheet in workbook
Move and Scroll Alt Page Up move Move one screen to the left
Move and Scroll Ctrl Page Up move Move to the previous sheet in the workbook
Move and Scroll Page Up move Move up one screen
Select Cells Shift Page Up select Extend the selection up one screen
Worksheets Ctrl + Shift Page Up select Select current and previous in workbook
Windows Alt Print Screen copy Copy the image of the active window to the Clipboard
Windows Print Screen copy Copy the image of the screen to the Clipboard
Enter Data Ctrl R fill Fill to the right
Move within Selection Ctrl + Alt Right Arrow move Move right between nonadjacent selections
Outline Data Alt + Shift Right Arrow group Group rows or columns
Menus Alt Spacebar menu Show control menu
Select Cells Ctrl Spacebar column Select the entire column
Select Cells Ctrl + Shift Spacebar objects With an object selected, select all objects on a sheet
Select Cells Shift Spacebar row Select the entire row
Move and Scroll Ctrl Tab window Move to the next workbook or window
Move and Scroll Ctrl+Shift Tab window Move to the previous workbook or window
Move within Selection Shift Tab left Move left
Move within Selection Tab right Move right
Windows Alt Tab program Switch to the next program
Windows Alt + Shift Tab program Switch to the previous program
Format Data Ctrl U underline Apply or remove an underline
Edit Data Ctrl V paste Paste the selection
Windows Ctrl W close Close the active workbook window
Edit Data Ctrl X cut Cut the selection
Enter Data Ctrl Y repeat Repeat the last action
Edit Data Ctrl Z undo Undo the last action

Share on Facebook

Leave a Reply

Search
Search
Custom Search
Subscribe here !

Enter your email address:

Delivered by FeedBurner

For any Business Assistance:

Join here on Facebook
Login Status
Polls

Would you give a bribe to get your work done?