Excel Format.png Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently 1 users browsing this thread. (0 For a version of this tip written specifically for later versions of Excel, click here: Displaying a Hidden First Column. It takes just 2 minutes to sign up (and it's free!). Hiding a column tucks data out of sight without interfering with its function. this contact form
If you don't like Internet... Remember Me? Under Cell Size, click Row Height or Column Width, and then in the Row Height or Column Width box, type the value that you want to use for the row height Use a special VBA macro to unhide all columns automatically You'll find the macro below really helpful if you often get Excel worksheets with hidden columns and don't want to waste
HELP! Still there is one trick to help you locate hidden columns in Excel. these options didn't work for me -- so glad I found your website. Its works for me.
Repeat for column b 2nd Method Click on Column C header, whilst holding left mouse button down drag mouse pointer to the left, let go left mouse button and follow your Now you should be able to see column A in your Excel spreadsheet. Just add the macro and forget the unhide routine. Excel Hidden Columns Won't Unhide Reply With Quote Page 1 of 2 12 Last Jump to page: « Previous Thread | Next Thread » Like this thread?
option from the menu list. Unhide Columns In Excel 2013 Shortcut Click on a small triangle in the upper-left corner of your table to select the entire worksheet.Tip. Register To Reply 04-14-2016,11:03 AM #8 Hamsandwich View Profile View Forum Posts Registered User Join Date 04-14-2016 Location Kansas City, MO MS-Off Ver 2010 Posts 1 Re: Can't Unhide Column A If you later want to unhide column A, the solution isn't so obvious.
Thank you very much!!! I, too, had to unfreeze the panes of the spread sheet I was given, but then the first option worked. Unhide Column A In Excel 2016 John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. How To Unhide Rows In Excel 2010 For example let's say rows 1 - 10 in column A were hidden.
The rows 2,3,5 and 7 numbers are now hidden. weblink Register Help Remember Me? Make sure the checkboxes Select locked cells and Select unlocked cells are ticked. Sign Up Now! Can't Unhide Columns In Excel 2013
When I go to unhide only one sheet appears which comes up but then I can't get back to the original sheet. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals. How do I find and delete it. navigate here Grab a special macro to unhide all columns in Excel automatically each time you open a worksheet and find out how to protect the hidden columns from being displayed.
Press the Inspect button and the tool will start looking for hidden rows and columns. Can't See Column A In Excel You'll notice that the hidden rows 1 - 10 in column A will become visible if those had a non-blank value in column ‘B'. Sorry Rory I've never used the immediate window in VBE.
Yes No Great! If any questions left, feel free to comment on the post using the form below. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Unhide Column A In Excel Shortcut Reply Post a comment Click here to cancel reply.
RoyalCat Even if its after 2years- thank you very much, you just rescued me- i finally managed to unhide!!! I'm now wondering if my workbook has become corrupted somehow..? As soon as the search is over, you'll see the inspection results. his comment is here I couldn't see columns A-C on a critical Excel.
Click Hide Sheet from Hide & Unhide options. Dilli Binadi07 Jan 2016, 22:21 This was really helpful. All rights reserved. Your name or email address: Do you already have an account?
Similar Threads Can't unhide rows Kristie L. By Susan Harkins | in Microsoft Office, March 15, 2009, 5:00 PM PST RSS Comments Facebook Linkedin Twitter More Email Print Reddit Delicious Digg Pinterest Stumbleupon Google Plus Not everything in Choose Column from the Format menu, then choose Unhide. Click on the Format icon -> Hide & Unhide -> Unhide columns.
I am using Microsoft Office 2003 to 2016 Please remember everyone here is a volunteer, so if you have had a reply to your thread be courteous and acknowledge this.
© Copyright 2017 sonoportal.net. All rights reserved.