From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Adjust layout

Adjust layout - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Adjust layout

“

- [Instructor] What the heck is all of this? Wow. We've got our conference room data. Somebody has put all these apples in the background. And that is the first objective. Get rid of these apples. Next, set the page to print on one sheet, landscape, with 0.75 inch margins. Next, set conditional formatting to highlight any sales that say "not available." Then, set the Room Capacities box and this objectives box so that they do not print when this sheet is printed. All right? Pause the video. Work all of that out. Come back and we'll go through it together. Okay. You're back. Let's get rid of these apples. Page layout, delete background. Hoo! It was that easy. Now the page orientation. Let's go here. Landscape. Margins. Custom margins. Put the left at 0.75. The right at 0.75. The top and bottom were already there. Go to page. Fit to one page wide by one page tall. Okay. Now set conditional formatting to…

Contents