MS Excel Shortcut keys - PDF Download

MS Excel Shortcut Keys, Find Here MS Excel Shortcut Keys PDF to accomplish multiple tasks in an efficient way with little effort. Excel Shortcut Keys
MS Excel Shortcut keys PDF

MS Excel Shortcut keys PDF - Basically, everyone uses MS Excel or Microsoft Excel to analyze, share and manage information for accounting purposes doing mathematical calculations, budgeting, billing, etc. MS Excel is a very useful tool for data management and analysis. It's easy to use, has tons of features, and is very flexible. It is also an extremely popular tool among students and professionals as a data management and analysis tool.

MS Excel Shortcut keys PDF

MS Excel Shortcut Keys allow you to enter text or perform other actions faster than if you had to use the mouse or trackpad. In MS Excel, the most common shortcut keys are the function keys, which allow you to access certain functions with a keystroke.

In this blog, we have provided the list of shortcut keys for excel and I have included a few of the most useful ones to help you work faster, and here you can download the MS Excel shortcut keys PDF by using the direct download link which is given at the bottom of this blog.

List of MS Excel Shortcut keys

Shortcut KeysFunctions
Ctrl+FSearch current sheet.
Ctrl+GGo to a certain area.
Ctrl+HFind and replace.
Ctrl+IPuts italics on all cells in the highlighted section.
Ctrl+KInserts a hyperlink.
Ctrl+LOpens the Create Table dialog box.
Ctrl+RFill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.
Ctrl+HomeMove to cell A1.
Ctrl+EndMove to the last cell with text on the worksheet.
Ctrl+Shift+POpens the drop-down menu for the point size.
Shift+InsertPastes what is stored on the clipboard.
Shift+Page UpIn a single column, highlight all cells above that are selected.
Shift+Page DownIn a single column, highlight all cells above that are selected.
Shift+HomeHighlights all text to the left of the cursor.
Shift+EndHighlights all text to the right of the cursor.
Shift+Up ArrowExtends the highlighted area up to one cell.
Shift+Down ArrowExtends the highlighted area down one cell.
Shift+Left ArrowExtends the highlighted area left one character.
Shift +Right ArrowExtends the highlighted area right one character.
Ctrl+SSaves the open worksheet.
Ctrl+ZUndo the last action.
Ctrl+1Changes the format of the selected cells.
Ctrl+2Bolds all cells in the highlighted section.
Ctrl+TOpen the Create Table dialog box.
Ctrl+WCloses the current workbook.
Ctrl+XCuts all cells in the highlighted section.
Ctrl+YRepeats the last entry.
Ctrl+UUnderlines all cells in the highlighted section.
Ctrl+VPastes everything copied onto the clipboard.
F1Opens the help menu.
F2Edits the selected cell.
F3After a name is created, F3 will paste names.
F4Repeats the last action. For example, if you changed the color of the text in another cell, pressing F4 will change the text in the cell to the same color.
F5Goes to a specific cell. For example, C6.
F6Move to the next pane.
F7Spell check selected text or document.
F8Enters Extend Mode.
F9Recalculates every workbook.
F10Activates the menu bar.
F11Creates a chart from selected data.
F12Save As option.
Alt+Shift+F2Saves the current worksheet.
Ctrl+NCreates a new workbook.
Ctrl+OOpens a workbook.
Ctrl+PPrint the current sheet.
Ctrl+3Puts italics on all cells in the highlighted section.
Ctrl+4Underlines all cells in the highlighted section.
Ctrl+5Puts a strikethrough all cells in the highlighted section.
Ctrl+6Shows or hides objects.
Ctrl+7Shows or hides the toolbar.
Ctrl+8Toggles the outline symbols.
Ctrl+9Hides rows.
Ctrl+0Hides columns.
Ctrl+Shift+:Enters the current time.
Ctrl+;Enters the current date.
Ctrl+`Changes between displaying cell values or formulas in the worksheet.
Ctrl+’Copies a formula from the cell above.
Ctrl+Shift+”Copies value from the cell above.
Ctrl+-Deletes the selected column or row.
Ctrl+Shift+=Inserts a new column or row.
Ctrl+Shift+~Switches between showing Excel formulas or their values in cells.
Ctrl+Shift+!Applies comma formatting.
Ctrl+Shift+$Applies currency formatting.
Ctrl+Shift+#Applies date formatting.
Ctrl+Shift+%Applies percentage formatting.
Ctrl+Shift+^Applies exponential formatting.
Ctrl+Shift+*Selects the current region around the active cell.
CTRL+SHIFT+;Enter the current Time
CTRL+;Enter the current date
Shift+F3Open the Insert Function window
Shift+F5Opens Find and replace dialog box
CTRL+ASelect all contents of the worksheets
CTRL+BBold highlighted selection
CTRL+IItalic highlighted selection
CTRL+KInsert Link
CTRL+UUnderline highlighted selection
CTRL+PBring out the print dialog box to being prating
CTRL+ZUndo the last action
CTRL+F9Minimize current workbook
CTRL+F10Minimize currently selected workbook
CTRL+F6Switch between open workbooks/ Windows
CTRL+Page Up Move the previous sheet between Excel worksheet in the same Excel
document
CTRL+PBeing up the print dialog box to being printing
CTRL+ZUndo the last action
CTRL+ Page DownMove the next sheet between Excel worksheet in the same Excel document
CTRL+ TabMove between or more open Excel Files
ALT+=Create a formula to sum all of the above cells
Shift + homeGo to the first cell in the current row
CTRL + shift+!Format number in comma format
CTRL + shift+$Format number in currency format
CTRL + shift+#Format number in date format
CTRL + shift+%Format number in percentage format
CTRL + [email protected]Format number in time format
CTRL+ SPACESelect entire column
SHIFT+SPACESelect entire row

MS Excel Shortcut keys PDF Download

Click on this download button to download MS Excel Shortcut Keys PDF. You must have a PDF reader application on your phone or PC to view this PDF file.

Windows MacOs Join on Telegram

Post a Comment