From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Exploring the Page Layout tab and Page Layout view

Exploring the Page Layout tab and Page Layout view

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Exploring the Page Layout tab and Page Layout view

“

- If you're about to print a worksheet, and particularly if you've never printed the worksheet, it's best to get a Print Preview first. Now if you're looking at the Excel menu system, the Page Layout tab seems to be the place to go for printing type features, and we see a lot of them here, but we don't see a Print Preview. There is a keystroke shortcut, it's Ctrl+F2, that's going to be handy at times. It takes us to a print preview. We see a sheet to the right. Whenever you see a preview, look at the bottom of the screen, how many pages is this about to take up? 52 pages, I'm thinking of the data, it's about 700 rows or so, 52 pages seems like a lot. As you start to scroll, you'll eventually see that Excel looks like it's picking up data from a few columns to the left, then it goes to the middle, maybe it even goes to the right. It might be picking up a lot more data than we want it to, depends. Some data up top there, yes, looks a little bit strange. This is not acceptable. Press…

Contents