To print all columns on a single page without changing column widths, which configuration should you apply?

To print all columns on a single page without changing column widths, which configuration should you apply?

• A. View, Show group, Uncheck Gridlines
• B. Page Layout, Scale group, Next to Width click the arrow in Automatic, 1 Page
• C. Page Layout, Page Setup group, Breaks, Insert Page Break
• D. Home, Print, Fit to One Page

Answer: (B)

To print all columns on one page without changing their widths, you use scaling to fit the sheet’s width on a single page. In Excel, go to the Page Layout tab and in the Scale to Fit group, set the Width to 1 Page (leave Height as Automatic). This shrinks the entire worksheet enough so every column fits across one printed page while keeping each column’s width intact. Other options don’t accomplish this: hiding gridlines affects only the view/print of gridlines, inserting a page break creates multiple pages, and a general fit-to-one-page setting doesn’t specifically control column widths.

To print all columns on one page without changing their widths, you use scaling to fit the sheet’s width on a single page. In Excel, go to the Page Layout tab and in the Scale to Fit group, set the Width to 1 Page (leave Height as Automatic). This shrinks the entire worksheet enough so every column fits across one printed page while keeping each column’s width intact. Other options don’t accomplish this: hiding gridlines affects only the view/print of gridlines, inserting a page break creates multiple pages, and a general fit-to-one-page setting doesn’t specifically control column widths.