I couldn't see columns A-C on a critical Excel. Steven Dale20 Jul 2016, 09:59 I would recommend you provide the actual instructions for doing this instead of the fake instructions provided above.I would love to sit in on a designers NEWS APP How to add the JofA to your iOS 9 News app This quick guide walks you through the process of adding the Journal of Accountancy as a favorite news Quick and easy.
Click on OK. 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 All rights reserved. Confidentiality aside, sometimes endless data is just a nuisance.
Today, I'll show you how to unhide row 1 and column A. A third method is even niftier, provided you have a good eye and a steady mouse pointer. Rejoicing greatly here. How To Unhide Column A In Excel 2016 If you release the mouse button when the pointer is over the gray block that marks the intersection of the row and column headers (the blank gray block just above the
Row 1 is still missing. these options didn't work for me -- so glad I found your website. When the Go To window appears, enter A1 in the Reference field and click on the OK button. Check out Professional Excel Development today!
For a version of this tip written specifically for later versions of Excel, click here: Displaying a Hidden First Row. So here is the quick possible reasons for hidden first row or first column. Unhide First Column In Excel 2007 Still if you have any problems share it in the comment section below. Excel Row 1 Missing Selecting just column B won't select column A.
Instead, you can use the Name box or the Go To command to select the first row and column. 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 Another way to display the first column is to click on the header for column B, and then drag the mouse to the left. http://webjak.net/in-excel/can-39-t-unhide-row-1-in-excel.html Willy Vanhaelen01 Jan 2015, 05:06 That can happen when you scroll off the screen column A and then freeze the first column now being column B.
Your previously missing column A magically reappears. Excel Format Menu For instance, if you hide column A, Excel will dutifully follow out your instructions. Excel displays the Go To dialog box. (See Figure 1.) Figure 1.
View the most recent issue. In the sheet below, I selected columns C and E to unhide column D. KV12 Jul 2016, 14:24 Thank you Mr.John. Can't Unhide Top Rows In Excel It worked for me as well.
For instance, if you hide rows 1 through 5, Excel will dutifully follow out your instructions. TIP: If you are unhiding rows 1-3 and the instructions above did not work. To select the first hidden row or column on the worksheet, do one of the following: In the Name Box next to the formula bar, type A1, and then press ENTER. http://webjak.net/in-excel/can-39-t-unhide-columns-in-excel.html NEXT: Insert Column Share this page: Advertisement Back to top Home | About Us | Contact Us | Testimonials | Donate While using this site, you agree to have read and
Shares this is the case for unhiding row 1.