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

Shutter Count 1.36 Free Download Latest

Vectric Aspire Pro 11.55 Free Download

System Mechanic Pro 20.3.2.97 Free Download

Free Cute Birthday Invitation Template in Word (Editable & Printable)

ZebraDesigner Pro 2.9.2

Clip Studio Paint EX 1.6.2

TCX Converter [Latest]

SketchUp Pro 2019 Free Download

Glary Utilities 5.111.0.136 Free Download

Fxr Foxer 9.8.6.2