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

5 Google Maps Tips and Tricks to Make You an Expert Navigator

Speed Up Homework: Word Shortcuts Every Student Should Master

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

AVS Video Editor 9.7.3.399 Free Download Latest

GraphPad Prism 8.0.1.244 Free Download

Free Download CFF Explorer Full Version

ON1 Photo RAW 2021.5 v15.5.0.10396

YTD Video Downloader PRO 5.9.12.1 Free Download

Audacity 3.5.0 Download Latest