Home > In Excel > Unhide Rows In Excel 2007 Not Working

Unhide Rows In Excel 2007 Not Working


Privacy Policy | Cookies | Ad Choice | Terms of Use | Mobile User Agreement A ZDNet site | Visit other CBS Interactive sites: Select SiteCBS CaresCBS FilmsCBS RadioCBS.comCBS InteractiveCBSNews.comCBSSports.comChowhoundClickerCNETCollege NetworkGameSpotLast.fmMaxPrepsMetacritic.comMoneywatchmySimonRadio.comSearch.comShopper.comShowtimeTech Guest, Nov 1, 2006, in forum: Microsoft Excel Misc Replies: 1 Views: 170 David Biddulph Nov 1, 2006 Unhide column - why doesn't click unhide column work? LikeLike Reply MF says: February 18, 2015 at ^.^ You are welcome! Coworker throwing cigarettes out of a car, I criticized it and now HR is involved Are there eighteen or twenty bars in my castle? check over here

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.

Can't Unhide Rows In Excel 2013

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. more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science Press CTRL+END to select the last cell on the worksheet or in an Excel list that contains data or formatting.

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.

Cheers, LikeLike Reply Kristan says: October 31, 2015 at ^.^ Good point! Rows Won't Unhide In Excel 2013 lol (otherwise my codes wouldn't work, as there would be no data!) I have no idea why that didn't work? Dropdown calendar in Excel Perform VLOOKUP with 2 lookup values Advanced vlookup - Text vs. About Tips.Net Contact Us Advertise with Us Our Privacy Policy Our Sites Tips.Net Beauty and Style Cars Cleaning Cooking DriveTips (Google Drive) ExcelTips (Excel 97–2003) ExcelTips (Excel 2007–2016) Gardening Health

Hidden Rows In Excel 2010 Won't Unhide

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.

This is straightforward if you are trying to unhide col B and select columns A and C to begin with.

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?