Hide the columns: select them -> right-click above one of the columns and pick the Hide option from the menu. Yeaahh! All Rights Reserved. When I do that, the Unhide option is not greyed out and achieves what you are trying to do. check over here
Tip. Unhide only the columns you select If you have an Excel table where multiple columns are hidden and want to show only some of them, feel free to follow the steps Hello and welcome to PC Review. 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
Then enter and reenter the password. Similarly, to select the hidden Row 1 and the visible Row 2, they could just type 1:2 in the Name Box. On the Home tab, click on the Format icon Choose Hide & Unhide from the dropdown menu then select Unhide Rows. I have to use the tool and pull it down and resize it.
Now navigate to the Review tab and click on the Protect Sheet icon. Barton says March 1, 2016 at 1:12 pm Does not seem to work when columns A to E are hidden and cells F1 to H1 are merged. Thread Tools Show Printable Version Subscribe to this Thread… Rate This Thread Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode How To Unhide Rows In Excel 2010 Click on the small Select all icon on the intersection of row numbers and column letters to select the entire table.
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, Pick one of the tricks below to unhide only the first column in your table. Thanks > > > Guest, Jan 8, 2005 #3 Norman Jones Guest Hi J, I would guess that the row's height has been set to a very low size. Thanks for writing back. > > BTW...It's Excel 2003 SP1. > > "RWN" wrote: > >> Does the "UnHide" show up on the menu (or is it greyed out - protected
Still there is one trick to help you locate hidden columns in Excel. Rows Won't Unhide In Excel 2013 Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Simply click Remove All. Just add the macro and forget the unhide routine.
Register To Reply 02-04-2016,03:25 PM #6 jostan View Profile View Forum Posts Registered User Join Date 02-04-2016 Location usa MS-Off Ver 2007 Posts 1 Re: Can't Unhide rows? However, it's not possible to copy all formulas, only their results. Can't Unhide Columns In Excel I have to use the tool and pull it down and > resize it. Excel Hidden Rows Won't Unhide Any other ideas?
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. check my blog Stay logged in Welcome to PC Review! Lab colleague uses cracked software. If you're having a computer problem, ask on our forum for advice. Excel Rows Not Showing But Not Hidden
Comments Brad Dyer says June 27, 2016 at 8:39 am Stuart's tip did not work for me, however, when I selected all rows & columns, clicked on ‘View' tab, then clicked Posts 4,055 Re: I can't unhide rows? We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions. this content It helped me also.
Click on the Find & Select icon and pick the Go to Special... How To Unhide Rows In Excel 2013 Register Help Remember Me? microsoft-excel-2007 share|improve this question edited Sep 26 '12 at 0:47 Oliver Salzburg♦ 56.8k37188245 asked Jun 25 '10 at 13:13 PerlDev 101111 migrated from stackoverflow.com Sep 26 '12 at 0:38 This question
muckshifter posted Nov 14, 2016 at 9:34 AM Black Friday starts today! All rights reserved. Similar Threads Why can't I unhide rows 1 to 47 in a worksheet? Unable To Unhide Columns In Excel I need access to these rows, but when I highlight the whole area or sheet, the HIDE/UNHIDE options do not appear and therefore I cannot unhide my hidden rows.
So, unhide the rows as you describe and then hover over the row symbols on the side (in between the two rows where your rows are hidden) and then click and Pam Likes (0) Quote Replies Please login or register to join the discussion. Frozen panes are very subtle. have a peek at these guys Barry Share Share this post on Digg Del.icio.us Technorati Twitter Barry- Photo Restoration/Enhancement http://www.smiledogproductions.com click below for detour Reply With Quote Feb 24th, 2004,03:58 AM #6 Andrew Poulsom MrExcel MVPModerator Join
In the "Cells" area, select "Format" > "Hide & Unhide" > "Unhide Columns" or "Unhide Rows" as desired. The column or row should now be unhidden. Thanks (0) By john_c_lyons 01st Jul 2007 18:45 Try this!PamFirst, is your data filtered? ContexturesExcel newsby email Email: Name (optional): We respect your email privacy Archives Archives Select Month November 2016 (2) October 2016 (6) September 2016 (5) August 2016 (2) July 2016 (2) June Thank you Stuart!
On the Format Cells window go to the Protection tab and unselect the Locked checkbox. We thank you for understanding! The system returned: (22) Invalid argument The remote host or network may be down. Required fields are marked *Comment Name * Email * Recent Posts Windows 10: "This app can't open" Fix Samsung Galaxy Tab A: How to Take Screenshot Galaxy Tab A: How to
It takes just 2 minutes to sign up (and it's free!). Make sure the checkboxes Select locked cells and Select unlocked cells are ticked.