A friend sent me an Excel worksheet to update and keep track of while he is away. When I go to FILE, PRINT, it defaults to ACTIVE SHEETS. That would be OK, however it adds several columns on the right that are blank, which makes the sheet more compact and harder to read. I deleted those columns but nothing changes. I can highlight the area of the spreadsheet that I want. and then do a FILE, PRINT, PRINT SELECTION. That works great, but I have to highlight what I want printed every time I want to print. Suggestions, please. I also have it set to print 1 sheet wide by 4 sheets tall.
Solved Printing Excel worksheet
- Thread starter mike13
- Start date
-
Hi there and welcome to PC Help Forum (PCHF), a more effective way to get the Tech Support you need!
We have Experts in all areas of Tech, including Malware Removal, Crash Fixing and BSOD's , Microsoft Windows, Computer DIY and PC Hardware, Networking, Gaming, Tablets and iPads, General and Specific Software Support and so much more.
Why not Click Here To Sign Up and start enjoying great FREE Tech Support.
This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
- Status
set a print area.
use the mouse to select the area you want to print.
along the top menu, click Page Layout > Print Area > Set Print Area.
you'll see a border appear around your selected work.
now when you print, it'll just print that area.
to remove, from anywhere in the sheet (you don't have to re-select the area) hit Print Area > Clear Print Area.
use the mouse to select the area you want to print.
along the top menu, click Page Layout > Print Area > Set Print Area.
you'll see a border appear around your selected work.
now when you print, it'll just print that area.
to remove, from anywhere in the sheet (you don't have to re-select the area) hit Print Area > Clear Print Area.
- Status