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. 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 Thank you for posting this tip. Sumit30 Dec 2014, 09:57 It worked. this contact form
Dee11 Jul 2016, 11:30 Nothing else worked until I unfreezed the rows and magically my columns that have been hiding someplace appeared again. Press Ctrl+g to open it, then paste that in and press Enter. You're really selecting three columns: the hidden column and both columns on either side of it. After selecting the hidden column and its adjacent columns, choose Column from the Format menu and The time now is 04:02 PM.
Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. How to unhide all columns in Excel Use a special VBA macro to unhide all columns automatically Unhide only the columns you select Excel - show hidden column A How to At step 4 of method 1 instead of choosing Unhide, first choose Hide, then redo the step using Unhide.
Are you looking for the solution to your computer problem? The time now is 04:02 PM. This will show only column A and will leave the other columns hidden. How To Unhide Column A In Excel 2007 To unhide the first column, select the Home tab from the toolbar at the top of the screen.
Short URL to this thread: https://techguy.org/826648 Log in with Facebook Log in with Twitter Log in with Google Your name or email address: Do you already have an account? Can't See Column A In Excel What's your favorite trick for unhiding row 1 or column A? Lori Wilhite02 Mar 2016, 09:20 I had to unfreeze panes in order to use these suggestions. One thing that bothers me slightly is that if I take a new worksheet and explictly hide column A, here I can see that the vertical line to the left of
toll_booth, May 14, 2009 #6 Sponsor This thread has been Locked and is not open to further replies. How To Unhide Column A In Excel 2016 Subscribe Get tips like this every week in ExcelTips, a free productivity newsletter. On the Home tab, in the Cells group, click Format. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
Jay03 Jun 2016, 11:47 Thank you!! these options didn't work for me -- so glad I found your website. How To Unhide First Row In Excel Then, select Unhide and Excel will expose the hidden row or column. Excel Column A Missing I can also left-click and drag to increase the width of the hidden column to make it visible again...
A helpful macro will save your time on displaying hidden columns every so often. weblink All rights reserved. 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 Helpful Links ExcelTips FAQ ExcelTips Resources Ask an Excel Question Make a Comment Free Business Forms Free Calendars Tips.Net > ExcelTips Home > Custom Views > Displaying a Hidden Excel Hidden Columns Won't Unhide
Select the adjacent columns or rows, right-click, and select Unhide from the resulting context menu. Simply click Remove All. When the Go To window appears, enter A1 in the Reference field and click on the OK button. navigate here You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Displaying a Hidden First Column.
But for some reason I can't get them back. Excel Format Menu Comments Facebook Linkedin Twitter More Email Print Reddit Delicious Digg Pinterest Stumbleupon Google Plus About Susan Harkins Susan Sales Harkins is an IT consultant, specializing in desktop solutions. J.
You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Displaying a Hidden First Column. Peggy19 Aug 2016, 21:55 Same as Dee 11 July 2016 - None of the tips worked. Instead, you can use the Name box or the Go To command to select the first row and column. his comment is here Learn an easy to remember method for unhiding row 1 and column A.
Your previously missing column A magically reappears. In this post I'll share how to unhide and show all or some hidden columns using the standard Excel Unhide option, a custom macro, the Go To Special functionality or Document Here is the FAQ for this forum. + Reply to Thread Results 1 to 8 of 8 Can't Unhide Column A & B Thread Tools Show Printable Version Subscribe to this I'm using 2010.
© Copyright 2017 sonoportal.net. All rights reserved.