Nov 25 2019 06:07 AM
Hey there,
My Excel print preview and printer seem to be out of sync.
I keep my excel worksheets in "Page Layout" mode when I work, I find it best when I plan to print the document in the end. In the last 2 weeks, none of the documents I've printed are coming out the way they appear on the workbook.
I have a workbook that should be 23 pages but it prints 26 instead. The rows are extending over into other pages.
Please help!!
Dec 01 2020 12:18 AM
Dec 01 2020 10:47 AM
@Krispylog Hi,
Try File -> Options -> Advanced and scroll down until you get to the General section.
Cheers,
Andrew
Jan 02 2021 11:30 AM
@Sergei Baklan Thank you so much for solving my issue.
Jan 07 2021 06:17 PM
@Sergei Baklan Thank you. Saved my day
Mar 02 2021 10:28 PM
Mar 03 2021 04:20 PM
Jun 01 2021 01:43 AM
Jul 23 2021 05:12 AM
Jul 23 2021 05:13 AM
Sep 22 2021 06:03 PM
thank you Sergei, saved a lot of time!!
Oct 22 2021 05:21 AM
Oct 22 2021 02:00 PM
@Lorenzob19 Thanks, glad it helped
Nov 11 2021 08:30 AM
Hello,
I also wanted to chip in that this solved an issue I had with spill over rows running on to a second page while running Excel on a Window 365 Cloud PC. When the code ran while I was connected to the cloud PC the page was fine, however when the same PDF export code ran using VBA Application.OnTime and I wasn't connected the rows spilled over (same code, same document, same everything, the only difference was connected and not connected via Remote Desktop). Unchecking the scale option solved this bizarre behaviour. (Maybe the Cloud PC uses different regional settings when a user is connected or not?)
Anyway, many thanks,
Kyle
Nov 11 2021 08:38 AM
Sorry, I have no experience with "Window 365 Cloud PC".
Dec 08 2021 05:16 AM
Reading this in 2021 and OMG you're a blessing! Thank you so much!!
Dec 08 2021 07:00 AM
@3shMAD , thank you!
Dec 21 2021 12:59 AM
@Sergei Baklan Thank you so much !
Apr 07 2022 01:38 AM
@Sergei Baklan Great! thank you!
May 30 2022 02:28 AM
Jun 06 2022 01:09 PM
I've created a table to show alternating blue and white rows. I see the colors as expected in the print preview, but when I print, no row colors are printing. I tried exporting to PDF. Again, the PDF shows the different row colors, but does not print the blue and white rows. After trying multiple times, I realized there is a very faint "gray" color where the Blue color should be. I wouldn't mind having the gray color (giving up on the blue), but it is too faint to be effective in separating the rows. I googled this issue and kept getting the same results (to check to make sure that "Black and white" box was unchecked in the Sheet Tab of the Page Setup: it is not checked. And to make sure that "Draft quality" is not checked, it isn't. I really didn't have to check this, because I have 3 rows ABOVE the "Blue and White" rows that are in color and they print just fine. I really could use your expertise here! Please and Thank you!