Home>> Excel >> Tips >> 20 essential keyboard shortcuts in Microsoft Excel

20 essential keyboard shortcuts in Microsoft Excel

Also Read


Shortcut Key Action / Function Description
Ctrl + CCopyCopies the selected cells or content to the clipboard.
Ctrl + VPastePastes the copied or cut content into the selected cell or range.
Ctrl + XCutCuts the selected cells to move them elsewhere.
Ctrl + ZUndoReverses the last action, helpful when you make a mistake.
Ctrl + YRedoReapplies the last undone action.
Ctrl + SSaveSaves the current Excel workbook.
Ctrl + PPrintOpens the Print dialog to print the sheet.
Ctrl + FFindSearches for specific text or values in the sheet.
Ctrl + HFind and ReplaceFinds and replaces specific content in the workbook.
Ctrl + ASelect AllSelects the entire worksheet or data region.
Ctrl + Arrow KeyMove to EdgeMoves to the edge of data in a direction; useful for navigating large tables.
Ctrl + SpaceSelect ColumnSelects the entire column of the active cell.
Shift + SpaceSelect RowSelects the entire row of the active cell.
Ctrl + Shift + LToggle FilterAdds or removes filters in a data range.
Ctrl + TCreate TableConverts a range into an Excel Table with filtering and formatting.
Alt + =AutoSumInserts the SUM function for adjacent numbers.
F2Edit CellActivates in-cell editing for the selected cell.
Ctrl + Shift + "+" (plus)Insert CellsInserts rows or columns at the current selection.
Ctrl + "-" (minus)Delete CellsDeletes selected cells, rows, or columns.
Ctrl + 1Format CellsOpens the Format Cells dialog for detailed formatting options.

Popular posts from this blog

Vectric Aspire Pro 11.55 Free Download

SoftEther VPN Gate Client Plugin 2024.07.07 build 9799

Deep Freeze 8.62.020.5630 Free Download

Canon LASER SHOT LBP-1210

Facebook Desktop Messenger Free Download

Vectric Aspire Pro 10.514 Download Latest

Apowersoft Screen Recorder 3.0.6 Full Version

Opera GX 109.0.5097.108 (64-bit)

Ontrack EasyRecovery Pro 16.0.0.2

How to Turn Off Private Browsing Mode on an Apple iPad