Home > In Excel > Can't Unhide Columns In Excel 2010

Can't Unhide Columns In Excel 2010


Excel makes it easy to hide and unhide columns. And I have ruled out split window/scroll area as suggested in this thread. Hi Tom, Sorry, I realize this is an old post, but, I just ran into exactly the same problem as Mike, the only difference is I'm using a 2003/2010 Excel combo. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. this content

This site is completely free -- paid for by advertisers and donations. Staff Online Now TechGuy Administrator Macboatmaster Trusted Advisor wannabeageek Malware Specialist Advertisement Tech Support Guy Home Forums > Software & Hardware > Business Applications > Home Forums Forums Quick Links Search Show Ignored Content As Seen On Welcome to Tech Support Guy! It is different, however, because instead of a black line dividing the double arrows, there are two black lines with a gap between them. http://www.mrexcel.com/forum/excel-questions/446760-cant-unhide-columns-what.html

Can't Unhide Columns In Excel 2010

You can select several columns by keeping the Ctrl button pressed. For a version of this tip written specifically for later versions of Excel, click here: Unhiding Columns that are Persistently Hidden. Irene Lozano09 Dec 2015, 12:42 Thanks, the best instructions on how to unhide column A in 2007 version.

  1. Enter your e-mail address and click "Subscribe." (Your e-mail address is not shared with anyone, ever.) Want to see what the newsletter looks like?
  2. Switch back to 2010, everything works fine.
  3. Author Bio Allen Wyatt With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author.
  4. Regards, Dave Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Oct 9th, 2013,01:45 AM #8 Tom Urtis MrExcel MVP Join Date Feb 2002 Location San Francisco, California
  5. All rights reserved.
  6. Unhiding a column takes a bit of specialized knowledge, but it isn't difficult.

Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Learn more about Allen... You may see the notification to save the latest changes before using Document Inspector in order to make sure you keep the important data.

Just click on the Yes or Unhide Column A In Excel 2007 If you happen to work with Excel files where some columns are hidden, you may want to know how to unhide columns in Excel.

This one is driving me insane! Cannot Unhide Columns In Excel 2013 There could be several things that need to be checked with the worksheet. The Connected World Traveler Next : By Ben Z. Check This Out Be happy and excel in Excel! 7 Responses to "How to unhide and show hidden columns in Excel" archie says: May 29, 2015 at 11:16 pm i havea pasword protected excelfile

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Excel Column A Hidden Can't Unhide Column A had disappeared and I couldn't get it back until I did this. You can then choose Column from the Format menu and then choose Unhide. That's it!

Cannot Unhide Columns In Excel 2013

Style Default Style Contact Us Help Home Top RSS Terms and Rules Copyright © TechGuy, Inc. http://www.excelforum.com/showthread.php?t=517786 The time now is 04:01 PM. Can't Unhide Columns In Excel 2010 Don't click any borders, just drag the selection mouse pointer (the fat arrow pointing down). Excel Column A Missing Tip.

Selecting just column B won't select column A. news Activate the worksheet where this is happening. One of the most common ways to "hide" columns without really hiding them is to freeze the panes. Press Alt+Q and see if that fixed what's ailing the sheet. Can't See Column A In Excel

Share Share this post on Digg Del.icio.us Technorati Twitter Tom Urtis Microsoft MVP - Excel Reply With Quote Oct 9th, 2013,02:46 AM #9 DaveU New Member Join Date Aug 2011 Location Please start a New Thread if you're having a similar issue.View our Welcome Guide to learn how to use this site. Those who prefer to keep their data unseen, can benefit from the possibility to disable the Unhide option. have a peek at these guys Drag your mouse pointer to the left until you see the border change its color.

If you want to display column B, select columns A and C. Excel Columns Missing Not Hidden Leave your own comment: *Name: Email: Notify me about new comments ONLY FOR THIS TIP Notify me about new comments ANYWHERE ON THIS SITE Hide my email address *Text: *What Click OK to save the changes.

Denise19 Jan 2016, 04:04 Thank you for this tip - it worked with first option.

This works well in 2010, yet if I open the same workbook with 2003, the columns will not unhide, programatically or manually. From now on, anyone who tries to unhide the columns in your Excel table will get the Unhide option disabled. Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. Where Is Format Menu In Excel Please post back with what you are seeing exactly, and what you have tried, and we can take it from there.

Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals. Mastering advanced Excel macros has never been easier. Thanks a lot! check my blog Excel - show hidden column A Unhiding columns in Excel may seem really easy until you have several hidden columns but need to display only the left-most one.

This should highlight whole sheet. All rights reserved. Full Bio Contact See all of Susan's content Google+ × Full Bio Susan Sales Harkins is an IT consultant, specializing in desktop solutions. For instance, if you hide column A, Excel will dutifully follow out your instructions.

If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. With this comprehensive guide, "Mr. Release the mouse cursor and go to Home -> Format -> Hide & Unhide -> Unhide Columns. Originally Posted by Tom Urtis So I assume this has been resolved, especially after another poster came forward with a Thank You.

Click OK to save the changes. However, it's not possible to copy all formulas, only their results. Hiding a column tucks data out of sight without interfering with its function. Show all hidden columns in Excel via Go To Special It can be rather difficult to find hidden columns.

Reply Sameen Javid says: December 18, 2015 at 12:35 pm I have a column having checkboxes in it in each row. That works fine until you try to unhide column A, as there's only one adjacent column, column B. This will show only column A and will leave the other columns hidden. It will teach you to show all hidden columns or just the ones you select.