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

  1.    20 Feb 2017 #1

    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. Posts : 6,959
    Windows 10 Pro x64 Build 1709
       21 Feb 2017 #2

    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


Related Threads
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...
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...
Solved HP D1460 Printer intermittent prints in Drivers and Hardware
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...
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??
evaluate 10 differently in Chillout Room
Kind of Surprised ! ... got what I wanted !!! :) NO APPS ! except for Contact Support (and Feedback App) NO Edge - NO Cortana - No MS Store App - No Mail App...
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 01:53.
Find Us