Which path shows the correct location to set the print area for the selected cells?

Which path shows the correct location to set the print area for the selected cells?

• A. Page Layout > Print Area > Clear Print Area.
• B. Back, Page Layout, Print Area, Set Print Area.
• C. Page Layout > Page Setup Group > Print Area > Set Print Area.
• D. Page Layout > Print Area > Set Print Area.

Answer: (D)

In Excel, the print area defines which cells will be printed. To set it, first select the cells you want, then go to the Page Layout tab and use the Print Area option to Set Print Area. This places your current selection as the area to print, so only those cells will appear on the sheet when you print. The path shown—Page Layout, then Print Area, then Set Print Area—is the correct location for this command. Other options involve clearing an existing print area, or point to a different group location, which aren’t about setting the print area.

In Excel, the print area defines which cells will be printed. To set it, first select the cells you want, then go to the Page Layout tab and use the Print Area option to Set Print Area. This places your current selection as the area to print, so only those cells will appear on the sheet when you print. The path shown—Page Layout, then Print Area, then Set Print Area—is the correct location for this command. Other options involve clearing an existing print area, or point to a different group location, which aren’t about setting the print area.