If you happen to work with Excel files where some columns are hidden, you may want to know how to unhide columns in Excel. Before you share the table with your colleagues you need to make sure no one will unhide the columns. Related Tips: Changing Column Width Unhiding a Single Column Countering Compressed Columns Setting the Standard Column Width Save Time and Supercharge Excel! Switch back to 2010, everything works fine. http://culturahq.com/in-excel/cannot-unhide-columns-in-excel-2013.html
Select the columns that are adjacent to the hidden column. This tip (6400) applies to Microsoft Excel 97, 2000, 2002, and 2003. i tried already to make it a macro with Sub UnhideAllColumns () Cells.EntireColumn.Hidden = False EndSub but it didn't work can anybody help? Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 18 Can't Unhide columns - What the ???This is a discussion on Can't Unhide columns - What http://www.mrexcel.com/forum/excel-questions/446760-cant-unhide-columns-what.html
Open your workbook and navigate to the Home tab. Resourceful. Then enter and reenter the password. Try autofitting all columns or setting the column width for all columns to 10 if freeze panes is not the answer.
Click on the Find & Select icon and pick the Go to Special... Excel 2013 Unhide Column Shortcut Simply click Remove All. Although nothing appears to happen, you actually selected those two hidden rows. useful reference Hiding Columns Redisplaying Columns Hiding Rows Redisplaying Rows Hiding Cell Contents Hiding Columns If there is information on your worksheet you do not need to see or if you want to
Worked for me :) Our Company Sharon Parq Associates, Inc. check over here Those who prefer to keep their data unseen, can benefit from the possibility to disable the Unhide option. Show all hidden columns in Excel via Go To Special It can be rather difficult to find hidden columns. Disable the Unhide column option Say, you hide some columns with important data like formulas or confidential information. How To Unhide Columns In Excel 2016
Sub UnhideAllColumns () Cells.EntireColumn.Hidden = False EndSub If you don't know VBA too well, feel free to explore its possibilities by reading our article How to insert and run macros. How To Unfreeze Panes In Excel Hiding Columns: Quick Menu Option Windows: Right click the column ID » select Hide Macintosh: Press [control] and click the column ID » select Hide Redisplaying Columns Select at least one The Connected World Traveler Next : By Ben Z.
Thx again Dave Register To Reply 03-01-2006,10:35 PM #5 mudraker View Profile View Forum Posts Valued Forum Contributor Join Date 11-10-2003 Location Melbourne, Australia Posts 3,983 Another couple of ways use Don't panic, column A isn't gone forever, and there's more than one way to unhide it: Click column B's header cell and drag the mouse pointer to the left. Check a workbook for hidden columns If you have multiple large tables and you want to check the entire workbook for hidden columns before searching for their location, the Go To Excel Format Menu Select the cell(s) to be hidden From the Format menu, select Cells...
All contents Copyright 1998-2016 by MrExcel Consulting. Still there is one trick to help you locate hidden columns in Excel. An Explainer MacBook Pro 2016: Should You Upgrade? 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
In your case, I wonder what a 2003/2010 Excel combo is, and if you have tried all the possible approaches for a fix that were suggested in this thread. From the Format menu, select Column » Unhide The column reappears. If you freeze the panes vertically with some of the columns off the screen (in this case columns A and B), then those columns remain "frozen" off the screen and you ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: http://0.0.0.6/ Connection to 0.0.0.6 failed.
See how much you know with this short quiz. 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 This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns. If you've hidden columns in the middle of your spreadsheet, it's easy to unhide them.