Example: Enter = and start typing vl, press Tab and you will get = vlookup(Ĭycle through various combinations of formula reference types. Place the cursor within a cell and hit F4 to get the needed reference type: absolute, relative or mixed (relative column and absolute row, absolute column and relative row). Toggle between displaying cell values and formulas. Insert the formula of the above cell into the currently selected cell or the Formula Bar. Hide the ribbon to view more than 4 rows of data. Press Ctrl + PgUp to switch to the previous sheet.

Return to the 1st cell of the current row in a worksheet. Move to the beginning of a worksheet (A1 cell). Move to the last used cell of the current worksheet, i.e. In cell editing mode, enter a new line (carriage return) into a cell.Įnter the current date. Press Ctrl + Shift + to enter the current time.įill the selected cells with the contents of the current cell.Įxample: select several cells.

Press and hold down Ctrl, click on any cell within selection and press F2 to edit it. MICROSOFT EXCEL SHORTCUT KEYS 2007 PDF PLUS.MICROSOFT EXCEL SHORTCUT KEYS 2007 PDF FULL.MICROSOFT EXCEL SHORTCUT KEYS 2007 PDF PDF.MICROSOFT EXCEL SHORTCUT KEYS 2007 PDF HOW TO.

Microsoft excel shortcut keys 2007