The Ultimate Microsoft Excel Shortcuts Guide (With Explanations)

 

BASIC EXCEL SHORTCUTS
Shortcut	Function	Explanation
Ctrl + N	New Workbook	Creates a new blank Excel file.
Ctrl + O	Open	Opens an existing workbook.
Ctrl + S	Save	Saves the current workbook.
F12	Save As	Opens “Save As” dialog box.
Ctrl + P	Print	Opens print options.
Ctrl + W	Close Workbook	Closes the active Excel file.
Alt + F4	Exit Excel	Closes Excel completely.
EDITING SHORTCUTS
Shortcut	Function	Explanation
Ctrl + C	Copy	Copies selected data.
Ctrl + X	Cut	Cuts (moves) selected data.
Ctrl + V	Paste	Pastes copied or cut data.
Ctrl + Z	Undo	Reverses last action.
Ctrl + Y	Redo	Repeats last undone action.
Delete	Clear Cell Content	Removes cell contents but not formatting.
F2	Edit Cell	Enables you to edit the active cell directly.
NAVIGATION SHORTCUTS
Shortcut	Function	Explanation
Arrow Keys	Move	Moves one cell up, down, left, or right.
Ctrl + Arrow Key	Jump	Moves to the end of a data region.
Home	Go to Start	Moves to the beginning of the row.
Ctrl + Home	Go to A1	Moves to cell A1.
Ctrl + End	Go to Last Cell	Moves to the last used cell.
Page Up / Page Down	Scroll	Moves up or down one screen.
SELECTING DATA
Shortcut	Function	Explanation
Ctrl + A	Select All	Selects entire worksheet.
Shift + Arrow Keys	Extend Selection	Extends the selection by one cell.
Ctrl + Shift + Arrow Key	Select Range	Selects to the last cell in the data region.
Ctrl + Space	Select Column	Selects the entire column.
Shift + Space	Select Row	Selects the entire row.
FORMATTING SHORTCUTS
Shortcut	Function	Explanation
Ctrl + 1	Format Cells	Opens Format Cells dialog.
Ctrl + B	Bold	Toggles bold text.
Ctrl + I	Italic	Toggles italic text.
Ctrl + U	Underline	Toggles underline.
Alt + H + A + C	Center Align	Centers text in a cell.
Ctrl + Shift + $	Currency Format	Applies currency format.
Ctrl + Shift + %	Percentage Format	Applies percentage format.
FORMULAS & DATA
Shortcut	Function	Explanation
=	Start Formula	Begins a formula in a cell.
Alt + =	AutoSum	Inserts SUM formula automatically.
Ctrl + ‘	Copy Formula	Copies formula from cell above.
F4	Absolute Reference	Repeats last action or toggles $ references (e.g., $A$1).
Ctrl + Shift + Enter	Array Formula	Enters formula as an array formula.
WORKBOOK AND WORKSHEET MANAGEMENT
Shortcut	Function	Explanation
Ctrl + Page Up	Previous Sheet	Moves to the previous worksheet.
Ctrl + Page Down	Next Sheet	Moves to the next worksheet.
Shift + F11	New Worksheet	Inserts a new worksheet.
Alt + E + L	Delete Sheet	Deletes the current worksheet.
Ctrl + F4	Close Workbook	Closes the active workbook.
SEARCH AND REPLACE
Shortcut	Function	Explanation
Ctrl + F	Find	Opens the Find dialog box.
Ctrl + H	Replace	Opens the Find and Replace dialog box.
DATA MANAGEMENT SHORTCUTS
Shortcut	Function	Explanation
Ctrl + T	Create Table	Converts data into a table.
Alt + A + T	Filter	Adds or removes filters.
Alt + D + S	Sort	Opens sort dialog box.
Ctrl + ;	Insert Date	Inserts the current date.
Ctrl + Shift + :	Insert Time	Inserts the current time.
SPECIAL & TIME-SAVING
Shortcut	Function	Explanation
Ctrl + D	Fill Down	Copies cell above into selected cell.
Ctrl + R	Fill Right	Copies cell on the left into selected cell.
Ctrl + Shift + L	Toggle Filter	Turns filters on/off.
Alt + Enter	Line Break	Starts a new line within a cell.
Ctrl + `	Show Formulas	Toggles between showing formulas and results.

 Kusoo Biir Telegram-keena

Kala Soco Qormooyin Iyo Buugtaagta Cilmiga

E N G   C O L A A D

Personal Blog   |   Journalist   |   Graphic Design

WhatsApp: 0615980809