HOW TO UNHIDE (AND HIDE) COLUMNS AND ROWS [THE BEST METHOD]

[@Spreadsheeto]

👋 3 ways I can help you! 1) *Free 30-minute Excel Course:* Try a course that adapts to your skill level, trusted by over 100,000 students! spreadsheeto.com 2) *Fast-Track Your Excel Learning:* "Zero to Hero" transforms you from a beginner to an Excel superuser in just 14 hours. spreadsheeto.com/zero-to-hero/ 3) *Custom Solutions for Busy Professionals:* Busy or stuck? Hire me to fix or build custom spreadsheets. spreadsheeto.com/excel-consultant/

[@nyancole]

Thanks Sir. Your process is simply easy and I tested it and worked for me. Thanks!

[@virginias4973]

Thank you!! So fast and easy with your description

[@shaurishauri7786]

Wow... this helps with my work now because I was clicking over and over again when I can make it at one. Thanks for sharing.

[@limatapualii4310]

Thank you it's simple to understand. God bless

[@hebe4703]

You're heaven sent!

[@cesargarcia7228]

Thank you!

[@cristinejoymaranon7257]

This is the best tutorial

[@leongrin6348]

Amazing. Thank you.

[@sanashaikh2348]

Really helpful

[@gregmcmurray5718]

Thanks - unhiding Column A

[@JRMehta-qd4mp]

Easiest way to unhide the Column A is to select the complete worksheet, copy it and paste it to a new worksheet.

[@newellenielsen5626]

Knew it but thanks!

[@Spreadsheeto]

Nice!

[@JohnTOPChitwood]

I have an excel sheet that has columns a-e missing. Nothing works to free up the hidden columns. I thought at one time there was a fast way to capture the visible columns and the control or something key to see all columns. What is the magic.

[@LM-xz1rc]

I'm missing Rows 1-4. When I right click on Row 5 unhide it doesn't reveal anything. I"ve tried dragging it up as well and it's not uncovering anything. I've tried inserting rows to "eek" then out, but nope.... Would you have any other solutions? I'm on a Mac. TSM!

[@wajidali-qc6rg]

Good

[@jayswallinak1617]

It's not working in my excel. Please suggest something else

[@jamainedobson2582]

Still doesnt work for me on mac

[@jamainedobson2582]

Nevermind I figured out what the problem was

[@wcjbic]

I'm on a mac, and wasn't able to unhide row 1.

[@miriamsilvia]

How to unhide rows on numbers

[@yolandamcpherson3807]

Unhide😢 did not work

[@georgeflemetakis8496]

Didn't work for me, it only unhides the rows one by one

[@jamainedobson2582]

Same for me but I figured out a trick. select the whole spreadsheet and hide all the rows (so the entire spreadsheet is hidden), then unhide all the rows

[@sanjay.csanju7108]

It’s not working can u teach properly or else don’t teach only

[@jamainedobson2582]

I figured out a trick. select the entire spreadsheet then hide all the rows and unhide all the rows. It should work then