It’s time to take your skills to the next level because you already know the basic keyboard shortcuts. View Shortcuts Shortcut Keys Description Ctrl + 9 Hide rows Ctrl + 0 Hide columns Ctrl + Shift + 9 Unhide rows Ctrl + F10 Maximize or restore window Ctrl + 9 Minimize workbook Alt + W + A Arrange Windows Alt + H + J Cell Style Ctrl + H Replace Ctrl + Shift + F Font Drop Down List F10 Activate menu Alt + Control + Arrow Key Change the position of the worksheet. Options Shortcuts Shortcut Keys Description Menu Button Right click menu Ctrl + T Apply table Alt + D + F + F Add Filters Alt + A + S + S Open Sort Alt + A + B Add Subtotal Alt + A + M Remove Duplicate Alt + H + J Cell Style Ctrl + H Replace Ctrl + Shift + F Font Drop Down List F10 Activate menu F7 Spell check F1 Help 7. Insert Shortcuts Shortcut Keys Description Alt + F1 or Alt + N + R Insert Chart Alt + N + P Insert a Picture Ctrl + Shift + (+) or Alt + I + R Insert a cell, row, or column Alt + N + X Insert Textbox Alt + N + U Insert Symbol Alt + N + S + H Insert Shape Shift + F11 Insert new worksheet Alt + IC Insert column Alt + IR Insert row Alt + N + V Insert a Pivot Table Alt + 0128 Insert the euro (€) symbol Alt + 0163 Insert pound (£) sign symbol Alt + 0162 Insert cent (¢) symbol Ctrl + 5 Insert Strikethrough 6. Alt + H + M + C Merge Cell Alt + H + F + S Change Font Size Ctrl + Q Expanding the Quick Analysis tool Alt + H + H Change Cell Color 5. Ctrl + Shift + 7 To draw outline around the cell. Ctrl + Shift + 6 To format cell into scientific notation. Ctrl + Shift + 5 To format number into percent. Ctrl + Shift + 4 To format cell to currency. Ctrl + Shift + 1 To format cell to two decimal places. Shortcut Keys Description Ctrl + 1 To open the Format Cells dialog box. These keyboard shortcut cheatsheets in Excel will help you format your cells quickly and easily. Ctrl + Spacebar To select the entire column. Ctrl + Shift + Arrow keys To select the entire column or row Shift + Spacebar To select the entire row. Shortcut Keys Description Shift + Arrow keys To select a range of cells. These shortcuts will help you select the cells that you need quickly and efficiently. Ctrl + Home Move to the beginning of the worksheet Ctrl + End Move to the last cell of the worksheet that contains data. Ctrl + PgDn (Page Down) Move the screen to the right of the worksheet tab. Ctrl + PgUp (Page Up) Move the screen to the left of the worksheet tab. Ctrl + Arrow key Move to the edge of the current active worksheet in any direction. Ctrl + Down arrow key Move the cursor to the bottom of the current cell in the worksheet. Ctrl + Up arrow key Move the cursor to the top of the current cell in the worksheet. Ctrl + right arrow key Move the cursor to the right end of the current cell in the worksheet. Ctrl + Left arrow key Move the cursor to the left end of the current cell in the worksheet. Shortcut Keys Description Arrow keys Move the cursor up, down, left, or right on the worksheet.
0 Comments
Leave a Reply. |