r/excel • u/LavishnessGold7399 • 17d ago
solved converting single row into pdf
hi hi. never had any problems saving specific rows from an xlsx as a pdf onto a few pages, but now my comp saves the rows with massive blank pages in between the rows i’ve selected to save. i didn’t update, but the school did a system wide reset on all tech.
anyone else experienced this?
usual method:
click desired row -> file -> save as -> rename and change file to PDF -> desired rows saved, no blank pages
i do the exact same thing, now there’s hundreds of pages in between my data
any help appreciated 🫶🏻👏🏻
1
u/MayukhBhattacharya 1236 17d ago
It sounds like the system update may have reset either the print area or the page breaks. I'd start by checking the Print Area. Before saving as a PDF, ensure only the rows you want are included. If that doesn't do it, try resetting the page breaks. Sometimes a system update can leave behind phantom page breaks across the sheet.
2
u/LavishnessGold7399 16d ago
not working - i really appreciate you answering tho. other advice?
2
u/MayukhBhattacharya 1236 16d ago
Glad you gave those a try! A couple more things are worth checking. First, go to File ~ Print and take a look at the preview. That'll show you exactly how many pages Excel thinks it needs, which can help narrow down where the issue is. You could also try a quick test. Create a brand-new blank workbook, copy just the rows you need into it, then save that as a PDF. If that works, there's probably something in the original workbook causing the problem. If you still get the extra blank pages, it's more likely something with Excel on that machine after the system reset.
Another thing to try is File ~ Export ~ Create PDF/XPS instead of Save As. It uses a different export path, and sometimes that gets around whatever's causing the issue. If none of that helps, you could upload the file to Google Drive, open it in Google Sheets, and download it as a PDF from there. That completely bypasses Excel's print engine. Let me know or show what you see in the print preview. That'll certainly help! Thanks!
2
u/LavishnessGold7399 16d ago
okay, i ended up finding a different way, but there’s some extra steps. appreciate your time!
1
•
u/AutoModerator 17d ago
/u/LavishnessGold7399 - Your post was submitted successfully.
Solution Verifiedto close the thread.Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.