Home > In Excel > Unable To Unhide Rows In Excel

Unable To Unhide Rows In Excel

Contents

When unhiding a row or column, you select the adjacent rows or columns, but there's no row above row 1 or column to the left of column A, which presents a To hide a row or column, you click the header to select the entire row or column, right-click the selection, and choose Hide from the resulting context menu. To hide multiple noncontiguous Use the same process to unhide multiple non-contiguous rows and columns as you would a single row or column, just select a larger range. In Excel 2003, choose Column or Row from the Format menu, and then select Hide. this content

Loading ExcelTips (Menu Interface) This Site Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? First, you'll want to check to make sure that the columns aren't being hidden by some macro running in the background. When unhiding a row or column, you select the adjacent rows or columns, but there's no row above row 1 or column to the left of column A, which presents a It is also possible that you aren't really looking at the workbook, but are looking at a custom view.

Unable To Unhide Rows In Excel

Release the mouse with the pointer over the Select All cell (the blank gray cell that intersects the header and row cells). He is president of Sharon Parq Associates, a computer and publishing services company. In Excel 2003, choose Column or Row from the Format menu, and then select Hide.

Powered by vBulletin« Version 4.1.8 Copyright ę 2012 vBulletin Solutions, Inc. Frank Moore17 Dec 2015, 02:26 This was very helpful. Jo has a co-worker who has adjusted a mutually used sheet so that columns A and B are not visible. ExcelTips is your source for cost-effective Microsoft Excel training.

View the most recent issue. Unable To Unhide Column A In Excel That works fine until you try to unhide column A, as there's only one adjacent column, column B. Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel General Unable to unhide columns To get replies by our experts Now, choose Column from the Format menu, and the choose Unhide.

Thanks! Check out Mastering VBA for Office 2013 today! This tip (6400) applies to Microsoft Excel 97, 2000, 2002, and 2003. Willy Vanhaelen21 Sep 2015, 05:39 @Tim,Read also the comments below, especially mine of 1st January 2015.

Unable To Unhide Column A In Excel

If the columns still can't be displayed, there are still two options left. The 2nd and 3rd options I had tried previously and you are right in that you need a steady hand with the mouse! Unable To Unhide Rows In Excel SURESH MANDADAPU23 Dec 2014, 05:40 Thanks for the tip. How To Unhide Columns In Excel 2013 Sumit30 Dec 2014, 09:57 It worked.

By Susan Harkins | in Microsoft Office, September 13, 2011, 12:51 AM PST RSS Comments Facebook Linkedin Twitter More Email Print Reddit Delicious Digg Pinterest Stumbleupon Google Plus Hiding and unhiding news There could be several things that need to be checked with the worksheet. So unhide has then no effect because it is not really hidden.The method you describe or simply apply unfreeze can "unhide" column A. For instance, there could be a macro associated with an event handler, and the macro does the hiding. (Imagine a macro that hides columns A and B whenever you move from Unhide All Columns In Excel

Confidentiality aside, sometimes endless data is just a nuisance. To hide a row or column, you click the header to select the entire row or column, right-click the selection, and choose Hide from the resulting context menu. To hide multiple noncontiguous In Excel 2003, use the Name Box to select cell A1. http://webjak.net/in-excel/can-39-t-unhide-rows-in-excel-2010.html Thank you for posting this tip.

This double-headed arrow is a bit difficult to describe; it looks most closely like the double-headed arrow that appears when you position the pointer over the dividing line between column headers. LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Quick and easy.

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,

Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Learn more about Allen... Next, click the Format dropdown in the Cells group (on the Home tab) and choose Hide & Unhide. Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc.

Another way to display the first column is to click on the header for column B, and then drag the mouse to the left. Entering "A1" in the cell reference field to jump to that cell and then go to unhide the column. In this example, column B is hidden. check my blog Worked for me :) Our Company Sharon Parq Associates, Inc.

Your cache administrator is webmaster. Unfreezing the panes off of the View tab did it. Full Bio Contact See all of Susan's content Google+ ├Ś Full Bio Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Now, column B should no longer be hidden.

Irene Lozano09 Dec 2015, 12:42 Thanks, the best instructions on how to unhide column A in 2007 version. AB12 Oct 2016, 17:19 This was a LIFE SAVER. When row 1 or column A is hidden, enter A1 in the Name Box, and press Enter. Steven Dale20 Jul 2016, 09:59 I would recommend you provide the actual instructions for doing this instead of the fake instructions provided above.I would love to sit in on a designers

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 The time now is 04:33 AM. This tip (2626) applies to Microsoft Excel 97, 2000, 2002, and 2003. Dave09 Oct 2013, 00:53 I have a workbook where certain columns are hidden/unhidden with a macro.

About Tips.Net Contact Us Advertise with Us Our Privacy Policy Our Sites Tips.Net Beauty and Style Cars Cleaning Cooking DriveTips (Google Drive) ExcelTips (Excel 97–2003) ExcelTips (Excel 2007–2016) Gardening Health Advertisement About Us Contact Us Testimonials Donate Follow us Home MS Excel Columns TechOnTheNet.com requires javascript to work properly. Related Tips: Problems with Custom Views Working With Multiple Workbooks Create Custom Apps with VBA!