From the course: Excel 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Using Page Break Preview and Print Setup Options
From the course: Excel 2019 Essential Training
Using Page Break Preview and Print Setup Options
- [Instructor] Another approach to printing in Excel is to take advantage of a feature called page break preview. And we're looking at a worksheet with that name, page break preview sheet in our 06 printing file. In the lower right hand corner, in the status bar below the sheet tabs, three buttons. Normal, page layout, and the button on the right, page break preview. Often when you click this if you have zoomed in, Excel will zoom back. I'm gonna scroll to the right. Excel assumes we want to print the entire part of the active worksheet. This is gonna be 35 pages. See these so-called watermarks here? If we print right now and made no changes, we'd get page one below it, page two, you see how that's playing out all the way down to page 17? This is gonna be on page 18 and so on. You can see how that's gonna play out. But let's adjust from the beginning here what it is we want to print. I'm gonna scroll to the right. There's a dark blue border on the very edge of the printout. I don't…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.