toggle formula in cell display

General advanced Excel topics and questions to make your life easier and to increase your productivity and efficiency countlessly.

Moderators: wstexpert, wsthost

toggle formula in cell display

Postby mandylify » Sun Jun 17, 2012 9:01 pm

Hi, i accidentally hit some stroke and now one of my row only shows formula (ie =a16*b5) instead of the calculated result. how can i change that. thx
mandylify
 
Posts: 7
Joined: Mon Dec 08, 2008 8:42 pm

Re: toggle formula in cell display

Postby wsthost » Sun Jun 17, 2012 10:34 pm

to toggle formulas and values, hit CTRL ~
the ~ (tilda) key is usually next to the 1 on keyboard
wsthost
Site Admin
 
Posts: 393
Joined: Thu Jul 24, 2003 5:53 pm


Return to Excel Topics

Who is online

Users browsing this forum: No registered users and 1 guest