Below is the breaking bad series 4 episode 13 list of goynar baksho book pdf all the major shortcut keys in Microsoft Excel.
CtrlF9 Minimize the window.
When a portion of a formula is selected, calculate the selected portion and then press Enter or CtrlShiftEnter (for array formulas) to replace the selected portion with the calculated value.AltL Apply or remove the left border.Ctrl - (hyphen) Delete the selected cells.CtrlF5 Restore window size of current workbook.Then you can use the shortcut keys shown in Table.6.ShiftTab Complete a cell entry and select the previous cell to the left.(period) Move to next corner of selected range.F4 Repeat last action.Advertisements, previous Page, next Page, mS Excel offers many keyboard short-cuts.Shift F3 Opens the Excel formula window.CtrlShift2 Format number in time format.
ShiftF8 Add another range of cells to the selection or use the arrow keys to move to the start of the range you want to add.
Table.1 lists the common Windows Ctrl shortcut keys.
Press CtrlPgDn until you arrive at the Border tab.CtrlShift_ (underscore) Remove the outline border from the selected cells.Scroll LockShiftHome Extend the selection to the cell in the upper-left corner of the window.Ctrl Shift Inserts a new column or row.AltShiftArrow Left Ungroup selected PivotTable items.CtrlP Bring up the print dialog box to begin the printing process.Work with Data Selections.AltH If cells in multiple rows are selected, apply or remove the horizontal divider.