U need to unlock them first. 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 Nothing. How can I get them back? http://techese.net/in-excel/unhide-in-excel-not-working.html
However that does work in my example… And that's why I wanna share that strange experience here to anyone with the same experience. Does anyone know why this may be happening? This tip (2743) applies to Microsoft Excel 97, 2000, 2002, and 2003. I've been trying to "unhide" a column for months and thought it was a lost cause, but I tried autofitting column width just now and the missing column appeared!
share|improve this answer answered Sep 20 at 12:27 user3658961 1 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up This one drove me nuts for half an hour until I realized what was going on. The time now is 02:06 AM. Try it out… "There are many ways to the number 9.
But if nothing works, here is what you have to do: Tested for Excel 2007, 2010 or Excel 2013. 1. 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 Dropdown calendar in Excel Perform VLOOKUP with 2 lookup values Copy data from strictly-protected sheet Advanced vlookup - Text vs. How To Unhide Rows In Excel 2010 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
share|improve this answer answered Sep 21 '12 at 20:40 statueuphemism 1313 add a comment| up vote 2 down vote Select the Sort & filter icon from the home menu bar, uncheck Leave your own comment: *Name: Email: Notify me about new comments ONLY FOR THIS TIP Notify me about new comments ANYWHERE ON THIS SITE Hide my email address *Text: *What Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. http://www.excelforum.com/showthread.php?t=929830 Isn’t it?
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. How To Unhide Rows In Excel 2013 Excel_Freek03 Aug 2016, 10:22 It worked, thanks. 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 You're really selecting three columns: the hidden column and both columns on either side of it. After selecting the hidden column and its adjacent columns, choose Column from the Format menu and
How can we improve it? This interesting behavior made me do a little test on different row heights. Can't Unhide Columns In Excel Sign up now! Excel Hidden Rows Won't Unhide What isn't so easy is displaying a hidden row if that row is above the first visible row in the worksheet.
I was getting very frustrated - your laziness has saved my sanity! check my blog I have to use the tool and pull it down and > > resize it. till A1 (invisible), select entire row (Ctrl+Shift+→), hold on Shift key, press ↓, till all 15 rows selected, set height and unhide row, still doesn't work! Click on OK. Excel Rows Not Showing But Not Hidden
In answer to the other question, I just hid it normally by selecting Row - Hide from the menu. "Hide" works, but "Unhide" suddendly does not. To select the first hidden row or column on the worksheet, do one of the following: In the Name Box next to the formula bar, type A1, and then press ENTER. it came right up..🙂 LikeLike Reply Designer says: November 11, 2016 at ^.^ THANK YOU! this content I had already tried, unsuccessfully, to unhide the typical way and tips from other posts.
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? Unhiding Rows In Excel Learning is a series of curiosity, observation, and trials & errors. I did test that.
unhide tab don't work Guest, Mar 4, 2006, in forum: Microsoft Excel Misc Replies: 2 Views: 14,368 Guest Mar 6, 2006 How do I unhide the first row (row 1)? So when you unhide or unfreeze rows it has no effect. This is so basic. Rows Won't Unhide In Excel 2013 In the example below, you need to highlight all the rows above 9.
Instead, you can use the Name box or the Go To command to select the first row and column. Oh well, the more methods the better. For row height >=0.68, we will see a "noticeable" row, so that we know the row is not hidden. have a peek at these guys In my case, the top 150 rows had vanished!