Excel Tips

1

• Excel Tips
• 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 .
• The Excel function sumproduct(range1,range2)
  first multiplies the corresponding numbers in the
  two ranges and then sums the resulting products.
• Within a spreadsheet, to toggle between the
  actual contents of the cells and the formulae
  within the cells, simultaneously press the two
  keys Ctrl .
• 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.
• To include Row Column headings when printing a
  spreadsheet, first use the command sequence
  File, Page Setup, Sheet, and then check the
  appropriate box.
• 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.
• To add Gridlines or Row Column headings missing
  from a spreadsheet, use the command sequence
  Tools, Options, View, and then check the
  appropriate box.
• 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 a copy box.)