Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to reference named range different sheet in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • Vlookup Examples in Excel
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel LOOKUP Function

Data Analysis Examples

  • How to Create One and Two Variable Data Tables in Excel
  • How to calculate correlation coefficient Correlation in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • How to Use Solver Tool in Excel
  • How to combine 2 or more chart types in a single chart in Excel

Data Validation Examples

  • Excel Data validation specific characters only
  • Excel Data validation must not contain
  • Excel Data validation exists in list
  • Excel Data validation must contain specific text
  • Excel Data validation whole percentage only

Hide and Unhide Columns or Rows in Excel

by

Only show just the data that you need to see or print by hiding columns or rows in Excel.

Sometimes it can be useful to hide columns or rows.

Worked Example:   How to test for all values in a range are at least in Excel

Hide

To hide a column, execute the following steps.

1. Select a column.

2. Right click, and then click Hide.

Result:

Note: to hide a row, select a row, right click, and then click Hide.

Worked Example:   Cell References: Relative, Absolute and Mixed Referencing Examples

Unhide

To unhide a column, execute the following steps.

1. Select the columns on either side of the hidden column.

Worked Example:   How to get address of named range in Excel

2. Right click, and then click Unhide.

Result:

Note: to unhide a row, select the rows on either side of the hidden row, right click, and then click Unhide.

Post navigation

Previous Post:

How To Insert, Edit Show or Hide Comments

Next Post:

How To Skip Blanks Using Paste in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Get last name from name with comma — Manipulating NAMES in Excel
  • Get first name from full name — Manipulating NAMES in Excel
  • Convert Numbers to Text in Excel
  • How to extract name from email address in Excel
  • TRIM function: Description, Usage, Syntax, Examples and Explanation
  • Dynamic date list in Excel
  • How to Calculate Age in Excel
  • Calculate years between dates in Excel
  • TIME function: Description, Usage, Syntax, Examples and Explanation
  • Get days, hours, and minutes between dates in Excel
  • Future value vs. Present value examples in Excel
  • How to calculate annual compound interest schedule in Excel
  • FV function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYBS function: Description, Usage, Syntax, Examples and Explanation
  • DISC function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles