For example, the F2 key enables editing a particular cell, and F9 calculates the values of the formula or part of a formula. Alter the functions of the F1 to F12 Keysįrom F1 to F12 keys, they perform various functions in Microsoft Excel. If none of the following solutions work for you, then there are possibilities that you have a hardware issue with your computer keyboard. In the following section, we are going to discuss the most common 5 possible reasons for it. In some cases, a certain shortcut key may not work on your computer. Navigates to the last cell in a workbook. Jumps into the first cell in a selected row. Jumps into the last cell in a selected row. Jumps into the last cell in a selected column. Jumps into the top-most cell in a selected column. Removes the border from the selected cell. Switches between displaying formulas used in a cell and the cell value.Īpplies borders around the selected cell. Pastes your copied data from the clipboard.Ģ5 Advanced Excel Shortcuts.pdf Serial No. Opens up the Find and Replace dialog box.īrings up the Print window to print a workbook.įills up the selected cells with the contents of the left cell.Īdds up an underline to the selected text. Opens up the Find dialog box to search for anything inside the current workbook. Makes the contents bold of a selected cell.įills up a selected cell with the contents of its upper cell. Selects all the cells in the opened workbook. Without going to Excel macro there are still quite a handful of keyboard shortcuts you can master.25 Common Excel Shortcut Keys.pdf Serial No.Ĭuts and copies the contents of a selected cell.Īvails the Print window to print a worksheet.Įxecutes an entry in a cell and moves to the next cell.īasic Shortcut Keys in Excel.pdf Serial No. Alt + D + G + S – Show Grouped Rows / ColumnsĪpart from the above, here are few others shortcuts that you might find useful.Alt + D + G + H – Hide Grouped Rows / Columns.Alt + D + G + U – Ungroup Rows / Columns.This is useful if you need to routinely working with columns and rows and Excel formulas. Alt + H + L + C + S – Delete Conditional Format.Alt + E + S + V – Paste Values (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.Alt + E + S + T – Paste Formatting (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.Alt + E + S + F – Paste Formula (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.Alt + H + B + P – Top Border *for adding lines.If your Excel sheet is full of color you might want to master this section of keyboard shortcuts. Ctrl + Home – Move to Cell A1 (top left).Ctrl + Pageup / Pagedown – Move to Next / Previous Worksheet Tab.Ctrl + Minus (# pad) – Delete Row / Delete Column.Ctrl + Plus (# pad) – Insert Row / Insert Column.
0 Comments
Leave a Reply. |