that way it will be the same size as when you hid it. Now just drag the mouse pointer to the right to expand the hidden column A. TY Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Oct 9th, 2013,12:20 AM #7 DaveU New Member Join Date Aug 2011 Location Waldeck, Sk, Canada Posts 18 On the Go To Special dialog box, select the Visible cells only radio button and click OK. navigate here
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 This option examines your file for hidden properties and personal details. Yes No Sorry, something has gone wrong. You can only upload photos smaller than 5 MB. https://support.office.com/en-us/article/Unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9
Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. Related Tips: Changing Column Width Unhiding a Single Column Countering Compressed Columns Setting the Standard Column Width Save Time and Supercharge Excel! The > obvious doesn't seem to work. This feature can appear helpful if you need to know if there are any hidden columns in Excel at all before you navigate to them.
You can select the entire worksheet, and then unhide rows or columns (Home tab, Cells group, Format button, Hide & Unhide command), but that displays all hidden rows and columns in But I simply cannot unhide these columns I've previously hidden. You can only upload files of type 3GP, 3GPP, MP4, MOV, AVI, MPG, MPEG, or RM. Unhide Column A In Excel 2007 Tip:Â The default height for rows is 15, and the default width for columns is 8.43.
Instead of being hidden, the height or width of the first row or column of a worksheet may have been set to zero. Instead, you can use the Name box or the Go To command to select the first row and column. c · 2 years ago 1 Thumbs up 0 Thumbs down Comment Add a comment Submit · just now Report Abuse thansk Had the same problem and solved it by selecting http://www.excelforum.com/showthread.php?t=517786 How to lock a column in an excel sheet??
Select the columns to the left and right of the column you want to unhide. Excel Format Menu Stay logged in Welcome to PC Review! Mike Michael Sharpe, Mar 6, 2015 #7 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? Advertisement Tech Support Guy Home Forums > Software & Hardware > Business Applications > Home Forums Forums Quick Links Search Forums Recent Posts Members Members Quick Links Notable Members Current Visitors
It is possible that they aren't really hidden, but set to some very small width value. Get More Info When posting a question, please be very clear and concise. Cannot Unhide Columns In Excel 2013 From your worksheet press Alt+F11 (careful, that's ALT + F11). Excel Column A Missing regards, Dave Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Oct 9th, 2013,03:17 AM #10 Michael M Board Regular Join Date Oct 2005 Location Western NSW Posts
Check the worksheet to see if there are any custom views defined, and if that is what you are viewing. check over here However, it's not an option if your worksheet contains numerous, like more than 20, hidden columns. Source(s): Help in Excel! Follow 8 answers 8 Report Abuse Are you sure you want to delete this answer? Can't See Column A In Excel
I tried selecting the first visible column, the whole spreadsheet, the View menu. Sign up now! Been here, done that, before but got them back somehow. his comment is here Any other feedback?
Jo has tried unhiding them to no avail, even copying the columns and pasting them into empty columns inserted at columns C and D. Excel Unfreeze Panes I'll do some more experimenting, and let you know if I come up with anything. Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Hi Tom, Sorry, I realize this is an old post, but, I just ran into exactly the same problem as Mike, the only difference is I'm using a 2003/2010 Excel combo. Show Ignored Content As Seen On Welcome to Tech Support Guy! Go to Home -> Format -> Hide & Unhide -> Unhide Columns. Can't Unhide First Column In Excel Been here, done that, before but got them back somehow.
If frozen panes are indicated then unfreeze the panes. camsr2000 replied Nov 8, 2016 at 4:15 AM AVG issues possibly connected... Discussion in 'Business Applications' started by toll_booth, May 12, 2009. weblink Reply archie says: May 29, 2015 at 11:17 pm it is in excel 2013 Reply Maria Azbel (Ablebits.com Team) says: December 17, 2015 at 2:05 pm Hello, Archie, I'm really sorry,
Flower · 9 years ago 1 Thumbs up 0 Thumbs down Comment Add a comment Submit · just now Report Abuse Are you using the Worksheet_BeforeRightClick() function in you code? No, create an account now. On the Home tab, in the Editing group, click Find & Select, and then click Go To.