Home > In Excel > Unhide Columns Excel 2010 Not Working

Unhide Columns Excel 2010 Not Working

Contents

I select the row before the hidden ones and choose unhide from the format menu. within the Excel Questions forums, part of the Question Forums category; Hi all, Has anyone ever run into this? Do one of the following: Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns. Unhiding a column takes a bit of specialized knowledge, but it isn't difficult. http://techese.net/in-excel/unhide-columns-in-excel-2010-not-working.html

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 Tip. Tip. To select the first hidden row or column on the worksheet, do one of the following: In the Name Box next to the formula bar, type A1, and then press ENTER.

How To Unhide Rows In Excel 2010

Hi all, Has anyone ever run into this? Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not You'll see the Go To dialog box.

With this comprehensive guide, "Mr. From now on, anyone who tries to unhide the columns in your Excel table will get the Unhide option disabled. If you leave any part of the document available for editing a smart person can create a formula in another column that will refer to your protected hidden column. Excel 2013 Unhide All Sheets A range of cells Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while you press the arrow keys to extend the

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 How To Unhide Rows In Excel 2016 Click on the Format icon -> Hide & Unhide -> Unhide columns. That works fine until you try to unhide column A, as there's only one adjacent column, column B. Press Alt+Q and see if that fixed what's ailing the sheet.

Click Hide Sheet from Hide & Unhide options. How To Unhide Multiple Rows In Excel However, if you hide Row 1 or Column A in an Excel worksheet, you might have trouble unhiding them. Simply click Remove All. Send No thanks Thank you for your feedback! × English (United Kingdom)‎ Contact Us Privacy & Cookies Terms of use & sale Trademarks Accessibility Legal © 2016 Microsoft

How To Unhide Rows In Excel 2016

Under Cell Size, click Row Height or Column Width, and then type the value that you want in the Row Height or Column Width box. A range of cells Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while you press the arrow keys to extend the How To Unhide Rows In Excel 2010 Cells to the last used cell on the worksheet (lower-right corner) Select the first cell, and then press CTRL+SHIFT+END to extend the selection of cells to the last used cell on Vba Unhide All Rows In Sheet I'ts not there on the spreadsheet when I select the are to be used.

Jul 30 How to unhide and show hidden columns in Excel by Maria Azbel Excel, Excel tips 7 Comments From this article, you'll learn how to unhide columns in Excel 2010-2013. http://techese.net/in-excel/unhide-columns-in-excel-2007-not-working.html Funny thing though, I worked on it at work and saved it with 2003, and then got home and opened it with 2007 and everything is fine. MY rows go from number 11 to number 485: I cannot unhide or otherwise make visible the rows 12 through 484. On the Home tab, in the Editing group, click Find & Select, and then click Go To. Unhide Columns In Excel 2013 Shortcut

Please re-enable javascript in your browser settings. By Susan Harkins | in Microsoft Office, March 15, 2009, 5:00 PM PST RSS Comments Facebook Linkedin Twitter More Email Print Reddit Delicious Digg Pinterest Stumbleupon Google Plus Not everything in Top of Page Display all hidden rows and columns at the same time To select all cells on a worksheet, do one of the following: Click the Select All button. this content To stop adding cells or ranges to the selection, press SHIFT+F8 again.

When posting a question, please be very clear and concise. Excel Columns Missing Not Hidden Privacy Policy | Cookies | Ad Choice | Terms of Use | Mobile User Agreement A ZDNet site | Visit other CBS Interactive sites: Select SiteCBS CaresCBS FilmsCBS RadioCBS.comCBS InteractiveCBSNews.comCBSSports.comChowhoundClickerCNETCollege NetworkGameSpotLast.fmMaxPrepsMetacritic.comMoneywatchmySimonRadio.comSearch.comShopper.comShowtimeTech Powered by Livefyre Add your Comment Editor's Picks IBM Watson: The inside story Rise of the million-dollar smartphone The world's smartest cities The undercover war on your internet secrets Free Newsletters,

Just add the macro and forget the unhide routine.

You can do the same using this short path: F5->Special -> Visible cells only. All contents Copyright 1998-2016 by MrExcel Consulting. i.e. Unhide First Column In Excel 2013 whotmewory This sucks.

If the worksheet contains data and the active cell is above or to the right of the data, pressing CTRL+A selects the current region. Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. Doing so will selecteverything to the left, including column A. have a peek at these guys Advertisement About Us Contact Us Testimonials Donate Follow us Home MS Excel Columns TechOnTheNet.com requires javascript to work properly.

The rectangular range between the active cell and the cell that you click becomes the new selection. Sign in Search Microsoft Search Products Templates Support Products Templates Support Support Apps Access Excel OneDrive OneNote Outlook PowerPoint SharePoint Skype for Business Word Install Subscription Training Admin Unhide the first Jo has a co-worker who has adjusted a mutually used sheet so that columns A and B are not visible. You cannot cancel the selection of a cell or range of cells in a nonadjacent selection without canceling the entire selection.

As soon as the search is over, you'll see the inspection results. dr Bryan - How can you selected hidden areas? For a version of this tip written specifically for later versions of Excel, click here: Unhiding Columns that are Persistently Hidden. On the Format Cells window go to the Protection tab and unselect the Locked checkbox.

How do I find and delete it. How to unhide column A using the Go To and Format options Press F5 or navigate to Home -> Find & Select -> Go To.... Reply Post a comment Click here to cancel reply. i tried already to make it a macro with Sub UnhideAllColumns () Cells.EntireColumn.Hidden = False EndSub but it didn't work can anybody help?

However, as soon as Jo deleted the now-redundant columns A and B, the information disappeared again. Hide Sheets Now select the sheet which you want to hide. The problem I had stemmed from the Freeze Panes feature/bug.