Home > In Excel > Unhide First Column In Excel 2007

Unhide First Column In Excel 2007

Contents

Advertisement About Us Contact Us Testimonials Donate Follow us Home MS Excel Columns TechOnTheNet.com requires javascript to work properly. Is there any other reason why the first five rows might not be seen? View the most recent issue. The Go To dialog box. this content

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.

Unhide First Column In Excel 2007

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!

Privacy Policy | Cookies | Ad Choice | Terms of Use | Mobile User Agreement A ZDNet site | Visit other CBS Interactive sites: Select SiteCBS CaresCBS FilmsCBS RadioCBS.comCBS InteractiveCBSNews.comCBSSports.comChowhoundClickerCNETCollege NetworkGameSpotLast.fmMaxPrepsMetacritic.comMoneywatchmySimonRadio.comSearch.comShopper.comShowtimeTech Excel Hidden Columns Won't Unhide ExcelTips is your source for cost-effective Microsoft Excel training. Thanks! Unfreezing the panes off of the View tab did it.

Can't Unhide Row 1 In Excel

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.

Under the Reference tag, enter the range of the rows you want to unhide—in this case 1:2—and click on OK (see screenshot below). news Copyright © 2003-2016 TechOnTheNet.com. Advertisement About Us Contact Us Testimonials Donate Follow us Home MS Excel Rows TechOnTheNet.com requires javascript to work properly. 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 Rows Hidden In Excel And Can't Unhide

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.

Delivered Fridays Subscribe Latest From Tech Pro Research Windows spotlight: 30 tips and tricks for power users Building a practical chart of accounts: Two sample documents New user education checklist Workplace

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.