Calculate entire worksheet

sopranoiam

Board Regular
Joined
Oct 16, 2002
Messages
88
Is there a way to calculate an entire worksheet which has autosum totals in several places thru out the sheet. I tried to highlight the whole sheet and then press F9, but it doesn't seem to work. Suggestions?
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
F9 should calculate the entire workbook; Shift+F9 should calculate only the current worksheet. What didn't re-calculate when you hit F9?
 

sopranoiam

Board Regular
Joined
Oct 16, 2002
Messages
88
The autosums didn't update for some reason. Up until now I had been going in and calculating each autosum total individually, but what I am doing now has 7 identically formatted worksheets and it was becoming tedious. The F9 or Shift F9 doesn't work, I don't know if I'm doing something wrong. I highlight the sheet in the top left and nothing changes or updates when I press either.
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Are you sure there are formulas there? Not been converted to text values?
 

Cbrine

Well-known Member
Joined
Dec 2, 2003
Messages
3,196

ADVERTISEMENT

You should check Tools... options. Click on the calculation tab and make sure the calculation is set to automatic. Although, if the F9's not working, I don't know if this will make a difference.
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,022
FWIW - according to Walkenbach, Ctrl+Alt+F9 is an undocumented key sequence that supposed to force a recalc of everything if for some reason Excel isn't responding to F9 like it should.
 

sopranoiam

Board Regular
Joined
Oct 16, 2002
Messages
88
Got it! Thank you. For some reason some of the formulas didn't carry over, I haven't had that happen before, they were just values. It works now.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,159
Messages
5,768,520
Members
425,479
Latest member
Neerajcool

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top