How To Get My Natural Curls Back After Straightening - A4 Accounting

Home » How To Get My Curls Back » How To Get My Natural Curls Back After Straightening - A4 Accounting

Maybe your like

Skip to content
  • Post author:Neale Blackwood
  • Post comments:48 Comments
  • Reading time:1 min read

There are certain situations when you can’t “unhide” columns on the left and/or rows at the top and it is not a sheet protection issue.

It is also not an unhiding issue. It is caused by Freeze Panes. It depends where you are when you set your Freeze Panes.

Freeze Pane is in the View ribbon.

Freeze Panes keeps certain rows at the top and columns to the left as you scroll around. But it can also stop you from seeing certain rows and columns.

If you have scrolled to the right and then set your Freeze Panes then it can stop you seeing the columns on the left.

If you have scrolled down the sheet and then set your Freeze Panes it can stop you seeing the rows at the top.

The easy solution if you want to see or unhide the rows or columns is to remove the Freeze Panes. The easy way to do that is to press in sequence

Alt w f f

This is a toggle command so you can also use it to apply Freeze Panes.

Related Posts

  • Alt Key Shortcuts
  • Excel Full Screen
  • Bullet Points in Excel
  • Another Alt key Shortcut in Excel
  • Filter Issue with Excel
Tags: Alt key, Popular, Shortcut key

Share this content

  • Opens in a new window
  • Opens in a new window
  • Opens in a new window
  • Opens in a new window

Read more articles

Previous PostCopying a Date Down a Long List in Excel Next PostFiltering blanks made easy

You Might Also Like

Summing Coloured Cells in Excel

13/08/2014

Copy As Picture

06/03/2015

Excel Drop Down Improvement

11/06/2024

This Post Has 48 Comments

  1. Jane 09/12/2019 Reply

    Thanks a lot for posting this. Just the first line of article helped to unhide columns in a secons, for which I was going mad from last 2 hours wondering why unhide option was not working in my excel.

    1. Neale Blackwood 09/12/2019 Reply

      Yes it is a frustrating issue – glad it helped.

  2. Mike Laaper 15/01/2020 Reply

    Fantastic! this was my issue, and I never thought it was a freeze pane issue.

    Thank you.

    1. Neale Blackwood 15/01/2020 Reply

      Happy to help.

  3. Graeme 23/02/2020 Reply

    Unfortunately Freeze Panes was already unfrozen as part of my troubleshooting 🙁

  4. Graeme 23/02/2020 Reply

    Hello again. I found a solution that worked for me from a 2012 post:

    “If you already tried unhiding columns, try below one:- Select all columns (Ctrl + A) and do the column width to 10 point…”

    https://a4accounting.com.au/unable-to-unhide-columns-or-rows-in-excel/

    I never would have thought!

    1. Neale Blackwood 23/02/2020 Reply

      Hi Graeme Thanks for sharing. Yes, there is a hack way to hide rows and columns using a 0 for row height or column width. That’s what your technique fixes. Regards Neale

    2. lisa 23/01/2021 Reply

      thank you so much! this has worked for me.

  5. Thecead 17/03/2020 Reply

    I have 530 rows hidden and I don’t want to sit and double click 530 times to unhide ALL of them. Is there no a000 t a way to unhide a rediculous number of hidden rows all at once?

    1. Neale Blackwood 17/03/2020 Reply

      Press Ctrl + A to select the whole sheet – then press in sequence Alt H O U O don’t hold the keys down.

    2. Nigel Wiseman 09/01/2021 Reply

      Adjusting the column width to 10 worked for me two. Thanks to everyone.

  6. J K 03/05/2020 Reply

    Hello,

    Just created the account to say — Thank you so much

    1. Neale Blackwood 03/05/2020 Reply

      Happy to help.

  7. Chris 26/05/2020 Reply

    I’ve tried everything I possibly could to no success however your Tip on Freeze / Unfreeze Panes proved just what I was looking for, thank you!

    1. Neale Blackwood 26/05/2020 Reply

      It is not intuitive – glad you sorted it out.

  8. Reesh 29/05/2020 Reply

    Thanks a lot for this article. Extremely helpful or I would’ve been going for one hour trying to solve this problem.

    1. Neale Blackwood 29/05/2020 Reply

      Happy it helped.

  9. martin murray 24/06/2020 Reply

    Thanks so much. So lame of all the other sites not to mention the possibility. I’ll have to remember your site

    1. Neale Blackwood 24/06/2020 Reply

      Glad it helped.

  10. Sheem L 30/06/2020 Reply

    This totally answered my question. Thank you so much for sharing. I overlooked the panes

    1. Neale Blackwood 30/06/2020 Reply

      Yes the panes are a pain in this case.

  11. Donna 03/07/2020 Reply

    Thank you for this minor, but significant point about unfreezing panes. Do you think Microsoft could include this in their instructions? (sarcasm) Again, thanks a million!

    Like other users, been dealing with this for more than an hour until I came across your info.

    1. Neale Blackwood 03/07/2020 Reply

      Hi Donna Yes it would be an easy add to the unhide instructions “if all else fails remove freeze panes”. Glad you resolved it eventually. Regards Neale

      1. An 14/07/2020 Reply

        Hi, No success after trying the methods above. columns from A to L are still hidden?

        1. Neale Blackwood 14/07/2020 Reply

          Have sent you an email with the following suggestion. Have you tried selecting the columns and changing the column width to 8? You can right click the columns after selecting them to access column width.

  12. An 14/07/2020 Reply

    Hi, Use the following if above methods didn’t work: When the Go To window appears, enter A1 in the Reference field and click on the OK button. Best, A

    1. Neale Blackwood 14/07/2020 Reply

      Glad you got it sorted.

      1. Ashlye Davis 07/08/2020 Reply

        What if none of the methods work? I’ve unfrozen everything. I try to unhide, it doesn’t do it 🙁

        1. Neale Blackwood 07/08/2020 Reply

          Hi Ashlye Try this Click the icon where the rows and columns meet top left corner. This selects the whole sheet. On the Home ribbon click the Format icon drop down (far right side) Select Hide & Unhide Choose Unhide rows or Unhide columns. Any luck? Regards Neale

          1. JT 01/10/2021

            Worked like a charm when any other methods above didn’t work for my case. Thanks so much for sharing!

          2. Neale Blackwood 08/10/2021

            Glad it helped.

        2. Neale Blackwood 07/08/2020 Reply

          Hi Ashlye Another way to try is to change the row height or column width – if you set the column width to 1 it looks hidden but actually isn’t. Same with row height. Regards Neale

  13. Linda 07/08/2020 Reply

    This is helpful, never though that my issue is a freeze pane.

  14. Arielle 26/08/2020 Reply

    For anyone who has tried it all and nothing worked, try select all, then double click on the area where the rows are numbered/hidden cells indicated. It should unhide all

    1. Neale Blackwood 26/08/2020 Reply

      Thanks Arielle Press Ctrl + A until the whole sheet is selected. Then double click any line (need the double headed arrow icon) between the row numbers (left hand side) or column letters (above the grid) to unhide any hidden rows or columns.

      1. JA 28/08/2020 Reply

        Thank you so much for your response. All other suggestions did not work but your did. Extremely frustrating issue to have when dealing with large amounts of data.

        1. Neale Blackwood 28/08/2020 Reply

          You are welcome.

  15. Nicola 09/09/2020 Reply

    Thank you so much! I was going mad trying to figure out why I couldn’t see my top rows!

  16. Aileen Hampton 29/09/2020 Reply

    We thank you, thank you, thank you!

  17. Nat E 11/11/2020 Reply

    Thank you. although mine wasnt a freeze pane issue it pointed me in the right direction. i realised i had a filter on and the cells that contained the ‘to be filtered from’ cells were also mysteriously in the hidden rows so i just removed the filter and hey presto i could then unhide cells.

    many thanks

  18. vinodsri 10/12/2020 Reply

    I was facing the same issue and now it is resolved. Thanks a lot for the suggestion.

    1. Neale Blackwood 10/12/2020 Reply

      Happy it helped.

  19. Shell 10/02/2021 Reply

    Thank you for sharing this answer

  20. Jonathan Holmes 24/04/2021 Reply

    I have had this happen many times. When the proposed approaches mentioned previously did not work it was because I had a filter in place so when i cleared that filter, i was able to unhide the hidden rows.

    1. Neale Blackwood 24/04/2021 Reply

      Hi Jonathon When a filter is in place the row numbers turn blue, making it easier to spot a filter. Alt A C pressed in sequence clears filters. Regards Neale

  21. Kim Cerrato 26/04/2021 Reply

    Thanks you!!!

  22. Drew 11/11/2021 Reply

    Thanks Neale, life saving tip.

    1. Neale Blackwood 15/11/2021 Reply

      Happy to help.

Leave a Reply Cancel reply

CommentEnter your name or username to comment Enter your email address to comment Enter your website URL (optional)

Save my name, email, and website in this browser for the next time I comment.

Δ

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

Tag » How To Get My Curls Back