Here is a guide to the most useful keyboard shortcuts in Ms Excel that you should start using today.
Ctrl+A -- Select All
Ctrl+B -- Bold
Ctrl+C -- Copy
Ctrl+D -- Fill Down
Ctrl+F -- Find
Ctrl+G -- Goto
Ctrl+H -- Replace
Ctrl+I -- Italic
Ctrl+K -- Insert Hyperlink
Ctrl+N -- New Workbook
Ctrl+O -- Open
Ctrl+P -- Print
Ctrl+R -- Fill Right
Ctrl+S -- Save
Ctrl+U -- Underline
Ctrl+V -- Paste
Ctrl W -- Close
Ctrl+X -- Cut
Ctrl+Y -- Redo
Ctrl+Z -- Undo
F1 -- Help
F2 -- Edit
F3 -- Paste Name
F4 -- Repeat last action
F4 -- fixed reference
F5 -- Goto
F6 --Next Pane
F7 -- Spell check
F9 -- Recalculate all workbooks
F10 -- Activate Menubar
F11 -- New Chart
F12 -- Save As
Ctrl+: -- Insert Current Time
Ctrl+; -- Insert Current Date
Ctrl+" -- Copy Value from Cell Above
Ctrl+’ -- Copy Formula from Cell Above
Shift+F2 -- Edit cell comment
Shift+F3 -- Paste function into formula
Shift+F4 -- Find Next
Shift+F5 -- Find
Shift+F6 -- Previous Pane
Shift+F8 -- Add to selection
Shift+F9 -- Calculate active worksheet
Ctrl+Alt+F9 -- Calculate all worksheets in all open workbooks.
Shift+F10 -- Display shortcut menu
Shift+F11 -- New worksheet
Shift+F12 -- Save
Ctrl+F3 -- Define name
Ctrl+F4 -- Close
Ctrl+F5 -- Restore window size
Ctrl+F6 -- Next workbook window
Shift+Ctrl+F6 -- Previous workbook window
Ctrl+F7 -- Move window
Ctrl+F -- Resize window
Ctrl+F9 -- Minimize workbook
Ctrl+F10 -- Maximize or restore window
Ctrl+F11 -- Inset 4.0 Macro sheet
Ctrl+F12 -- File Open
Alt+F1 -- Insert Chart
Alt+F2 -- Save As
Alt+F4 -- Exit
Ctrl+Shift+F3 -- Create name by using names of row and column labels
Ctrl+Shift+F6 -- Previous Window
Ctrl+Shift+F12 -- Print
Alt+Shift+F1 -- New worksheet
Alt+Shift+F2. -- Save
Alt+= -- AutoSum
Ctrl+` -- Toggle Value/Formula display
Ctrl+Shift+A -- Insert argument names into formula
Ctrl+Shift+~ -- General format
Ctrl+Shift+! -- Comma format
Ctrl+Shift+@ -- Time format
Ctrl+Shift+# -- Date format
Ctrl+Shift+$ -- Currency format
Ctrl+Shift+% -- Percent format
Ctrl+Shift+^ -- Exponential format
Ctrl+Shift+& -- Place outline border around selected cells
Ctrl+Shift+_ -- Remove outline borders
Ctrl++ -- Insert
Ctrl+- -- Delete
Ctrl+1 -- Forma cells dialog box
Ctrl+2 -- Bold
Ctrl+3 -- Italic
Ctrl+4 -- Underline
Ctrl+5 -- Strikethrough
Ctrl+6 -- Show/Hide objects
Ctrl+7 -- Show/Hide Standard toolbar
Ctrl+8 -- Toggle Outline symbols
Ctrl+9 -- Hide rows
Ctrl+0 -- Hide columns
Ctrl+Shift+( -- Unhide rows
Ctrl+Shift+) -- Unhide columns
Alt or F10 -- Activate the menu
Alt+Enter -- Start a new line in the same cell.
Ctrl+Enter -- Fill the selected cell range with the current entry.
F3 -- Find Next
F4 -- Properies Window
F5 -- Run Sub/Form or Run Macro
F6 -- Switch Split Windows
F7 -- View Code Window
F8 -- Step Into
F9 -- Toggle Breakpoint
F10 -- Activate Menu Bar
Shift+F2 -- View definition
Shift+F3 -- Find Previous
Shift+F7 -- View Object
Shift+F8 -- Step Over
Shift+F9 -- Quick Watch
Shift+F10 -- Show Right Click Menu
Ctrl+F2 -- Focus To Object Box
Ctrl+F4 -- Close Window
Ctrl+F8 -- Run To Cursor
Ctrl+F10 -- Activate Menu Bar
Alt+F4 -- Close VBE
0 Comments