Home > In Excel > Unhide Not Working In Excel 2010

Unhide Not Working In Excel 2010

Contents

There's probably a visual basic script to do this that you could code up as well. Oh well, the more methods the better. Anyone experienced this? Nothing. check over here

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 THANK YOU!!!! and then at the end out of lazyness selected the hidden columns and double clicked .. Excel: featured articles Сompare 2 columns in Excel for matches and differences Merge Excel rows without losing data Creating a drop down list: static, dynamic, from another workbook Merge 2 columns check these guys out

Can't Unhide Columns In Excel

been there, done that Happy to help https://www.youtube.com/watch?v=99647P1uI2g Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently Thanks for writing back. > > BTW...It's Excel 2003 SP1. > > "RWN" wrote: > >> Does the "UnHide" show up on the menu (or is it greyed out - protected All Rights Reserved. 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

Unfortunately I had hidden a lot of rows and the thought of having to do each one individually was unpleasant, but I came up with another solution: I saved the file It will teach you to show all hidden columns or just the ones you select. Number Date Formats - A trick to format date with "st", "nd", "rd", "th" Advanced vlookup - wildcard characters "?" and "*" 2D SUMIF with two variables – one on column How To Unhide Rows In Excel 2013 Powered by vBulletin Version 4.1.8 Copyright 2012 vBulletin Solutions, Inc.

Click OK to save the changes. How To Unhide Rows In Excel 2010 I stopped hiding because I didn't know how to get it back. Cheers 😀 LikeLike Reply Pingback: Can a row be very hidden? https://www.ablebits.com/office-addins-blog/2014/07/30/excel-unhide-columns/ 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.

SUBTOTAL wmfexcel on Facebook wmfexcel on Facebook Blogroll Bacon Bits Chandoo.org Contextures Blog Excel Campus Excel Champs ExcelTips MrExcel Forum myOnlineTraininghub Peltier Tech Blog Yodalearning Affiliate Excel Power Query Course Excel Hidden Rows Won't Unhide Cheers, LikeLike Reply Carla Cooper says: September 7, 2016 at ^.^ HOLY CATS! How do you deal with a picky eater on a backpacking trip? Still there is one trick to help you locate hidden columns in Excel.

How To Unhide Rows In Excel 2010

Glad it helps. 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 Can't Unhide Columns In Excel Select Cells > Format > Hide & Unhide > Unhide Columns. Excel Unhide Rows Doesn't Work It is so obvious.

LikeLike Reply Ashley says: September 16, 2016 at ^.^ HOLY CRAP! http://techese.net/in-excel/unhide-columns-in-excel-2010-not-working.html 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 Bookmark the permalink. ← Data ==> Subtotal How to get rid of the errormessage? → 59 Responses to When unhide row doesn'twork… [email protected] says: November 3, 2016 at ^.^ I also I tried all of the above to no avail. Unable To Unhide Columns In Excel

In my case I had filters that were preventing my hidden rows from showing up when I tried to unhide them. Thanks RWN, Jan 7, 2005 #2 Advertisements Guest Guest Yes. "Unhide" does show up, but when you selected it nothing seems to happen. LikeLike Reply MF says: September 24, 2016 at ^.^ You are welcome! this content That's why it's so puzzling to me.

How to unhide column A using the Go To and Format options Press F5 or navigate to Home -> Find & Select -> Go To.... How To Unhide Row 1 In Excel Oh well, another day, another screw-up. Thank you for this thread.

LikeLike Reply MF says: May 1, 2015 at ^.^ Hi Chris, You are welcome!

For example, you hide column A:A, then another user can enter =A1 into B1 and copy the data for all cells in B:B. In this post I'll share how to unhide and show all or some hidden columns using the standard Excel Unhide option, a custom macro, the Go To Special functionality or Document share|improve this answer answered Oct 27 '14 at 17:05 SeanC 2,78211021 add a comment| up vote 0 down vote If you select all the rows and click 'unhide' and they do Excel Rows Not Showing But Not Hidden Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

All rights reserved. Share Share this post on Digg Del.icio.us Technorati Twitter Tom Urtis Microsoft MVP - Excel Reply With Quote Feb 24th, 2004,08:26 AM #8 Barry Katcher Board Regular Join Date Feb 2002 LikeLike Reply MF says: February 18, 2015 at ^.^ You are welcome! have a peek at these guys option from the menu list.

LikeLike Reply MF says: January 7, 2016 at ^.^ You are welcome!😀 LikeLike Reply Amy says: January 4, 2016 at ^.^ OMG! Row Height was the problem (although I certainly never changed that - just hid the rows). Thanks, Andrew & Tom. However, it's not possible to copy all formulas, only their results.

About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts. Glad it helps 😀 LikeLike Reply Chris says: April 30, 2015 at ^.^ Thank you! If you're having a computer problem, ask on our forum for advice. All hidden columns and rows appear.

LikeLike Reply MF says: June 7, 2016 at ^.^ You are welcome! If your question is resolved, mark it SOLVED using the thread tools 3. Try resizing the relevant row. --- Regards, Norman "JBurke" <> wrote in message news:... > Yes. "Unhide" does show up, but when you selected it nothing seems to > happen. been there, done that Happy to help Register To Reply 02-04-2016,12:55 PM #5 AchiraSD View Profile View Forum Posts Registered User Join Date 02-04-2016 Location Colombo, Sri Lanka MS-Off Ver 2013,

NEXT: Unhide Right Columns Share this page: Advertisement Back to top Home | About Us | Contact Us | Testimonials | Donate While using this site, you agree to have read The time now is 02:06 AM. Theme by Press Customizr. LikeLike Reply Fatima says: June 7, 2016 at ^.^ Thanks, unfreezing the panes also worked for me.

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 i tried already to make it a macro with Sub UnhideAllColumns () Cells.EntireColumn.Hidden = False EndSub but it didn't work can anybody help? On the Format Cells window go to the Protection tab and unselect the Locked checkbox. LikeLike Reply Lindsey says: January 17, 2015 at ^.^ This did not work for me!

Question: How do I unhide column A in a sheet in Microsoft Excel 2010? Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 19 I can't unhide rows?This is a discussion on I can't unhide rows? Now just right-click above your table and pick the Unhide option from the menu. I was scratching my head, too, and couldn't figure out how to get the missing row back!!