Home > In Excel > How To Unhide First Row In Excel

How To Unhide First Row In Excel

Contents

Now just right-click above your table and pick the Unhide option from the menu. Your previously missing column A magically reappears. To unhide the left-most columns of a worksheet when they are hidden, follow these steps: Choose Go To from the Edit menu, or press F5. Go Format/Column/Unhide Pedro Pedro15, May 13, 2009 #3 nreves Joined: Nov 12, 2008 Messages: 76 or if you get the two vert lines to separate the columns, right click and this content

They will work for any column you want to unhide in Excel. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Max29 Sep 2014, 04:57 Great Tip!I found thought hat using Method 3 if you hover your mouse over the left of column B as described until you get the double headed 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 http://excel.tips.net/T002626_Displaying_a_Hidden_First_Column.html

How To Unhide First Row In Excel

Thank you very much!!! It's a simple task, but a problem arises when you want to unhide row 1 or column A because there's no row or column above or to the left, respectively. Select the adjacent columns or rows, right-click, and select Unhide from the resulting context menu. Hiding a column tucks data out of sight without interfering with its function.

All contents Copyright 1998-2016 by MrExcel Consulting. Rejoicing greatly here. A third method is even niftier, provided you have a good eye and a steady mouse pointer. How To Unhide Column A In Excel 2007 You can also use one of the shortcuts: Alt + H -> O -> U -> L or Ctrl + Shift + 0 (zero on the main keyboard).

This tip lets

First, let's run through the instructions for hiding and unhiding rows and columns, just in case this task is new to you. So unhide has then no effect because it is not really hidden.The method you describe or simply apply unfreeze can "unhide" column A. is there a wayto make those colums visible. It is different, however, because instead of a black line dividing the double arrows, there are two black lines with a gap between them.

Now you know how to unhide and show hidden columns in your Excel worksheet. How To Unhide Column A In Excel 2016 Send No thanks Thank you for your feedback! × English (United States)‎ Contact Us Privacy & Cookies Terms of use & sale Trademarks Accessibility Legal © 2016 Microsoft Loading ExcelTips (Menu It should print the width underneath (? Unhide the 1st column by expanding it Click on the header for column B to select it.

  • Reply Post a comment Click here to cancel reply.
  • Share it with others Like this thread?
  • I tried selecting the first visible column, the whole spreadsheet, the View menu.
  • Denise19 Jan 2016, 04:04 Thank you for this tip - it worked with first option.
  • 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

Can't See Column A In Excel

But for some reason I can't get them back. http://www.excelforum.com/showthread.php?t=517786 If you want to display column B, select columns A and C. How To Unhide First Row In Excel Before you share the table with your colleagues you need to make sure no one will unhide the columns. Excel Column A Missing The obvious doesn't seem to work.

that way it will be the same size as when you hid it. news Please re-enable javascript in your browser settings. Full Bio Contact See all of Susan's content Google+ √ó Full Bio Susan Sales Harkins is an IT consultant, specializing in desktop solutions. If you are using a later version (Excel 2007 or later), this tip may not work for you. Excel Hidden Columns Won't Unhide

See solution in other versions of Excel: Excel 2016 Excel 2013 Excel 2011 for Mac Excel 2010 Excel 2007 Excel 2003 Before trying the following solution, you might want to make Whiteman22 Jan 2015, 14:06 Thank you for telling how to find hidden Cell A1 in Excel. Same principle as stated by Dennis. http://haywirerobotics.com/in-excel/can-39-t-unhide-columns-in-excel-2010.html Also maybe an option to see if you can copy the contents of Column A to another sheet and see what it is hidding, if succesful, why not use some VBA

Be happy and excel in Excel! 7 Responses to "How to unhide and show hidden columns in Excel" archie says: May 29, 2015 at 11:16 pm i havea pasword protected excelfile Excel Format Menu Author Bio Allen Wyatt With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. Click on OK.

The time now is 04:02 PM.

Click on the Find & Select icon and pick the Go to Special... Dee11 Jul 2016, 11:30 Nothing else worked until I unfreezed the rows and magically my columns that have been hiding someplace appeared again. I was making some code changes to a workbook when I suddenly noticed that column A had disappeared, i.e. Excel Row 1 Missing Joan06 May 2016, 12:18 Wow.

In Excel 2003, use the Name Box to select cell A1. Another way to display the first column is to click on the header for column B, and then drag the mouse to the left. Although you cannot see it, cell A1 is now selected. check my blog You can quickly discern that a row or column is hidden by the missing header. Unhiding is also simple.

Select the columns that are adjacent to the hidden column. When I hide the column the checkboxes are not hide with the cell data but keep on showing on screen.