Once I took the filters off, BAM, my hidden rows reappeared. Frank Moore17 Dec 2015, 02:26 This was very helpful. You are right for a normal circumstance of hidden rows. I am happy to take a look at the workbook in strictest confidence so if this is something you may consider please PM and I'll forward my e-mail address p.s. http://webjak.net/in-excel/can-39-t-unhide-columns-in-excel.html
You simply click on a column to the left of the hidden columns, drag to the right of them, and then select Format | Column | Unhide. The shortcut funs can just press the Alt + ; (semicolon) hotkey. Note: A. What a simple little trick.
Glad it helps. LikeLike Reply jenlhandy says: August 25, 2016 at ^.^ OMG! unused Thank you very much!!!
You should employ Document Inspector in this case. The Go To dialog box. Good luck LikeLike Reply Jeremy Dascardus says: April 27, 2016 at ^.^ Fastest way to unhide those hidden panes? Unable To Unhide Rows In Excel More» More Stories by Ben Readers' Choice Awards 2016: HDTVs and Computer Monitors Your full-time screen companions must excel.
When posting a question, please be very clear and concise. If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface. Hero points for you! Type A1 and press Enter.
Let’s take a look at the result when I changed the row height for rows 1:16 in the screenshot below: All the hidden rows are back now! Excel Hidden Columns Won't Unhide Worked for me!! The time now is 04:33 AM. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Displaying a Hidden First Column.
If you happen to work with Excel files where some columns are hidden, you may want to know how to unhide columns in Excel. Glad it helps. Unable To Unhide Columns In Excel Hide the columns: select them -> right-click above one of the columns and pick the Hide option from the menu. How To Unhide Column A In Excel 2016 Isn’t it?
Notify me of new posts via email. news We cannot “unhide” the row as normal. Click on OK. if not, nothing will work Patrick12 Mar 2015, 11:29 DennisNothing worked until I tried your tip first. Can't See Column A In Excel
Right-click on the highlighted list and pick the Format Cells... More» Readers' Choice Awards 2016: Digital Cameras and Camcorders What brand do you trust the most to capture images and video? You saved me from a LOT of frustration🙂 LikeLike Reply MF says: January 14, 2016 at ^.^ You are welcome, Corrie. have a peek at these guys In the Reference box, type A1, and then click OK.
The hidden row wouldn't unhide, I had tried with row height, filters, unhide, unfreeze. How To Unhide Column A In Excel 2007 Excel displays the Go To dialog box. (See Figure 1.) Figure 1. Under Cell Size, click Row Height or Column Width, and then in the Row Height or Column Width box, type the value that you want to use for the row height
It never occurred to me to check the row height. LikeLike Reply Lindsey says: January 17, 2015 at ^.^ This did not work for me! Not sure what made the rows do that, but I'm glad they're back in view! Missing Columns In Excel Not Hidden Less If the first row (row 1) or column (column A) is not displayed in the worksheet, it is a little tricky to unhide it because there is no easy way
Glad it helps 😀 LikeLike Reply Chris says: April 30, 2015 at ^.^ Thank you! Thanks! Any other ideas? http://webjak.net/in-excel/excel-columns-missing-not-hidden.html I went back to my Excel sheet and there was Column A, not missing but just too small to be seen.
ExcelTips is your source for cost-effective Microsoft Excel training. LikeLike Reply MF says: September 24, 2016 at ^.^ You are welcome! 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!!