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 a spreadsheet view or mask non-critical 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, batch hide multiple selected rows or columns, and manage hidden content by unhiding individual or all hidden rows or columns. Hidden data remains available for formula references and calculations. Whether you're reviewing a sheet, reducing visual clutter, or checking for skipped row numbers or column headers to identify hidden content, Hide Rows and Columns helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.