Enter = Complete Cell Entry & Jump to next cell
Exc = Cancel cell entry

F2
SHIFT + F2 ---------- Edit a cell comment
F2 --------------- Edit the active cell
ALT + F2 --------------- Save As command
ALT + SHIFT + F2 -------- Save command

F4
F4 or Ctrl+Y ------------ Repeat last action
Shift + F4 --------------- Repeat list find (find next)
Ctrl + F4 ---------------- Close the window
Alt + F4 ----------------- Exit
F4 -------------------- insert doller sign in the formula bar (when calculate)

F5
F5 -------------------- Go to a specific cell. For example, C6.

F6
F6 --------------------- Move to the next pane
SHIFT + F6 -------------- Move to the previous pane
CTRL + F6 --------------- Move to the next workbook window
CTRL + SHIFT + F6 -------- Move to the previous workbook window

F7
F7 --------------------- Spelling check of selected text or documents
CTRL + F7 -----------------Move the window

F8
F8 --------------------- Extend a selection
SHIFT + F8 ----------------Add to the selection
CTRL + F8 ----------------- Resize the window
ALT + F8 ----------------- Display the Macro dialog box

F9
F9 --------------------- Calculate all sheets in all open workbooks
SHIFT + F9 -------------- Calculate the active workbook
CTRL + F9 --------------- Minimise the active workbook

F10
No important task

F11
F11 -------------------- Create a chart
Shift + F11 --------------- Insert new workbook
Alt + F11 -------------------- Display visual Basic Editor

F12
F12 --------------------- Save As command
Shift + F12 ---------------- Save command
Alt + F12 ------------------ Open command
Ctrl + Shift + F12 ------------ Print Command

CTRL
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 + 7 ------------------------Show & hide standard toolbar
Ctrl + 9 ------------------------Hide rows
Ctrl + Shift + ( -----------------Unhind rows
Ctrl + 0 ----------------------- Hide columns
Ctrl + Shift + ) -----------------Unhind columns
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 + ' ----------------- Insert the value of the above cell into cell currently selected.
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
Ctrl + _ ------------- Delete the selection
Ctrl + Shift + +(plus) -------- Insert blank cell

ALT
Alt + = -------------------- Create a formula to sum all of the above cells

More Shortcut Key :- View Pivot Table Shortcut Key in Pivot Table Menu


Stay Connected With Free Updates

Subscribe via Email
You can leave a response, or trackback from your own site.

Pijush Roy, Founder & Author of "Share Your Knowledge", is a young freelance blogger, a reader, a painter, .....read more


Followers

IMPORTANT LINK/URLs

m