| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does text look like ###### even when wrap is turned on? | Excel Discussion (Misc queries) | |||
| list turned into two columns | Excel Discussion (Misc queries) | |||
| Sort is turned off. How do I turn it on? | Excel Worksheet Functions | |||
| Worksheet has turned | Excel Worksheet Functions | |||
| How is the Filter count turned on/off? | Excel Discussion (Misc queries) | |||
Linear Mode
