Windows 10: Excel spreadsheet prints differently than what is on screen.

I keep my checkbook on an Excel spreadsheet. I have a balance column that I use formulas =sum(A1:A6) etc to keep a running balance. Everything looks fine on the spreadsheet. But when I ask for a print preview those cells it show the formula rather than the amounts. What causes this and how do I fix it?

Thanks Kathy

:)

 

Can my problem be the eXcel sheet?

I moved eXcel spreadsheets from my old computer and now they don't print the correct colors. The print preview shows what is in the spreadsheet but it does not print what is shown. Has anyone seen this? Is there a setting in my (new?) eXcel?

Thanks

***Post moved by the moderator to the appropriate forum category.***

 

HP iPAQ hx2790 Pocket PC

So, if I make the file on vista when i save it save it as a .doc file instead of a .wps file? What about excel and vista spreadsheet, excel is .xls spreadsheet is different.



Thanks

 

Hi Kathy

Not a good answer but my experience.

First thing to check is that your product is fully up to date. When you are in spreadsheet click on file, almost at the bottom, left side, is "account", click on it. On the right it will tell you how updates are being delivered. You can always check for updates.

I find that print preview is not the most reliable view. I've found false formatting, borders in particular, cells showing two small for numbers all displayed incorrectly. I now use it for basic layout and tend to ignore the details. I run 2013 fully patched. You said it shows that way on print preview, have you tried printing a page.

There are methods to print formulas but you said the sheet looks okay before you go to Print Preview, so I don't think that is the issue.

If you print does it print correctly?