• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Browsers
    • Gaming
    • Hardware
    • Internet
    • iPhone
    • Linux
    • macOS
    • Office
    • Reviews
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Excel: Unhide Rows or Columns

Excel: Unhide Rows or Columns

December 16, 2022 by Mitch Bartlett 8 Comments

If you can’t see certain rows or columns in Microsoft Excel, it may be because they are hidden. Here’s how to unhide rows or columns.

Note: The steps illustrated are from desktop client versions of Microsoft Excel as well as Excel 365. Mobile versions have the same menus, but may require slightly different steps.

  1. Select the columns or rows that are before and after the one you would like to unhide.
    Select Columns
  2. Select the “Home” tab.
  3. In the “Cells” area, select “Format” > “Hide & Unhide” > “Unhide Columns” or “Unhide Rows” as desired.
    Select unhide columns
  4.  The column or row should now be unhidden.
    Hidden columns are displayed

You can also use a shortcut to hide or unhide rows and columns

  • Ctrl + Shift + 0 => to unhide the hidden columns within the selection
  • Ctrl + Shift + 9 => to unhide the hidden rows within the selection
  • Ctrl + 0 => to hide the selected columns
  • Ctrl + 9 => to hide the selected rows

FAQ

Why doesn’t hiding and unhiding work when I use these steps?

You may have to unfreeze the selection first. Click on the View tab, then select on Freeze Panes > Unfreeze Panes.

You Might Also Like

  • Hide and Unhide Rows and Columns in Google Sheets
    Hide and Unhide Rows and Columns in Google Sheets
  • Freeze or Unfreeze Panes, Columns, and Rows in Excel
    Freeze or Unfreeze Panes, Columns, and Rows in Excel
  • How to Combine Two Columns in Excel: 5 Best Methods
    How to Combine Two Columns in Excel: 5 Best Methods
  • Spotify: How to Hide or Unhide a Song
    Spotify: How to Hide or Unhide a Song
  • Word 2019/2016: How to Hide or Unhide Text
    Word 2019/2016: How to Hide or Unhide Text
  • iPhone & iPad: How to Hide or Unhide Photos & Videos
    iPhone & iPad: How to Hide or Unhide Photos & Videos

Filed Under: Office

Reader Interactions

Comments

  1. Linda says

    July 2, 2020 at 4:50 am

    Thank you to those who mentioned the unfreeze. That worked!

  2. Peter de Bruijn says

    February 20, 2018 at 11:35 am

    I agree with the first comment w/r/t the freeze option

  3. Tom says

    November 3, 2017 at 5:54 pm

    Agreed with the other posts that my issue was a combination of unhide plus unfreeze panes. With the panes still frozen the rows and colums would not unhide. Seems like MSFT needs to make it easier to prompt users somehow, or have the unhide override the freeze panes issue. It took me quite a while to figure this out and I’ve been using Excel for 10+ years.

  4. Aaron Arutunian says

    October 25, 2017 at 6:54 pm

    Thank you Brad! I too had to “Unfreeze Panes” before i could see column A.

  5. Brad Dyer says

    June 27, 2016 at 8:39 am

    Stuart’s tip did not work for me, however, when I selected all rows & columns, clicked on ‘View’ tab, then clicked on Freeze Panes, and had the option to unfreeze. That worked!

  6. Susan says

    June 7, 2016 at 8:47 am

    Stuart’s tip worked for unhiding rows. I had already tried, unsuccessfully, to unhide the typical way and tips from other posts.

    Thank you Stuart!

  7. Stuart says

    April 4, 2016 at 11:18 am

    Here’s the simple way, using shortcut

    Ctrl + Shift + 0 => to unhide the hidden columns within the selection
    Ctrl + Shift + 9 => to unhide the hidden rows within the selection
    Ctrl + 0 => to hide the selected columns
    Ctrl + 9 => to hide the selected rows

    I’ve tried it and works in excel 2007, 2010 and 2013.

  8. Barton says

    March 1, 2016 at 1:12 pm

    Does not seem to work when columns A to E are hidden and cells F1 to H1 are merged.

Did this help? Let us know!

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • How to Reset Root Password on Steam Deck
  • How to Update Steam Deck
  • Fixed Error Code: Out of Memory on Windows 11 Web Browsers
  • How to Play Minecraft on Chromebooks
  • Windows 11: How to Access and Use the Free Sound Recorder App
  • How to Enable Split-Screen in Microsoft Edge
  • How to Use Microsoft PowerToys in Windows 11/10
  • How to Turn Steam Deck Into Desktop PC

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

© Copyright 2023 Guiding Tech Media · All Rights Reserved · Privacy