In Excel 2003, use the Name Box to select cell A1. There are a couple of tricks for unhiding, but I've found most users forget them because they don't use them often enough to commit them to memory. TechRepublic Search GO CXO Cloud Big Data Security Innovation More Software Data Centers Networking Startups Tech & Work All Topics Sections: Photos Videos All Writers Newsletters Forums Resource Library Tech Pro However, if you have an auto filter applied this command will not work. this content
Row 1 should now be visible. If any of you fine forum dwellers could point me in the right direction, I would greatly appreciate it. Unfortunately, I am unable to attach the file as it is too large. I have also tried going through the Format - Row - Unhide option but this also doesn't work.
Ask Your Own Question Unable To Unhide A Hidden Sheet - Excel Excel Forum I have a workbook that I have unprotected (all - workbook & worksheets). No password protection detected. This time there are two rows, 781 and 812 that won't unhide.
Can anyone tell me what's going on and how I can regain the full use of my spreadsheet? In the sheet below, I selected columns C and E to unhide column D. It includes a macro that, among other things, displays a message box about the 2008 file. Excel Rows Not Showing But Not Hidden If Soccer is chosen, rows 23 to 28 would unhide.
Thanks again. Excel Hidden Rows Won't Unhide You can quickly discern that a row or column is hidden by the missing header. Unhiding is also simple. Your name or email address: Do you already have an account? What's your favorite trick for unhiding row 1 or column A?
They aren't hidden in the typical hide/unhide way and I can't figure out how to open them up. Unhide Not Working In Excel unhide tab don't work Guest, Mar 4, 2006, in forum: Microsoft Excel Misc Replies: 2 Views: 14,403 Guest Mar 6, 2006 Hidden rows automatically unhide when I open Excel Spreadsheet. current community blog chat Super User Meta Super User your communities Sign up or log in to customize your list. I discovered three rows that I cannot unhide - row 776, 790, and 807.
share|improve this answer answered Apr 7 '11 at 22:06 Joni Durden add a comment| up vote 0 down vote Also, be careful that you haven't got a frozen pane. You'll be able to ask any tech support questions, or chat with the community and help others. Can't Unhide Rows In Excel 2010 Now go to the Format menu, click on Row and Unhide, and rows 1 and 2 will appear. Can't Unhide Columns In Excel Please help with this matter if at all possible!
I don't understand the "AC2" value. news When the button is pressed again, they unhide and show. However, I have a sheet that I know is there (because I created it) but I cannot unhide. Thanks in advance. Excel Unhide Rows Doesn't Work
Sorry, my internet connection keeps going kaploooie.... How To Unhide Rows In Excel 2013 Explain it to me like I'm a physics grad: Global Warming An idiom or phrase for when you're about to be ill Does a byte contain 8 bits, or 9? Steve Ask Your Own Question Toggle Button To Hide/unhide Rows - Excel Excel Forum Using Excel 2007.
Can e-mail file if it would help. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 24th, 2004,04:23 AM #7 Tom Urtis MrExcel MVP Join Date Feb 2002 Location San Francisco, California USA Posts If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface. How To Unhide Rows In Excel 2010 However, if you have an auto filter applied this command will not work.
When unhiding a row or column, you select the adjacent rows or columns, but there's no row above row 1 or column to the left of column A, which presents a This would be a huge timesaver! TechRepublic Search GO CXO Cloud Big Data Security Innovation More Software Data Centers Networking Startups Tech & Work All Topics Sections: Photos Videos All Writers Newsletters Forums Resource Library Tech Pro check my blog If you're having a computer problem, ask on our forum for advice.