×
英语
很抱歉。本文没有你的语言版本。

Print worksheet with the hidden rows and columns

In Excel Online, when you print a worksheet with hidden rows or columns those hidden rows and columns won’t be printed. If you want to include the hidden rows and columns, you’ll need to unhide them before you print the worksheet.

You can tell if rows or columns are hidden either by the missing header labels or by the double lines as shown in this picture.

double lines between rows and columns indicate hidden rows or columns

Here’s how you can unhide rows or columns:

  1. Select the range of headers surrounding the hidden rows or columns. In this example, select all row headers between 2 and 7 to unhide rows 3 and 6.

    select the range of headers around hidden rows or columns

  2. Right-click the selection and pick Unhide Rows (for columns, pick Unhide Columns).

  3. Click File > Print.

  4. Click Print for a print preview.

    Print preview

  5. In the Print Options box, make sure Entire Sheet is selected, and click Print.

Note:  The row and column labels don’t show in print preview and the printout.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×