microsoft excel shortcut keys list 2007 pdf

Introduction to Excel 2007 pdf for more in depth description of. On the Mac, this doesn't seem to work in certain areas, notably Define Names, and the New Formatting Rule window when adding a conditional format that uses a formula. also some simple Keyboard Shortcut key combinations that will speed up your work. Pressing F2 / Ctrl+U repeatedly will cycle through modes.you'll see the mode displayed in the status bar, in the lower left corner.

'Edit' mode simply moves the cursor in the formula text. Ctrl+Shift+G Open the Word Count dialog box. Fill down copies the content and format of the topmost cell into the cells below. CTRL+D - This uses the fill down command on the selected cells.

CTRL+ - This alternates between showing the value of a cell and the formula in the worksheet.

'Point' and 'Enter' work similarly and allow you to point to a cell. Ctrl+Alt+V Paste special Ctrl+Shift+V Paste formatting only Ctrl+Z Undo the last action. CTRL+SHIFT+: - This enters the current time in the selected cells. Once you are editing a cell, you can use the F2 / Ctrl+U again to toggle through available edit modes (edit, enter, point). If you want the cursor to move to the formula bar, see below. This shortcut enters cell edit mode with the cursor at the end of the last line of text in the cell.

Microsoft excel shortcut keys list 2007 pdf