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

AVS Video Editor 9.8.1 Free Download Latest

Vectric Aspire Pro 10.514 Free Download

Revo Uninstaller Pro 4.0.5 Free Download

AVS Video Editor 9.9.2 Free Download Latest

Vectric Aspire Pro 11.55 Free Download

Vectric Aspire Pro 10.514 Download Latest

Devolutions Remote Desktop Manager Free Download

Hide.me VPN Free Download Latest

FastStone Capture 9.6

3uTools 2.29 Free Download Latest