Home > In Excel > Unhiding Rows In Excel Not Working

Unhiding Rows In Excel Not Working

Contents

Thanks! We need to change the row height to have them back. Thanks in advance Register To Reply 06-10-2013,01:45 AM #2 FDibbins View Profile View Forum Posts Administrator Join Date 12-29-2011 Location Duncansville, PA USA MS-Off Ver Excel 2000/3/7/10/13/16 Posts 37,539 Re: Can't Maybe someone's set the row height to a very low number, which is not the same as hiding it. check over here

Here is the FAQ for this forum. + Reply to Thread Results 1 to 6 of 6 Can't Unhide rows? Cheers, LikeLike Reply JL says: August 13, 2016 at ^.^ Once I read "It's the row height" I exclaimed "OMG column A is there". Sign in Search Microsoft Search Products Templates Support Products Templates Support Support Apps Access Excel OneDrive OneNote Outlook PowerPoint SharePoint Skype for Business Word Install Subscription Training Admin Unhide the first Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search

Can't Unhide Columns In Excel

The worksheet is not password-protected. Cheers, LikeLike Reply Mira says: January 12, 2016 at ^.^ Thank you! In the example below, you need to highlight all the rows above 9.

Number Copy data from strictly-protected sheet Date Formats - A trick to format date with "st", "nd", "rd", "th" Advanced vlookup - wildcard characters "?" and "*" 2D SUMIF with two 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 Related posts: No related posts. Rows Won't Unhide In Excel 2013 About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts.

Powered by WordPress. Excel Unhide Rows Doesn't Work Going to have to keep this little nugget on file because it happens all the time with this particular person, sharing files. Nope, neither one. http://www.mrexcel.com/forum/excel-questions/76050-i-cant-unhide-rows.html U need to unlock them first.

It was the "filter" put on it. How To Unhide Rows In Excel 2010 Tip:  The default height for rows is 15, and the default width for columns is 8.43. On the Home tab, in the Cells group, click Format. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 23rd, 2004,01:35 PM #3 Andrew Poulsom MrExcel MVPModerator Join Date Jul 2002 Posts 73,092 Re: I can't unhide

Excel Unhide Rows Doesn't Work

Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. http://www.auditexcel.co.za/blog/unhide-rows-not-working-in-excel/ Click on the star if you think some-1 helped you Regards Ford Register To Reply 06-10-2013,01:49 AM #3 Aland2929 View Profile View Forum Posts Forum Contributor Join Date 06-11-2009 Location Cape Can't Unhide Columns In Excel Cancel reply Enter your comment here... Excel Hidden Rows Won't Unhide I have selected the entire worksheet and highlighted the rows.

That is a common case that confirms user many time . http://techese.net/in-excel/unhide-rows-excel-not-working.html Good luck LikeLike Reply Jeremy Dascardus says: April 27, 2016 at ^.^ Fastest way to unhide those hidden panes? Your fix worked perfectly LikeLike Reply MF says: September 4, 2015 at ^.^ Hi Doug You are welcome! LikeLike Reply Bruce Conn says: September 21, 2016 at ^.^ Found you on Google ("cannot unhide"); CTRL A entire worksheet then set all row heights at 20. …and there are the Excel Rows Not Showing But Not Hidden

The hidden row wouldn't unhide, I had tried with row height, filters, unhide, unfreeze. Thanks again! Posts 4,055 Re: I can't unhide rows? this content Dropdown calendar in Excel Perform VLOOKUP with 2 lookup values Advanced vlookup - Text vs.

I am trying to unhide rows but the Unhide command is not allowing me to? How To Unhide Rows In Excel 2013 QuasarH says: July 7, 2015 at ^.^ Precisely what I was looking for! Thank you.

I had the same problem and it worked when I followed your suggestion.

LikeLike Reply MF says: January 15, 2016 at ^.^ Hi Mrrrr, If that's the case, there are two possibilities on top of my mind: 1) Your spreadsheet is protected; 2) There In the "Cells" area, select "Format" > "Hide & Unhide" > "Unhide Columns" or "Unhide Rows" as desired.  The column or row should now be unhidden. Sorry, my internet connection keeps going kaploooie.... Unable To Unhide Columns In Excel Row Height was the problem (although I certainly never changed that - just hid the rows).

You can select the entire worksheet, and then unhide rows or columns (Home tab, Cells group, Format button, Hide & Unhide command), but that displays all hidden rows and columns in Maybe they are not hidden, maybe they were made "0" height? Glad it helps. have a peek at these guys Reply Leave a Reply Cancel reply Your email address will not be published.

The workbook and ... I am trying to avoid individually pulling out each date (I have this problem on several other spreadsheets, as well.) No one around here has been able to figure it out, Advertisements Latest Threads WCG Stats Tuesday 15 November 2016 WCG Stats posted Nov 15, 2016 at 8:00 AM Remberance Sunday bootneck02 posted Nov 14, 2016 at 11:32 PM Largest recorded data LikeLike Reply Kim says: November 11, 2016 at ^.^ Thank you, Gerry!

Any other ideas? All rights reserved. Posts 4,055 Re: I can't unhide rows? Under Cell Size, click Row Height or Column Width, and then in the Row Height or Column Width box, type the value that you want to use for the row height

We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions. LikeLike Reply MF says: October 22, 2016 at ^.^ Thank you Kim for your kind words. Follow me on Twitter or Google Plus Copyright ©2016 · Focus Pro Theme on Genesis Framework · WordPress · Log in Log in or Sign up PC Review Home Newsgroups > Glad to help!

Glad you like the tip. Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download! In my case, the top 150 rows had vanished!