In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options. Depending upon the capacity your email service provider allows, copy and paste them on the email address bar and send. F4 Repeat the last command or action. To do this Press Close a workbook Ctrl+W Open a workbook Ctrl+O Go to the Home tab Alt+H Save a workbook Ctrl+S Copy Ctrl+C Paste Ctrl+V Undo Ctrl+Z Remove cell contents Delete key Choose a fill color Alt+H, H Cut Ctrl+X Go to Insert tab Alt+N Bold Ctrl+B Center align cell contents Alt+H, A, C Go to Page Layout tab Alt+P Go to Data tab Alt+A Go to View tab Alt+W Open context menu Shift+F10, or Context key Add borders Alt+H, B Delete column Alt+H, D, C Go to Formula tab Alt+M Hide the selected rows Ctrl+9 Hide the selected columns Ctrl+0 Ribbon keyboard shortcuts If you're new to the ribbon, the information in this section can help you understand the ribbon's keyboard shortcut model. Ctrl+F6 When more than one workbook is open, switch to the next open workbook window. F5 also displays this dialog box. Shift+Page Down Extend the selection down one screen.
Ctrl+2 Applies or removes bold formatting. Ctrl+4 Applies or removes underlining. If you have more than a one sheet, Hyperlinks make your work book accessible and save your time. Esc Complete an entry in the formula bar and select the cell below. Ctrl+B or Ctrl+2 Underline text or remove underline.
When a Ribbon tab is selected, these keys navigate up or down the tab group. Ctrl+; Enters the current date. Available only if names have been defined in the workbook Formulas tab, Defined Names group, Define Name. Will my old shortcuts still work? Pressing Alt does the same thing. In a PivotTable, it selects the entire PivotTable report.
Ctrl+Alt+Shift+F9 Display the menu or message for an Error Checking button. F5 Displays the Go To dialog box. Fills in the cell underneath with contents of the cell selected. When a cell reference or range is selected in a formula, F4 cycles through the various combinations of absolute and relative references. Ctrl+O Displays the Open dialog box to open or find a file. Turns End mode on or off. Ctrl+ 6 Alternate between hiding objects, displaying objects, and displaying placeholders for objects.
Ctrl+Shift+F3 Creates names by using those of either row or column labels. Ctrl+8 Toggles the outline symbols. You can combine these letters with Alt to make shortcuts called Access Keys for ribbon commands. Shift+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys. Shift+Page Up In a single column, highlights all cells above that which are selected. Press again to turn off. Down or Alt+Down arrow key opens a selected drop-down list.
Ctrl+ F8 Perform size command for workbook windows which are not maximzed. Then press Ctrl+R to fill them with the contents of the original cell. Aaj ki generation ki har zarurat or har kam ke liye computer bohot zaruri ho gya hai. Moves to the next option or option group in a dialog box. Ctrl+Tab Move between Two or more open Excel files. Ctrl+Shift+Spacebar selects the entire worksheet.
Shift+F8 Start a new line in the same cell. Ctrl+Shift+% Applies — percentage formatting. Ctrl+5 Apply or remove strikethrough. Pressing Alt does the same thing. Ctrl+Page Down Move to next worksheet. Alt+Page Up moves one screen to the left in a worksheet.
Hide the ribbon to view more than 4 rows of data. For example, Alt, W, P switches the worksheet to Page Layout view. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color. Ctrl+Shift+~ Applies the General number format. F2 Edits the selected cell. Shift+ Backspace Select only the active cell when multiple cells are selected. Ctrl+2 Bolds all cells in the highlighted section.