Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

MS Excel: Unhide Column A or Row 1

Friday, July 9th, 2010 by | Filed Under: MS Excel

If you’re an Excel user who tends to use the Hide feature for columns and rows, then you’ve probably run into this problem a time or two.

When you chose to hide either Column A or Row 1 were you able to get it back?

It can be quite tricky since we usually highlight the column or row on each side of the hidden one and then right-click and choose Unhide.

But when it’s the first column (or row) what do you do? How do you highlight the column to the left of column A?

In fact this scenario is more than tricky if you don’t what to do… it can be completely frustrating, even infuriating if you fight with it long enough.

While I’m sure that there are many solutions to this dilemma I’d like to present two of them today.

Let’s start with the concept of highlighting two columns (or rows).

I know that if column A is hidden then you don’t officially have a column on the left to highlight but the column of row numbers will do.


Start by highlighting column B and then drag your mouse pointer left above the 1.

Once they’re both highlighted then right-click on the selection and choose Unhide.

The second method I’d like to discuss requires some finesse with your mouse but is quick and clean if you’ve got a steady hand.

Instead of highlighting entire columns simply place your mouse pointer between the header for column B and the column of row numbers.

Usually at the borders of column headers we get a double arrowed pointer something like this:


But the one we should get at the juncture of two headings where a column is hidden is different. It’s more like this one with two vertical lines and a gap between the two halves:


Once you have the pointer right-click and then choose Unhide from the menu. (Yes – this one works with any hidden column or row so if you’re good at it you might have just found your new favorite trick for all your unhides.)

Either way – you’ll immediately be pleased to see your column or row unhidden without a lot of fuss and aggravation.


3 Responses to “MS Excel: Unhide Column A or Row 1”

  1. Basuki says:

    Simple way to Unhide Column A in Excel 2003,
    -Drag left Column that showing ( ex. Column B) till left Column ( grey area ).
    – Format, Column, HIDE

  2. Basuki says:

    Sorry, wrong above Explanation.

    I mind, select all range in sheet by click ( left – top corner ) then go to format menu, column, HIDE. ( will HIDEN ALL range )
    Goto Format menu again, column, UNHIDE.


  3. RSilva says:

    You can also copy it to another sheet, if others won’t work. Select the entire sheet and even the hidden column/s will appear when you paste it.

Leave a Reply

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.

Enter Email Address:


Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup

Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive