Reply archie says: May 29, 2015 at 11:17 pm it is in excel 2013 Reply Maria Azbel (Ablebits.com Team) says: December 17, 2015 at 2:05 pm Hello, Archie, I'm really sorry, Advertisement Tech Support Guy Home Forums > Software & Hardware > Business Applications > Home Forums Forums Quick Links Search Forums Recent Posts Members Members Quick Links Notable Members Current Visitors See how much you know with this short quiz. I have a workbook that runs a macro to hide/unhide selected columns, then saves & closes the workbook. navigate here
The obvious doesn't seem to work. Then press Ctrl+G Paste or type in ActiveWindow.SplitColumn = 0: cells.Columns.hidden = false: ActiveSheet.ScrollArea = "" and hit the enter key. First, you'll want to check to make sure that the columns aren't being hidden by some macro running in the background. More» Readers' Choice Awards 2016: Speakers & Headphones You need great audio.
You simply click on a column to the left of the hidden columns, drag to the right of them, and then select Format | Column | Unhide. regards, Dave Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Oct 9th, 2013,03:17 AM #10 Michael M Board Regular Join Date Oct 2005 Location Western NSW Posts Read on to see what PCMag readers thin... I'm wondering if it's an 03/07 glitch.
Latest News FEATURED VIDEOS Most Read Features SPONSORED REPORT Year-end tax planning and what’s new for 2016 Practitioners need to consider several tax planning opportunities to review with their clients before LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode There is nothing intuitive about this solution, which works in Excel 2003 and 2007. How To Unhide Columns In Excel 2016 I'll try that when I get to work tonight, thanks.
How to unhide all columns in Excel Use a special VBA macro to unhide all columns automatically Unhide only the columns you select Excel - show hidden column A How to Can't Unhide Columns In Excel 2013 Press Alt+Q and see if that fixed what's ailing the sheet. First, ask the co-worker what is going on. https://www.techonthenet.com/excel/columns/unhide_cola.php Try autofitting all columns or setting the column width for all columns to 10 if freeze panes is not the answer.
As soon as the search is over, you'll see the inspection results. Can't See Column A In Excel Don't click any borders, just drag the selection mouse pointer (the fat arrow pointing down). View the most recent issue. That's it!
Go to Home -> Format -> Hide & Unhide -> Unhide Columns. why not try these out Full Bio Contact See all of Susan's content Google+ × Full Bio Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Can't Unhide Column A In Excel See solution in other versions of Excel: Excel 2016 Excel 2013 Excel 2011 for Mac Excel 2010 Excel 2007 Excel 2003 Before trying the following solution, you might want to make Excel 2013 Unhide Column Shortcut If you're not already familiar with forums, watch our Welcome Guide to get started.
Click on a small triangle in the upper-left corner of your table to select the entire worksheet.Tip. check over here This will show only column A and will leave the other columns hidden. toll_booth, May 12, 2009 #1 Sponsor drCarls Joined: May 12, 2009 Messages: 4 Hi there, Not sure if you're using 2007 but hopefully will work with previous versions as well. 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 Excel Columns Missing Not Hidden
Jo has tried unhiding them to no avail, even copying the columns and pasting them into empty columns inserted at columns C and D. I was working with Excel 2007 at home and hid all columns to the right of the last column in every sheet. computerman29642, May 13, 2009 #5 toll_booth Thread Starter Joined: Oct 21, 2008 Messages: 58 nreves said: ↑ or if you get the two vert lines to separate the columns, right click his comment is here Any suggestions would be greatly appreciated.
They will work for any column you want to unhide in Excel. Cannot Unhide Rows In Excel From now on, anyone who tries to unhide the columns in your Excel table will get the Unhide option disabled. Yes, my password is: Forgot your password?
Under the Format menu, select Column > Unhide. Pick one of the tricks below to unhide only the first column in your table. 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 http://culturahq.com/in-excel/can-39-t-insert-column-in-excel.html And while it works, the Unhide command will unhide the entire sheet.
Make sure the Hidden Rows and Columns option is checked. All rights reserved. either way will work.Click to expand...