Hide Rows and Columns

Hide Rows and Columns helps you temporarily remove selected rows or columns from view while keeping their data in the worksheet. It provides the tools you need to simplify table views and screen out nonessential data without affecting calculations, making your work more efficient and helping you accomplish tasks with ease. With Hide Rows and Columns, you can hide a single row or column, hide multiple rows or columns in one action by selecting several targets, and unhide previously hidden content by selecting the adjacent visible rows or columns on both sides. Hidden data remains available in the worksheet, and formulas and references continue to work normally. Whether you're reducing visual clutter or focusing on key information, Hide Rows and Columns helps you stay productive and complete tasks efficiently. Choose the documentation below that best matches your needs to learn more.

1:53