ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   auto sum (https://www.excelbanter.com/excel-worksheet-functions/252876-auto-sum.html)

Pat

auto sum
 
I added a row under the coloumn I want to add. I used the auto sum key, and
all it does is show the formula, not the actual totals. What am I doing
wrong?

Gord Dibben

auto sum
 
Format the cell/row to General then F2 and Enter to re-enter the formula.


Gord Dibben MS Excel MVP

On Sat, 9 Jan 2010 11:34:01 -0800, Pat
wrote:

I added a row under the coloumn I want to add. I used the auto sum key, and
all it does is show the formula, not the actual totals. What am I doing
wrong?



Ashish Mathur[_2_]

auto sum
 
Hi,

You may have pressed Ctrl+~ by mistake (which is the short cut key to show
formulas). Press that again to show the result

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Pat" wrote in message
...
I added a row under the coloumn I want to add. I used the auto sum key,
and
all it does is show the formula, not the actual totals. What am I doing
wrong?




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

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