Cells to the last used cell on the worksheet (lower-right corner) Select the first cell, and then press CTRL+SHIFT+END to extend the selection of cells to the last used cell on To do so, click the region to the left of "A" and above "1". Then a Document Inspector dialog box will appear, click Inspect button. 3. That would be OK unless you have other parts of the worksheet you’ve hidden and you don’t want them revealed.
and then at the end out of lazyness selected the hidden columns and double clicked .. it came right up..🙂 LikeLike Reply Designer says: November 11, 2016 at ^.^ THANK YOU! However that does work in my example… And that's why I wanna share that strange experience here to anyone with the same experience. How To Unhide Rows In Excel 2010 You are right for a normal circumstance of hidden rows.
In the Reference box, type A1, and then click OK. Hidden Rows In Excel 2010 Won't Unhide Nonadjacent rows or columns Click the column or row heading of the first row or column in your selection; then hold down CTRL while you click the column or row headings LikeLike Reply Sharlene says: May 6, 2016 at ^.^ I JUST had this exact problem. http://superuser.com/questions/401103/unhiding-rows-not-working-in-excel-2007 An entire row or column Click the row or column heading. 1.
On the Home tab, in the Cells group, click Format. have a peek at these guys Top of Page Display one or more hidden rows or columns Do one of the following: To display hidden rows, select the row above and below the rows that you want Can't Unhide Rows In Excel 2013 If you later want to unhide any of these rows, the solution isn't so obvious. Excel Unhide Rows Doesn't Work In the Reference box, type A1, and then click OK.
Guest Guest A new problem in Excel - when I hide a row, suddenly I can't use the "unhide" menu command to unhide the row. http://techese.net/in-excel/unhide-rows-excel-not-working.html dmfleischer, Jul 13, 2011 #10 petruburac Joined: Nov 22, 2014 Likes Received: 0 albruce said: Try Data - Filter - ClearClick to expand... Any other ideas? But why couldn’t I unhide them? Can't Unhide Columns In Excel
Why do Phineas and Ferb get 104 days of summer vacation? Select to receive all alerts or just ones for the topic(s) that interest you most. That works fine until you try to unhide column A, as there's only one adjacent column, column B. this content LikeLike Reply Arend says: March 12, 2015 at ^.^ And ofcourse remove the filter of the column, i forgot that LikeLike Reply Orkney says: March 10, 2015 at ^.^ Mark the
Taffycat posted Nov 14, 2016 at 9:04 AM WCG Stats Monday 14 November 2016 WCG Stats posted Nov 14, 2016 at 8:00 AM Property sheet takes forever to load John Deakin How To Unhide Rows In Excel 2013 Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Sep 27th, 2009,06:12 AM #8 Submeg New Member Join Date Sep 2009 Posts 17 Re: Unhide not working in It worked for me as well.
Resourceful. The row height say 20 but still unable to see row 1.Highlighted the spread sheet, increased the row heights. On the Home tab, under Editing, click Find & Select, and then click Go To. Excel Rows Not Showing But Not Hidden It worked for hidden rows or rows with height less than 0.08.
Email check failed, please try again Sorry, your blog cannot share posts by email. Glad it helps. Under Cell Size, click Row Height or Column Width, and then type the value that you want in the Row Height or Column Width box. have a peek at these guys Not the answer you're looking for?
Cells to the beginning of the worksheet Select the first cell, and then press CTRL+SHIFT+HOME to extend the selection of cells to the beginning of the worksheet. Excel_Freek03 Aug 2016, 10:22 It worked, thanks. Release the mouse with the pointer over the Select All cell (the blank gray cell that intersects the header and row cells). Likewise, if you want to unhide row 1, enter 1:1.
It was the "filter" put on it. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed To stop adding cells or ranges to the selection, press SHIFT+F8 again. Christina08 May 2015, 13:23 worked for me after I unfreeze panes Andy18 Apr 2015, 00:15 Worked for me after removing freeze pan Ann26 Mar 2015, 12:13 Check you haven't got the
Do n and n^3 have the same set of digits?