Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
AUTO SUM
I USED AUTO SUM TO TOTAL SUBSECTIONS OF A COLUMN. THE FIRST 2 SHOWED THE
TOTAL CORRECTLY: THE LAST 2 SHOW "#####" IN THE CELL. IF YOU PRINT THE WORKSHEET, THE CORRECT TOTAL PRINTS IN THOSE "#####" CELLS. WHAT AM I DOING WRONG? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
AUTO SUM
BJ wrote:
I USED AUTO SUM TO TOTAL SUBSECTIONS OF A COLUMN. THE FIRST 2 SHOWED THE TOTAL CORRECTLY: THE LAST 2 SHOW "#####" IN THE CELL. IF YOU PRINT THE WORKSHEET, THE CORRECT TOTAL PRINTS IN THOSE "#####" CELLS. WHAT AM I DOING WRONG? You just need to resize that column. Type resize column into help and then select Change column width and row height. Better explanation that I can type. gls858 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
AUTO SUM
Your column probably isn't wide enough to display the number on the screen.
Try increasing the width of the column. HTH, Elkar "BJ" wrote: I USED AUTO SUM TO TOTAL SUBSECTIONS OF A COLUMN. THE FIRST 2 SHOWED THE TOTAL CORRECTLY: THE LAST 2 SHOW "#####" IN THE CELL. IF YOU PRINT THE WORKSHEET, THE CORRECT TOTAL PRINTS IN THOSE "#####" CELLS. WHAT AM I DOING WRONG? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter question | Excel Worksheet Functions | |||
Is there a way to link Auto Filter values to a Cell | Excel Worksheet Functions | |||
Auto tab- Auto fill | New Users to Excel | |||
Macro for Auto Fill | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |