Hidden Content in Excel Workbooks

Excel allows you to hide rows, columns, and sheets. While this can help with presentation, hidden content is inaccessible to many users and can cause confusion when data appears to be missing.

What This Means

Rows, columns, or sheets that are hidden from view may contain important data that users need. Hidden content can be missed entirely by screen reader users and others who don't know to look for it.

Why It Matters

• Hidden content is often overlooked by users who don't know it exists
• Screen readers may skip hidden rows and columns
• Formulas referencing hidden data can be confusing
• Printing excludes hidden content, potentially omitting important data

Common Violations

XLSX-07-001: Hidden Rows or Columns Contain Meaningful Data {#XLSX-07-001}

What's Wrong: The workbook has hidden rows or columns that contain data users need to see or understand.

Impact: Moderate - Users may miss important information or be confused by apparent gaps in data.

How to Identify:

Missing Row/Column Numbers:

• Look at row numbers on the left (1, 2, 4... indicates row 3 is hidden)
• Look at column letters at the top (A, B, D... indicates column C is hidden)

Using Go To Special:

1. Press Ctrl+G or F5 to open Go To
2. Click Special
3. Select Visible cells only
4. Click OK
5. If selection appears broken, hidden cells exist

Finding Hidden Sheets:

1. Right-click any sheet tab
2. Select Unhide
3. If sheets appear in the list, they were hidden

How to Fix:

Option 1: Unhide Content

1. Select rows/columns surrounding the hidden area
2. Right-click and select Unhide
3. Content becomes visible

Option 2: Move Data to Visible Location

1. Unhide temporarily
2. Move important data to visible rows/columns
3. Re-hide if the hidden content is truly not needed

Option 3: Delete Hidden Content

1. Unhide the rows/columns
2. If data is not needed, delete it
3. Recalculate formulas if necessary

Why Content Gets Hidden

Common Reasons:

• Intermediate calculations - Helper columns for formulas
• Source data - Raw data behind summaries
• Previous versions - Old data kept "just in case"
• Presentation - Simplifying view for printing

When Hiding Is Acceptable:

• Truly intermediate calculations that users don't need
• Formatting helper cells (like lookup tables)
• Content that's accessible elsewhere in the workbook

When Hiding Is Problematic:

• Source data that users might want to verify
• Complete records (hiding rows in a list)
• Critical information for understanding the workbook

Alternatives to Hiding Content

Grouping (Better Than Hiding)

1. Select the rows or columns to group
2. Go to Data > Group
3. Users can expand/collapse groups with +/- buttons
4. Content is accessible but organized

Benefits of Grouping:

• Users know content exists (see expand button)
• Easy to show/hide with one click
• Screen readers can navigate group boundaries
• More transparent than hiding

Separate Sheets

1. Move detailed data to a separate sheet
2. Name the sheet clearly ("Source Data")
3. Reference it in the main sheet if needed

Footnotes or Notes

1. Add notes explaining where to find detail
2. Use cell comments for additional context
3. Include references to other sections

Filtering

• Use AutoFilter to show/hide data dynamically
• All data remains technically visible
• Users control what they see

Documenting Hidden Content

If you must use hidden content:

1. Note its existence - Add text explaining "Hidden columns contain calculation details"
2. Explain how to access - Include instructions for unhiding
3. List what's hidden - In a documentation sheet, list all hidden areas

Example Documentation: "Note: Columns D-F are hidden and contain intermediate calculations. To view, select columns C and G, right-click, and choose Unhide."

Screen Reader Behavior with Hidden Content

Hidden Rows/Columns:

• Most screen readers skip over hidden cells
• Users may not know the content exists
• Formulas referencing hidden cells still work but can confuse users

Hidden Sheets:

• Screen readers typically list only visible sheets
• Users must actively look for hidden sheets
• Important content on hidden sheets is inaccessible

Checking for Hidden Content

Manual Check:

1. Look for gaps in row numbers or column letters
2. Right-click sheet tabs and check Unhide option
3. Review if any formulas reference hidden cells

Using Name Manager:

1. Go to Formulas > Name Manager
2. Review named ranges - some may reference hidden areas

Unhide All:

Rows: Select all (Ctrl+A) > Right-click > Unhide Columns: Select all > Right-click > Unhide (may need to repeat) Sheets: Right-click tab > Unhide (repeat for each)

Best Practices

Do:

• Use grouping instead of hiding when possible
• Document any hidden content
• Keep essential data visible
• Consider separate sheets for auxiliary data

Don't:

• Hide important information users need
• Hide rows in the middle of data tables
• Assume users will know to unhide content
• Use hiding as a security measure (it's not secure)

Additional Resources

• Microsoft: Hide or show rows or columns
• W3C WCAG 1.3.1 Info and Relationships