Excel Tips: Edit > Hide or Unhide

Hide Rows or Columns

Hide Rows

How to auto hide rows if blank cells in a column?

How to display only rows with certain text in Excel?

How to hide blank rows in PivotTable in Excel?

How to hide every other row in Excel?

How to hide grand total in an Excel pivot table?

How to hide multiple blank rows or columns in Excel at once in Excel?

How to hide or unhide specified rows or columns when double-clicking a cell in Excel?

How to hide rows based on cell color in Excel?

How to hide rows based on cell value in Excel?

How to hide rows based on today’s date in Excel?

How to hide rows if cell is blank in Excel?

How to hide rows if duplicate in Excel?

How to hide rows with zero value in Excel?

How to hide selected items in pivot table?

How to hide subtotals in pivot table?

How to hide/unhide rows or columns with plus or minus sign in Excel?

How to show hidden first column or row in Excel?

How to show only duplicate rows in Excel column?

How to unhide or show columns & rows in Excel?

How to use checkbox to hide/unhide rows or columns in Excel?

Hide Columns

How to automatically hide columns based on date in Excel?

How to hide columns on multiple sheets in a workbook?

How to hide multiple blank rows or columns in Excel at once in Excel?

How to hide or unhide columns based on drop down list selection in Excel?

How to hide or unhide specified rows or columns when double-clicking a cell in Excel?

How to show hidden first column or row in Excel?

How to toggle between hidden and visible columns in Excel?

How to unhide or show columns & rows in Excel?

How to use button to show hide columns in Excel?

How to use checkbox to hide/unhide rows or columns in Excel?

Set Scroll Area

How to limit number of rows and columns in a worksheet in Excel?

How to limit scroll area of a worksheet in Excel?

How to lock screen to prevent scrolling in Excel worksheet?

How to only show print area in a worksheet in Excel?

How to quickly grey out all unused area in Excel?

How to quickly hide unused cells, rows, and columns in Excel?

How to quickly hide unused cells, rows, and columns in Excel?

How to set scroll position or hide other cells in Excel?

Hide Sheets

How to automatically hide specific worksheets when opening an Excel file?

How to display or hide sheet tabs and Sheet Tab Bar in Excel?

How to hide all worksheets except/but the specified or active one in Excel?

How to hide or unhide a specific worksheet based on cell value in another sheet?

How to hide worksheets or all Inactive worksheets in Excel?

How to make the worksheet very hidden and visible in Excel?

How to quickly show active or selected sheets only in Excel?

How to restrict access to a certain worksheet in Excel?

How to toggle between hidden and visible sheets in Excel?

How to unhide all worksheets & sheets in Excel?

How to use checkbox to hide or unhide worksheet in Excel?

How to quickly Hide Excel Workbooks in Excel?