1.    20 Feb 2017 #1
    Join Date : Jan 2016
    Posts : 30
    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
      My ComputerSystem Spec
  2.    21 Feb 2017 #2
    Join Date : Oct 2016
    Caledon, Ontario, Canada
    Posts : 3,971
    Windows 10 Pro Build 1703

    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?
      My ComputerSystem Spec

 


Similar Threads
Thread Forum
BSOD Usually happens when using Excel spreadsheet.
Hello, I've been experiencing BSOD over the past month. Just ignored as it was random but i've now realised that it's usually happening when I'm using Excel. I have attached the dump files following the instructions on the forum. I've tried...
BSOD Crashes and Debugging
Solved 2 panel snap w/ spreadsheet/browser: way to go back/forth w/o tab?
I've begun using snap in Windows 10 and like it for most purposes, but I very often use a spreadsheet in one window next to a browser window (typically Sheets w/in Chrome, but also stand-alone LibreCalc, with Chrome). (I am often gathering data on...
General Support
Solved HP D1460 Printer intermittent prints
Since I upgraded to Win 10 Pro from Win 8.1 Pro printing has become intermittent on my Deskjet D1460. There are no drivers on the hp site for this printer for Win 10 just the scan and print doctor. In fact the only way to get the printer to print...
Drivers and Hardware
Solved How do I compare 2 Excel 2000 spreadsheets on same screen?
In previous windows versions I could resize two spreadsheet windows and drag them side-by-side. With Win 10 if I click on a second spreadsheet it replaces the first. How do I get two Excel 2000 spreadsheets side-by-side to compare two versions??
Software and Apps
evaluate 10 differently
Kind of Surprised ! ... got what I wanted !!! :) http://www.microsoft.com/en-us/evalcenter/evaluate-windows-10-enterprise NO APPS ! except for Contact Support (and Feedback App) NO Edge - NO Cortana - No MS Store App - No Mail App...
Chillout Room
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 00:14.
Find Us
Twitter Facebook Google+ Ten Forums iOS App Ten Forums Android App



Windows 10 Forums