Shortcut keys of MS-Excel And PDF
Shortcut keys of MS- Excel And PDF. Everyone basically use MS- Excel for analysing, sharing and managing information for accounting purpose performing mathematical calculations, budgeting, billing etc. If you knew about all shortcut keys of Excel so you can do your work in computer fast. If you don't know about Excel shortcut keys, in this post we will give you Excel all shortcut keys PDF.

Shortcut keys of MS-Excel [PDF Download]

Shortcut keys of MS-Excel
Ctrl+F Search current sheet.
Ctrl+G Go to a certain area.
Ctrl+H Find and replace.
Ctrl+I Puts italics on all cells in the highlighted section.
Ctrl+K Inserts a hyperlink.
Ctrl+L Opens the Create Table dialog box.
Ctrl+R Fill 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+Home Move to cell A1.
Ctrl+End Move to last cell with text on the worksheet.
Ctrl+Shift+P Opens the drop-down menu for point size.
Shift+Insert Pastes what is stored on the clipboard.
Shift+Page Up In a single column, highlights all cells above that are selected.
Shift+Page Down In a single column, highlights all cells above that are selected.
Shift+Home Highlights all text to the left of the cursor.
Shift+End Highlights all text to the right of the cursor.
Shift+Up Arrow Extends the highlighted area up one cell.
Shift+Down Arrow Extends the highlighted area down one cell.
Shift+Left Arrow Extends the highlighted area left one character.
Shift +Right Arrow Extends the highlighted area right one character.
Ctrl+S Saves the open worksheet.
Ctrl+Z Undo the last action.
Ctrl+1 Changes the format of the selected cells.
Ctrl+2 Bolds all cells in the highlighted section.
Ctrl+T Open the Create Table dialog box.
Ctrl+W Closes the current workbook.
Ctrl+X Cuts all cells in the highlighted section.
Ctrl+Y Repeats the last entry.
Ctrl+U Underlines all cells in the highlighted section.
Ctrl+V Pastes everything copied onto the clipboard.
F1 Opens the help menu.
F2 Edits the selected cell.
F3 After a name is created, F3 will paste names.
F4 Repeats last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color.
F5 Goes to a specific cell. For example, C6.
F6 Move to the next pane.
F7 Spell check selected text or document.
F8 Enters Extend Mode.
F9 Recalculates every workbook.
F10 Activates the menu bar.
F11 Creates a chart from selected data.
F12 Save As option.
Alt+Shift+F2 Saves the current worksheet.
Ctrl+N Creates a new workbook.
Ctrl+O Opens a workbook.
Ctrl+P Print the current sheet.
Ctrl+3 Puts italics all cells in the highlighted section.
Ctrl+4 Underlines all cells in highlighted section.
Ctrl+5 Puts a strikethrough all cells in the highlighted section.
Ctrl+6 Shows or hides objects.
Ctrl+7 Shows or hides the toolbar.
Ctrl+8 Toggles the outline symbols.
Ctrl+9 Hides rows.
Ctrl+0 Hides 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 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+F3 Open the insert Function window
Shift+F5 Opens Find and replace dialog box
CTRL+A Select all contents of the worksheets
CTRL+B Bold highlighted selection
CTRL+I Italic highlighted selection
CTRL+K Insert Link
CTRL+U Underline highlighted selection
CTRL+P Bring out the print dialog box to being prating
CTRL+Z Undo the last action
CTRL+F9 Minimize current workbook
CTRL+F10 Minimize current selected workbook
CTRL+F6 Switch between open workbooks/ Windows
CTRL+ Page Up Move the previous sheet between Excel worksheet in the same Excel
document
CTRL+P Being up print dialog box to being printing
CTRL+Z Undo the last action
CTRL+ Page Down Move the next sheet between Excel worksheet in the same Excel document
CTRL+ Tab Move between or more open Excel Files
ALT+= Create a formula to sum all of the above cell
Shift + home Go 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 + shift+@ Format number in time format
CTRL+ SPACE Select entire column
SHIFT+SPACE Select entire row

Additional information
1 Microsoft PowerPoint shortcuts keys
2 Most important keyboard shortcuts keys
3 Microsoft Word shortcuts keys
I hope this shortcut keys (MS-Excel) will be helpful for your work in Excel. Don't forget to comment and share this post!

Download Shortcut keys of MS-Excel [PDF]

Download PDF

Post a Comment

Previous Post Next Post
× DMCA!Bilimtook.com is in compliance with 17 U.S.C. * 512 and the Digital Millennium Copyright Act (DMCA). It is our policy to respond to any infringement notices and take appropriate actions. If your copyrighted material has been posted on the site and you wanna this material removed, Contact Us