AutoSum turned off?

L

Leslee

I am trying to do a simple AutoSum of a column of numbers - but the AutoSum
button is dimmed - will not activate for any cell, column or row? What is
wrong and how do I fix it?
 
L

Leslee

Leslee said:
I am trying to do a simple AutoSum of a column of numbers - but the AutoSum
button is dimmed - will not activate for any cell, column or row? What is
wrong and how do I fix it?

Because the worksheet has a blue box around it, I am guessing this worksheet
was maybe created as a list - if so, how do I correct this?
 
K

Kevin B

Move the cell pointer to a locatio within the list and do the following:

Click DATA in the menu
Select LIST
Select CONVERT TO RANGE.

However, if you click VIEW in the menu and select the LIST toolbar there's a
command button on that toolbar that will toggle row totals On/Off.

Hope this helps.
 

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

Top