Excel Tips - PowerPoint

							                                           Excel Tips
1.   For a cell reference (e.g., B10), to toggle “$”, click in the Formula Bar either just before or just
     after the cell reference, and then repeatedly press the “F4” key until obtaining the desired
     placement of “$”.

2.   The Excel function “sumproduct(range1,range2)” first multiplies the corresponding numbers
     in the two ranges and then sums the resulting products.

3.   Within a spreadsheet, to toggle between the actual contents of the cells and the formulae
     within the cells, simultaneously press the two keys “Ctrl ~”.

4.   To annotate a spreadsheet with Excel-created callouts, first display the Drawing Toolbar by
     using the command sequence “View, Toolbars, Drawing”, and then, under “AutoShapes”,
     select “Basic Shapes” or “Callouts”.

5.   To include Row & Column headings when printing a spreadsheet, first use the command
     sequence “File, Page Setup, Sheet”, and then check the appropriate box.

6.   To save and print an object displayed in an open window, first take a picture of the window by
     simultaneously pressing the two keys “Alt PrtScr”, then close the window, and finally use the
     command sequence “Edit, Paste" to paste the picture into any Excel or Word document.

7.   To add Gridlines or Row & Column headings missing from a spreadsheet, use the command
     sequence “Tools, Options, View”, and then check the appropriate box.

8.   To move a worksheet from an open Workbook A to an open Workbook B, use the command
     sequence “Edit, Move or Copy Sheet”. (NOTE: To copy the worksheet, check the “Create a1
     copy” box.)