If any questions left, feel free to comment on the post using the form below. It's possible to conceal some columns by using the Hide feature or by changing the column width to zero. Then press Ctrl+G Paste or type in ActiveWindow.SplitColumn = 0: cells.Columns.hidden = false: ActiveSheet.ScrollArea = "" and hit the enter key. You can scroll to make the last cell visible. this contact form
Somehow my file ended up a version (3) after I hid rows. computerman29642, May 13, 2009 #5 toll_booth Thread Starter Joined: Oct 21, 2008 Messages: 58 nreves said: ↑ or if you get the two vert lines to separate the columns, right click The first or last cell in a row or column Select a cell in the row or column, and then press CTRL+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP 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 https://support.office.com/en-IE/article/Show-or-hide-columns-and-rows-659c2cad-802e-44ee-a614-dde8443579f8
Hide one or more rows or columns Display one or more hidden rows or columns Display all hidden rows and columns at the same time Unhide the first row or column Reply Post a comment Click here to cancel reply. On the Home tab, in the Cells group, click Format.
Top of Page Unhide the first row or column of the worksheet To select the first hidden row or column on the worksheet, do one of the following: In the Name Hiding Columns For hiding the columns in specific sheet, select the columns you want to hide. Fay Bulbulia hi there, Highlight the entire page by the arrow in the corner, Next to colum A and ontop of number 1, right click and select unhide, all hidden colums Excel Column A Missing The "hidden rows or columns" in the whole workbook have been inspected and if there are any, there is a "REMOVE ALL" button next to them. 4.
Unhide only the columns you select If you have an Excel table where multiple columns are hidden and want to show only some of them, feel free to follow the steps How To Unhide Column A In Excel 2007 Learning is a series of curiosity, observation, and trials & errors. I'll try that when I get to work tonight, thanks. http://www.mrexcel.com/forum/excel-questions/446760-cant-unhide-columns-what.html Click on a small triangle in the upper-left corner of your table to select the entire worksheet.Tip.
If you freeze the panes vertically with some of the columns off the screen (in this case columns A and B), then those columns remain "frozen" off the screen and you Unhide Column A In Excel Shortcut The first or last cell on a worksheet or in a Microsoft Office Excel table Press CTRL+HOME to select the first cell on the worksheet or in an Excel list. I was seriously going crazy and thought I would have to manually unhide 200 rows. There is a ghost of a chance that it might be that the column width is 0.17 which makes the column look hidden when really it is visible and narrow.
Now navigate to the Review tab and click on the Protect Sheet icon. https://support.office.com/en-us/article/Unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9 How can we improve it? Unhide Column A In Excel 2016 To cancel a selection of cells, click any cell on the worksheet. Unhide Columns In Excel 2013 Shortcut See if the panes are split or the scroll area is limited.
You can display either again by using the Unhide command. weblink This window also lets you delete hidden data if you don't trust them. Reply michelle says: January 25, 2016 at 3:31 pm Hi! Any other feedback? Can't See Column A In Excel
Hmmmm...More often than not, an absence of followup means the original poster has found the solution. Excel Format Menu Do one of the following: Under Visibility, point to Hide & Unhide, and then click Unhide Rows or Unhide Columns. Dave It may also be the code itself, and it's compatiblity with 03/10...just a thought !
Also I tried to press Down Arrow in A1 and observed the change in Name Box. It changed from “A1” to “A16”, which means rows 2:15 are hidden. I was working with Excel 2007 at home and hid all columns ... I don't take any credits for this (just for finding maybe), credits go to the guys from extendoffice.com LikeLike Reply MF says: January 14, 2016 at ^.^ Hi Mrrrr, To my Excel Unfreeze Panes I have never had this happen before.
All of them are correct!" LikeLike Reply Mrrrr says: January 14, 2016 at ^.^ For me nothing worked. I am having the exact same problem- I created a spreadsheet with a row for each day of the year. dr Bryan - How can you selected hidden areas? his comment is here Check if you have Freeze Panes enabled, and unfreeze it.
I had the same problem and it worked when I followed your suggestion. This will open the Document Inspector window with all the available properties. This option examines your file for hidden properties and personal details. Go to Home -> Format -> Hide & Unhide -> Unhide Columns.
To stop extending the selection, press F8 again. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... If you are using a later version (Excel 2007 or later), this tip may not work for you. LikeLike Reply Arend says: March 12, 2015 at ^.^ And ofcourse remove the filter of the column, i forgot that LikeLike Reply Orkney says: March 10, 2015 at ^.^ Mark the
For example let's say rows 1 - 10 in column A were hidden. On the Home tab, in the Cells group, click Format. The hidden row wouldn't unhide, I had tried with row height, filters, unhide, unfreeze. It never occurred to me to check the row height.
© Copyright 2017 sonoportal.net. All rights reserved.