ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   EXCEL Question??? (https://www.excelbanter.com/excel-worksheet-functions/20339-excel-question.html)

T.B.

EXCEL Question???
 
I have a spreadsheet and all my colums added up just fine. My problem is 1
colume will not print the total.The sum is right but when i try to print a
copy it shows up like this ######. Please help!
--
TB

Roland

This is a common problem. What it means is that the total is too large to
display in the column at the width the column is currently set to.

Do this.

Select the total that is too large to display.

Then from the menu select FORMAT, COLUMN, AUTOFIT SELECTION.




"T.B." wrote:

I have a spreadsheet and all my colums added up just fine. My problem is 1
colume will not print the total.The sum is right but when i try to print a
copy it shows up like this ######. Please help!
--
TB


T.B.



"Roland" wrote:

This is a common problem. What it means is that the total is too large to
display in the column at the width the column is currently set to.

Do this.

Select the total that is too large to display.

Then from the menu select FORMAT, COLUMN, AUTOFIT SELECTION.

Roland, You are the man. What can I say. Spent Hours working on this. Thanks


"T.B." wrote:

I have a spreadsheet and all my colums added up just fine. My problem is 1
colume will not print the total.The sum is right but when i try to print a
copy it shows up like this ######. Please help!
--
TB



All times are GMT +1. The time now is 06:49 PM.

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