ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   AutoSum turned off? (https://www.excelbanter.com/excel-discussion-misc-queries/189612-autosum-turned-off.html)

Leslee

AutoSum turned off?
 
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?

Leslee

AutoSum turned off?
 


"Leslee" wrote:

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?

Kevin B

AutoSum turned off?
 
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.
--
Kevin Backmann


"Leslee" wrote:



"Leslee" wrote:

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?



All times are GMT +1. The time now is 08:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com