Log in
x
or
x
x
Register
x

or

Excel Tips: Edit > Hide or Unhide

Hide Cell Contents

How to hide all error values in Excel?

How to hide duplicate records in columns in Excel?

How to hide error values in pivot table?

How to hide negative numbers in Excel?

How to hide or display cells with zero value in a Worksheet in Excel?

How to hide or display cells with zero value in selected ranges in Excel

How to hide the True/False words within cell when linked to checkbox in Excel?

How to hide zero currency in Excel?

How to hide zero percent in Excel?

How to only show positive numbers in Excel?

How to quickly hide cell contents in Excel?

How to quickly hide cell values in Excel?

How to show only first nth characters in a cell string?

How to show only the last 4 digits of social security number (ssn) in Excel?

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?

Hide Formulas (Actual Values) in Formula Bar

How to hide formula bar contents in Excel?

How to hide formula but display the result without protecting worksheet in Excel?

How to hide formulas not displayed in the formula bar in Excel?

How to not show/hide formulas from formula bar in Excel?

Others

How to quickly filter or hide even or odd numbers in Excel?

How to quickly Hide Excel Workbooks in Excel?

How to show image on mouseover in Excel?

How to show or hide all objects (pictures/charts/shapes/comments) in Excel?