F9 Key for totals

  • Thread starter Transfer from onyx to access database
  • Start date
T

Transfer from onyx to access database

Why would you need to press the F9 key in order to total a subtotal after
entering a new value into a cell?
 
D

Dave F

Because you have automatic calculation turned off.

To turn it on, go to Tools--Options-_Calculation and check automatic
calculation.

Dave
 
T

Transfer from onyx to access database

So it this in the spreadsheet when it is open or just opeing Excel? BTW,
sorry I don't know why or how it linked this question with my header for
access...
 
T

Transfer from onyx to access database

Thank you, that was the issue.

Dave F said:
Because you have automatic calculation turned off.

To turn it on, go to Tools--Options-_Calculation and check automatic
calculation.

Dave
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
Start a mail merge upon opening the document 1
Help With Typing Russian Letters On Microsoft Word Mac 0
Creating Multi Level list using Header Style 1
Formula refresh 6
FN key 3
calculate cells over multiple worksheets 4
Interchange line break and paragraph break shortcut keys 9

Top