LikeLike Reply MF says: October 21, 2016 at ^.^ You are welcome. do you have filters set? Unfreezing did the trick🙂 LikeLike Reply Ranjan Parajuli says: October 21, 2016 at ^.^ unfreezing did the trick LikeLike Corrie says: January 14, 2016 at ^.^ Thank you!! Excel 2007. check over here
The time now is 02:08 AM. muckshifter posted Nov 14, 2016 at 9:34 AM Black Friday starts today! Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? Log in or Sign up PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Misc > Why can't I unhide a hiden row Discussion in 'Microsoft Excel Misc' started by
Next right click row 66, chose unhide, and rows 1-65 will reappear. When I go back to bring in February so I can work on that, it doesn't show up in the filter, and I can't unhide those rows in any of the I have hidden rows 1-65 in an excel sheet.
We need to change the row height to have them back. The time now is 02:08 AM. Don't know why I haven't retained the info yet though! Rows Won't Unhide In Excel 2013 Reply Leave a Reply Cancel reply Your email address will not be published.
LikeLike Reply MF says: March 12, 2015 at ^.^ Hi Orkney, Thanks for your comment. Excel Unhide Rows Doesn't Work Hold down Shift, click the header of the row below the hidden rows and press F4. Regards, LikeLiked by 1 person Reply Mrrrr says: January 15, 2016 at ^.^ Was using 2010 also, but didn't test for row heights. Can you tie up these Laurent sequences?
Less You can hide a row or column by using the Hide command, but a row or column also becomes hidden when you change its row height or column width to How To Unhide Rows In Excel 2010 Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. How do I get the last lines of dust into the dustpan? Thnx a lot Bro..
Do one of the following: Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns. Thanks >> >> >> Norman Jones, Jan 8, 2005 #4 Norman Jones Guest Hi J, Another thought, how did you hide the row? --- Regards, Norman "Norman Jones" <> wrote Can't Unhide Columns In Excel The workbook and ... Excel Hidden Rows Won't Unhide The sheet is not protected, and I am selecting the rows above and > below the hidden rows. > > That's why it's so puzzling to me.
LikeLike Reply jas says: October 19, 2015 at ^.^ it worked by auto adjustments of rows and column thanks bhai LikeLike Reply Doug Holmes says: September 4, 2015 at ^.^ Thank check my blog If there are formulas to manipulate the data in your workbook and the formulas call for data from hidden rows and columns, then deleting that information will cause incorrect result. Any other ideas? Do you have panes frozen? Excel Rows Not Showing But Not Hidden
The filter-unfilter code in my print macro was wacked. Similarly, to select the hidden Row 1 and the visible Row 2, they could just type 1:2 in the Name Box. Glad it helps ! this content I have found this to be the case more than once that someone has hid the column couldn't figure out what happen to it and added another column reworked all the
Here’s the findings: For row height <=0.07, row are basically hidden where we can “unhide” the row as normal For row height from 0.08 to 0.67, row looks like hidden (We How To Unhide Rows In Excel 2013 A large range of cells Click the first cell in the range, and then hold down SHIFT while you click the last cell in the range. share|improve this answer answered Jun 25 '10 at 13:34 James O'Sullivan 1011 Nope, it doesn't work either.
We cannot “unhide” the row as normal. Susan says June 7, 2016 at 8:47 am Stuart's tip worked for unhiding rows. To stop extending the selection, press F8 again. Unable To Unhide Columns In Excel On the Home tab, in the Cells group, click Format.
This interesting behavior made me do a little test on different row heights. Glad to help! Community Sub-categories Blogs Industry updates Business advice Playing the Trump card - we all gain Business advice Playing the Trump card - we all gain AAT Bookkeepers and accountants – the http://techese.net/in-excel/unhide-rows-excel-not-working.html Related posts: No related posts.
To select the entire worksheet, you can also press CTRL+A. That is a common case that confirms user many time . Could you add a screenshot of your VBE with the problematic workbook opended in? –Jook Sep 24 '12 at 9:52 add a comment| 8 Answers 8 active oldest votes up vote More or fewer cells than the active selection Hold down SHIFT while you click the last cell that you want to include in the new selection.
In my case I had filters that were preventing my hidden rows from showing up when I tried to unhide them. On the Home tab, in the Editing group, click Find & Select, and then click Go To. Cheers, LikeLike Reply JL says: August 13, 2016 at ^.^ Once I read "It's the row height" I exclaimed "OMG column A is there".