bookread.org

Home > In Excel > Can't Unhide Rows In Excel 2013

Can't Unhide Rows In Excel 2013

Contents

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)

Antoní­n Otáhal Local time: 16:37 Member (2005) English to Czech + ...

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.

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.

TIP: If you are unhiding rows 1-3 and the instructions above did not work. this contact form It still works for me in Excel 2003. Subject: Comment: The contents of this post will automatically be included in the ticket generated. Consulting How Advisors Can Improve Client Change Success More Resources About AccountingWEB About Sift Media Advertise on AccountingWEB Terms of use Privacy policy Contact us Got a question? Is there a way to "unhide" a specific row in Excel? Can't Unhide Columns In Excel

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 re-enable javascript in your browser settings. albury · 4 weeks ago 0 Thumbs up 0 Thumbs down Comment Add a comment Submit · just now Report Abuse Appears have a large turn in a person's life. If that doesn’t work or you just don’t want to unhide all rows, then follow the directions below. How To Unhide Rows In Excel 2013 Guest, Nov 1, 2006, in forum: Microsoft Excel Misc Replies: 1 Views: 168 David Biddulph Nov 1, 2006 Unhide column - why doesn't click unhide column work?

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.