Thread: Formula doesn't work unless hit enter again
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AST ATY AST ATY is offline
external usenet poster
  
Posts: 1
Default Formula doesn't work unless hit enter again
On Wednesday, July 1, 2009 at 6:06:00 AM UTC+6, Bobby wrote:
I have to select Each cells with a function, than put my cursor in the
formula bar and press enter. The excel option 'automatic calculation' is on
and was always on before? Also, all cells are in 'numbers' format...not text.
Thanks !
Use shortcut: alt H A E and then press enter. that's it
Reply With QuoteReply With Quote