Can't Unhide Rows In Excel 2013
There are a couple of tricks for unhiding, but I've found most users forget them because they don't use them often enough to commit them to memory. Thank you so very much Sir David H. Yes, all of these things work on a new spreadsheet, but not in the client's. Member Login Remember Me Forgot your password? http://bookread.org/in-excel/hidden-rows-in-excel-2010-won-39-t-unhide.html
Thanks (0) By David Ringstrom Jun 26th 2015 01:11 I'm so glad that you found my article helpful. Do you have panes frozen? I'll also discuss how to re-enable an Excel keyboard shortcut that's disabled in any operating system subsequent to Windows XP. use ALT+F11 If you can't see a window labelled Immediate Window then press CTRL+G to get there.
Can't Unhide Rows In Excel 2013
Antonin Subject: Comment: The contents of this post will automatically be included in the ticket generated. Try > > resizing the relevant row. > > > > --- > > Regards, > > Norman > > -- Dave Peterson Dave Peterson, Jan 8, 2005 #6 Peo Columns ! Row 1 should now be visible.
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 Yeaahh! Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the Rows Won't Unhide In Excel 2013 Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.More info » X Sign in to your ProZ.com account...
Posts 4,055 Re: I can't unhide rows? I have to use the tool and pull it >> > down and >> > resize it. You'll have to use Design Mode to manage the properties. Please add any additional comments or explanation (optional)
There's probably a visual basic script to do this that you could code up as well. Excel Rows Not Showing But Not Hidden It's a simple task, but a problem arises when you want to unhide row 1 or column A because there's no row or column above or to the left, respectively. Sign up now! KV12 Jul 2016, 14:24 Thank you Mr.John.
- It helped me also.
- Not the answer you're looking for?
- Thanks RWN, Jan 7, 2005 #2 Advertisements Guest Guest Yes. "Unhide" does show up, but when you selected it nothing seems to happen.
- Or create a new account X ProZ.com ideas(Powered by UserVoice)ViewIdeas submitted by the communityPostYour ideas for ProZ.comVotePromote or demote ideasGet started now » Terminology Jobs & directories
- Guest, Nov 14, 2007, in forum: Microsoft Excel Misc Replies: 1 Views: 900 Jim Rech Nov 15, 2007 Loading...
- 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
Hidden Rows In Excel 2010 Won't Unhide
Posts 4,055 I can't unhide rows? Please add any additional comments or explanation (optional) Michael J.H. Can't Unhide Rows In Excel 2013 I tried Ctrl + Shift + Right Arrow - but when i left click, there's no UNHIDE option. Excel Unhide Rows Doesn't Work within the Excel Questions forums, part of the Question Forums category; Hi, Peoples.
The external form of a person is perfect in the eyes of the entire world when every feature is come up with in flawlessness or very nearly there. In that window, type (or copy) the following code, adjusting for the rows you want unhidden, and the sheetname for x=1 to 15:sheets("WorkSheetName").range("A"&x).entirerow.rowheight=17:next This sets the height of all 15 rows All contents Copyright 1998-2016 by MrExcel Consulting. have a peek here Anyone experienced this?
Yes No Sorry, something has gone wrong. How To Unhide Rows In Excel 2010 Remember to select the entire worksheet first. Please add any additional comments or explanation (optional) István Hirsch Local time: 16:37 English to Hungarian Did you select... Apr 7, 2011 the table before pressing Ctrl+Shift+9?
In our occasion you have hidden row No. 2.
Please add any additional comments or explanation (optional) István Hirsch Local time: 16:37 English to Hungarian Filter? Apr 7, 2011 Is there a blue Diagonalizability of matrix A Why is the 'You talking to me' speech from the movie 'Taxi Driver' so famous? This tip (2743) applies to Microsoft Excel 97, 2000, 2002, and 2003. Check This Out Subscribe Get tips like this every week in ExcelTips, a free productivity newsletter.
One approach is to add an ActiveX ComboBox to your worksheet, and populate the list with the numbers 5, 7, and 9. Add your answer Source Submit Cancel Report Abuse I think this question violates the Community Guidelines Chat or rant, adult content, spam, insulting other members,show more I think this question violates Learn an easy to remember method for unhiding row 1 and column A. See solution in other versions of Excel: Excel 2016 Excel 2013 Excel 2011 for Mac Excel 2010 Excel 2007 Excel 2003 Question: How do I unhide row #1 in a sheet
I wish to become your student but I am very far in Saudi Arabia. You can quickly discern that a row or column is hidden by the missing header. Unhiding is also simple. 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 The filter-unfilter code in my print macro was wacked.