Printing Excel worksheet

[mike13]

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.

[Bruce]

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.

[mike13]

Thanks Bruce. I knew there should be an easier way !!

[Bruce]

no worries, i’ll close this as solved.