That will insert the sum function.
F5 Opens the Go To dialog box (same as CtrlG ).
ShiftUp Extends or collapses the selection upward by one cell.CtrlK, opens the Insert Hyperlink dialog box when the cursor is not at a hyperlink or the Edit Hyperlink dialog box for a selected existing hyperlink.Ctrl* Selects the current data region (the rectangular region containing filled cells around the active cell).Search Office Sites You can search the websites that have the most useful and valuable information about using Microsoft Office products by using the Search Office Sites search box in the banner.Excerpt: CalculateFull Method Example This example compares the version of Microsoft Excel with the version of Excel that the workbook was last calculated.CtrlN Create a new workbook.The builtin Volatile functions are not as bad: cell indirect info offset NOW rand today as those in a user defined function.
Takes you home to the first cell Ctrl-Home Instead of scrolling to the top, Ctrl-Home is useful to go to the first cell (A1 from whereever you are in an Excel sheet.
Another useful key is Ctrl-End; that takes you to the last cell of the sheet.
Note these shortcuts are with transition navigation keys option probability and random process by veerarajan ebook turned off. .Ctrl Applies the Percentage format with no digits after the decimal point.F7, spell check selected text and/or document.Or- find "Microsoft Excel" in the Windows Start, Programs then drag with right mouse button to desktop, then choose "Create Shortcut(s) Here".CtrlAltF9 Recalculates tiny bang story game all cells on all worksheets in all open workbooks.AltPage Down Moves one screen to the right in the worksheet.