Reply Fred Chidester says: April 5, 2010 at 9:15 am Great idea and short cut. Reply BWright says: February 17, 2016 at 1:41 pm Thanks that has always been a pain…i appreciate your explanation being concise. Here is the FAQ for this forum. + Reply to Thread Results 1 to 6 of 6 Can't Unhide rows? The workbook and ... check over here
Your name or email address: Do you already have an account? All Rights Reserved. The sheet is not protected, and I am selecting the rows above and > below the hidden rows. > > That's why it's so puzzling to me. try by adjusting row height, rather than un-hide Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 23rd, 2004,03:50 PM #5 Barry Katcher Board Regular Join Date
Just click the sign up button to choose a username and then you can ask your own questions on the forum. The sheet is not protected, and I am selecting the rows above and below the hidden rows. Or close this Home Tax Sub-categories Personal tax Business tax HMRC & policy Tax MTD: The impact on your accounting firm and... The filter-unfilter code in my print macro was wacked.
How can we improve it? Member Login Remember Me Forgot your password? Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel Formulas & Functions [SOLVED] Can't Unhide rows? Rows Won't Unhide In Excel 2013 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
Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? Excel Unhide Rows Doesn't Work More About Us... Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... http://www.mrexcel.com/forum/excel-questions/76050-i-cant-unhide-rows.html It's just strange to me that I can't unhide it.
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 How To Unhide Rows In Excel 2010 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. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc.
Frozen Panes and unhiding rows If you try the above and it does not work, it is possible that you have frozen panes which make it look like the row is http://www.auditexcel.co.za/blog/unhide-rows-not-working-in-excel/ dmfleischer, Jul 13, 2011 #10 petruburac Joined: Nov 22, 2014 Likes Received: 0 albruce said: Try Data - Filter - ClearClick to expand... Can't Unhide Columns In Excel Norman Jones wrote: > > Hi J, > > Another thought, how did you hide the row? > > --- > Regards, > Norman > > "Norman Jones" <> wrote in Excel Hidden Rows Won't Unhide 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
Tax Tolley's Tax Hub Practice Sub-categories Practice strategy General practice Skills Practice strategySponsored 7 referral systems for generating more clients Practice strategy MTD "fall out" has already started Practice strategySponsored Don't check my blog Right click the header of the row above the hidden rows, choose Row Height and click OK. Your way is quicker and easier. Row height is very small If neither of these work, it may just be that the row heights are so small it looks like it is hidden. Excel Rows Not Showing But Not Hidden
Tax The technology revolution or evolution? Filters were set! PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Misc > Home Home Quick Links Search Forums Recent Posts Forums Forums Quick Links Search Forums Recent Posts Articles Articles Quick this content All rights reserved.
If you right click in the top left corner it highlights everything again adn you can't find the UNHIDE option. How To Unhide Rows In Excel 2013 Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 24th, 2004,04:23 AM #7 Tom Urtis MrExcel MVP Join Date Feb 2002 Location San Francisco, California USA Posts Thanks (0) By john_c_lyons 01st Jul 2007 18:45 Try this!PamFirst, is your data filtered?
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 Remember Me? Are you selecting the rows on either side of the hidden rows? -- Regards; Rob ------------------------------------------------------------------------ "JBurke" <> wrote in message news:... > A new problem in Excel - when I Unable To Unhide Columns In Excel Take Our Test Which course is best for you?
Reply Rick Rothstein (MVP - Excel) says: April 7, 2010 at 4:20 am Just so your readers are aware… even if you had not posted selection trick in this blog item, Reply Lost your columns in the abyss? « Excel Tips Monster says: April 19, 2010 at 6:00 pm […] the answer on how to un-hide rows and columns in Excel, there's Guest, Jul 18, 2005, in forum: Microsoft Excel Misc Replies: 4 Views: 242 Guest Jul 18, 2005 how do i unhide a worksheet in excel 2003? have a peek at these guys Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote May 14th, 2012,12:12 PM #10 mhc3379 New Member Join Date May 2012 Posts 1 Re: I can't unhide rows?
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 I would have pressed F5 to bring up the Go To dialog and entered A1. When I do that, the Unhide option is not greyed out and achieves what you are trying to do. Thanks again.
Similarly, to select the hidden Row 1 and the visible Row 2, they could just type 1:2 in the Name Box. Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. Then release the mouse. I stopped hiding because I didn't know how to get it back.