Info Catalog ses: The Basics ses: Top ses: For Gurus

ses: Advanced Features

 
 4 Advanced Features
 *******************
 
 ‘C-c M-C-h’
      (‘ses-set-header-row’).  The header line at the top of the SES
      window normally shows the column letter for each column.  You can
      set it to show a copy of some row, such as a row of column titles,
      so that row will always be visible.  Default is to set the current
      row as the header; use C-u to prompt for header row.  Set the
      header to row 0 to show column letters again.
 ‘[header-line mouse-3]’
      Pops up a menu to set the current row as the header, or revert to
      column letters.
 ‘M-x ses-rename-cell’
      Rename a cell from a standard A1-like name to any string.
 ‘M-x ses-repair-cell-reference-all’
      When you interrupt a cell formula update by clicking ‘C-g’, then
      the cell reference link may be broken, which will jeopardize
      automatic cell update when any other cell on which it depends is
      changed.  To repair that use function
      ‘ses-repair-cell-reference-all’
 

Menu

 
· The print area
· Ranges in formulas
· Sorting by column
· Standard formula functions
· More on cell printing
· Import and export
· Virus protection
· Spreadsheets with details and summary
 

Info Catalog ses: The Basics ses: Top ses: For Gurus