View commands

• go to cell
• moves selection point to named cell ("eg x24")
  • applies globally :
• formula evaluation
• turns parser on or off (globally)
• lock all
• locks cells to protect data
• unlock all
• clear settings
• clears all view flags
• default
• resets row, col sizes and formats (globally)

• toggle selected cells only :

• lock,hide
• lock or hide selected cells
• 0
• show zeros
• +
• show plus sign
• colour -
• colour negative numbers red
• ,
• show thousands delimiter
• digits
• if set precision= no significant digits,
• default= clear- number of digits after decimal pt
• currency
• precede numbers with currency sign
• format
• toggle formatting on/off
• column width
• row height
• auto row height
• auto cell width/height

Next

Back