Tiles two open windows or workbooks one above the other for comparison — press the hot keys again to restore the original full windows. All-on-One your table requires a title, put the title in the row above the column headings. Home Cell in Column A of the current Buy Excel 2013 All-in-One For Dummies key. Opens New Name dialog box, MS Word 2017 buy key you can assign Buy Excel 2013 All-in-One For Dummies key name to the cell All-ib-One or define a new constant. Division by zero is kej no-no in mathematics. Home Cell in Column A Buy MS Office 2007 Enterprise key Buy Excel 2013 All-in-One For Dummies key current row. If no cell is occupied, the pointer goes to the cell at the very top of the column. Displays the New screen in the Backstage View where you can open a blank workbook from one of the available templates. When moving the cell cursor by using the keystrokes listed in the table, keep the following helpful hints in mind: In the case of those keystrokes that use arrow keys, you must either use the arrows on the cursor keypad or else have the Num Lock disengaged on the numeric keypad of your physical keyboard. Here are a few simple guidelines a kind of data-entry etiquette to keep in mind when you create an Excel spreadsheet in Sheet1 of a new workbook:. Cuts the cell selection or selected graphic objects out of the workbook and places them on the Windows Clipboard. Hides and redisplays the row and column gridlines that form the cells in the Worksheet area. Opens a drop-down menu listing all Date and Time functions — click name to insert function into current cell. If no cell is occupied, the pointer goes to the cell at the very end of the row. First occupied cell to the right in the same row that is either preceded or followed by a blank cell. First occupied cell above in the same column that is either preceded or followed by a blank cell.