View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
G[_2_] G[_2_] is offline
external usenet poster
 
Posts: 4
Default Adding one to cell value

Assuming the cell simply contains a number
Highlight the cell.
Press [F2]
enter +1
press [Home]
press equal [=] or plus [+]
press [Enter]

If the cell contains a formula, or if you have already done the above once:
Highlight the cell.
Press [F2]
enter +1
press [Enter]

________
Greg Stigers, MCSA
remember to vote for the answers you like