Home > In Excel > Cannot Unhide Columns In Excel 2010

Cannot Unhide Columns In Excel 2010


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

Cannot Unhide Columns In Excel 2010

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.

To find out more and change your cookie settings, please view our cookie policy. More» More Stories by Ben Readers' Choice Awards 2016: Consoles, Streaming Devices, and Services When it's time to relax, there is plenty of video to watch and games to play. All rights reserved. Excel Can't Unhide First Column Reply Sameen Javid says: December 18, 2015 at 12:35 pm I have a column having checkboxes in it in each row.

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

If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface. Excel Column A Missing Under the Reference tag, enter the range of the rows you want to unhide—in this case 1:2—and click on OK (see screenshot below). Please re-enable javascript in your browser settings. The Format Cells dialog box appears.

Excel 2013 Unhide Column Shortcut

First, ask the co-worker what is going on. http://www.journalofaccountancy.com/issues/2009/mar/unhideexcelrowsorcolumns.html This option examines your file for hidden properties and personal details. Cannot Unhide Columns In Excel 2010 By viewing our content, you are accepting the use of cookies. Excel Columns Missing Not Hidden option from the menu list.

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

Finally, select Format | Column | Unhide, and your columns are back. This will show only column A and will leave the other columns hidden. compliance and reporting Latest Stories AUDITING All articles Compilation and review Peer review Performing an audit Latest Stories MANAGEMENT ACCOUNTING All articles Financial reporting Human resources Planning and budgeting Risk management his comment is here About Tips.Net Contact Us Advertise with Us Our Privacy Policy Our Sites Tips.Net Beauty and Style Cars Cleaning Cooking DriveTips (Google Drive) ExcelTips (Excel 97–2003) ExcelTips (Excel 2007–2016) Gardening Health

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.

Jul 30 How to unhide and show hidden columns in Excel by Maria Azbel Excel, Excel tips 7 Comments From this article, you'll learn how to unhide columns in Excel 2010-2013.

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...

Share Share this post on Digg Del.icio.us Technorati Twitter Tom Urtis Microsoft MVP - Excel Reply With Quote Feb 8th, 2010,03:19 AM #3 TAPS_MikeDion Board Regular Join Date Aug 2009 Location The time now is 05:18 AM. The shortcut funs can just press the Alt + ; (semicolon) hotkey. weblink More» See More + Comments Login or Register Please enable JavaScript to view the comments powered by Disqus.

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: Connection to 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.

  • © Copyright 2017 culturahq.com. All rights reserved.