You should employ Document Inspector in this case. Sign Up Now! Yes, my password is: Forgot your password? Then enter and reenter the password. navigate here
Share Share this post on Digg Del.icio.us Technorati Twitter Tom Urtis Microsoft MVP - Excel Reply With Quote Oct 9th, 2013,02:46 AM #9 DaveU New Member Join Date Aug 2011 Location On the Format Cells window go to the Protection tab and unselect the Locked checkbox. Drag your mouse pointer to the left until you see the border change its color. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. https://support.office.com/en-us/article/Unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9
Navigate to the location in your table where the columns are hidden. I was working with Excel 2007 at home and hid all columns to the right of the last column in every sheet. Thread Status: Not open for further replies. Read on to see what PCMag readers thin...
Also, the Freeze Panes option under Excel's Window menu will have changed to Unfreeze Panes. More» Readers' Choice Awards 2016: Digital Cameras and Camcorders What brand do you trust the most to capture images and video? Use a special VBA macro to unhide all columns automatically You'll find the macro below really helpful if you often get Excel worksheets with hidden columns and don't want to waste Unhide Column A In Excel 2007 I somehow lost several of the leftmost columns in a Microsoft Excel spreadsheet and have been unable to make them visible again.
This will highlight everything from A1 to the first visible cell in row 1. The time now is 05:18 AM. Now just right-click above your table and pick the Unhide option from the menu. https://support.office.com/en-us/article/Unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9 File is from another user, but it is not protected.
Click OK to save the changes. Format Menu In Excel option from the menu list. Dave Guest Hide Columns A & B and now I can't figure out how to Unhide them. PCMag Digital Group PC, PC Magazine and PC PCMag.com are among the federally registered trademarks of Ziff Davis, LLC and may not be used by third parties without explicit permission.
Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? How To Unhide Row 1 In Excel GSM Huawei Honor 5X HTC Desire 626 Huawei P8 Lite iPhone 6 vs. 6s Nokia Lumia Samsung Galaxy J3 Samsung Galaxy S7 Samsung J7 Samsung S7 Sony Xperia Tablets Back Best Unhide Column A In Excel 2016 Disable the Unhide column option Say, you hide some columns with important data like formulas or confidential information.
I was working with Excel 2007 at home and hid all columns ... check over here Required fields are marked *Comment Name * Email * Recent Posts Google Pixel: Enable or Disable Autocorrect Google Pixel: Enable Wi-Fi Hotspot Google Pixel: How to Enable USB Debugging Google Pixel: From your worksheet press Alt+F11 (careful, that's ALT + F11). Type A1 and press Enter. Can't See Column A In Excel
Dave It may also be the code itself, and it's compatiblity with 03/10...just a thought ! Andy9847 replied Nov 8, 2016 at 3:22 AM LAPTOP POWER PLUG/CONVERTER/VOLTAGE DataBase replied Nov 8, 2016 at 3:17 AM Loading... However, it's not an option if your worksheet contains numerous, like more than 20, hidden columns. his comment is here Then press Ctrl+G Paste or type in ActiveWindow.SplitColumn = 0: cells.Columns.hidden = false: ActiveSheet.ScrollArea = "" and hit the enter key.
nivrip posted Nov 7, 2016 at 3:35 PM Highlight date ranges DĂ©cioC posted Nov 7, 2016 at 10:42 AM WCG Stats Monday 07 November 2016 WCG Stats posted Nov 7, 2016 Excel Unfreeze Panes Paul Rose The first thing to check is whether you've split your spreadsheet into panes and inadvertently frozen them. Click on the small Select all icon on the intersection of row numbers and column letters to select the entire table.
Guess it's time I found out the right way to do it. The obvious doesn't seem to work. Before you share the table with your colleagues you need to make sure no one will unhide the columns. How To Unhide Multiple Rows In Excel Reply Michelle says: April 15, 2016 at 12:17 am That macro didn't work for me in 2013.
Thx all Dave Dave, Mar 1, 2006 #1 Advertisements Dave Peterson Guest Some things to try: Window|Unfreeze panes then scroll to the left (maybe they were just behind that frozen Tip:Â The default height for rows is 15, and the default width for columns is 8.43. 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. weblink Originally Posted by Tom Urtis So I assume this has been resolved, especially after another poster came forward with a Thank You.