Try autofitting all columns or setting the column width for all columns to 10 if freeze panes is not the answer. In the Reference box, type A1, and then click OK. Those who prefer to keep their data unseen, can benefit from the possibility to disable the Unhide option. Hmmmm...More often than not, an absence of followup means the original poster has found the solution. have a peek at these guys
halebery just put your cursor to the row that is next to the last hidden row until your cursor changes to to horizontal and 1 vertical across and double click it..there Highlight the entire sheet (Ctrl +A) on the HOME menu the select Format Cells icon (mine is 4th from the right), select column width, set to 10 or 12. How do I hide a column in excel but dnt gv access to anyone else, meaning if u open my file I dnt want the person to click unhide and read You'll see the Go To dialog box.
When I go to unhide only one sheet appears which comes up but then I can't get back to the original sheet. Hi all, Has anyone ever run into this? It means column A is selected though you don't see it. Unhide Columns In Excel 2013 Shortcut With all the "unhide" instructions highlighting the whole page was the only way it finally worked for me.
Unhide Rows, Columns, and Sheets For revealing the hidden sheets, rows and columns, click Format, and from Hide & Unhide options, click the respective option available in the menu. Cannot Unhide Column A In Excel 2013 Hide Sheets Now select the sheet which you want to hide. Now you should be able to see column A in your Excel spreadsheet. Grab a special macro to unhide all columns in Excel automatically each time you open a worksheet and find out how to protect the hidden columns from being displayed.
This tip (6400) applies to Microsoft Excel 97, 2000, 2002, and 2003. How To Unhide Column A In Excel 2007 I have a workbook that runs a macro to hide/unhide selected columns, then saves & closes the workbook. Select the columns to the left and right of the column you want to unhide. Hide the columns: select them -> right-click above one of the columns and pick the Hide option from the menu.
However, they are visible on print preview and they do print out. 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 Unhide Column A In Excel 2016 Suffice to say... Can't Unhide Rows In Excel 2013 Been here, done that, before but got them > back somehow.
For example, you hide column A:A, then another user can enter =A1 into B1 and copy the data for all cells in B:B. More about the author Click on one of the highlighted columns and select the Format Cells... Right-click on the highlighted list and pick the Format Cells... A helpful macro will save your time on displaying hidden columns every so often. How To Unhide Rows In Excel 2010
First, ask the co-worker what is going on. Tip. 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 http://webjak.net/in-excel/can-39-t-unhide-row-1-in-excel.html This will open the Document Inspector window with all the available properties.
The rows 2,3,5 and 7 numbers are now hidden. Excel Columns Missing Not Hidden 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 Then press Ctrl+G Paste or type in ActiveWindow.SplitColumn = 0: cells.Columns.hidden = false: ActiveSheet.ScrollArea = "" and hit the enter key.
All rights reserved. KarinJ That's the only way it worked for me! We use advertisements to support this website and fund the development of new content. Can't See Column A In Excel Now navigate to the Review tab and click on the Protect Sheet icon.
I have been able to unhide these many times in the past, but I cannot do it in this current file. 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, Select the Inspect Document option. Remember Me?
In this post I'll share how to unhide and show all or some hidden columns using the standard Excel Unhide option, a custom macro, the Go To Special functionality or Document I select the reow before the hiddens ones AND the row after the hidden ones. Name E-mail (not published) Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. 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
Copyright © 2003-2016 TechOnTheNet.com. madhu it is too good and looks very effective to present managers BeatifulMind If you filter on any column, the hidden rows become unhidden automatically. Make sure the Hidden Rows and Columns option is checked. The problem I had stemmed from the Freeze Panes feature/bug.
Although you cannot see it, cell A1 is now selected. Reply Maria Azbel (Ablebits.com Team) says: December 28, 2015 at 12:37 pm Hello, Sameen, Please have a look at this page: http://stackoverflow.com/questions/18137495/hide-checkboxes-when-hiding-rows Hope it helps. So I assume this has been resolved, especially after another poster came forward with a Thank You. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
I select unhide from the format menu. Leave your own comment: *Name: Email: Notify me about new comments ONLY FOR THIS TIP Notify me about new comments ANYWHERE ON THIS SITE Hide my email address *Text: *What within the Excel Questions forums, part of the Question Forums category; Hi all, Has anyone ever run into this? Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search
Thx again Dave Register To Reply 03-01-2006,10:35 PM #5 mudraker View Profile View Forum Posts Valued Forum Contributor Join Date 11-10-2003 Location Melbourne, Australia Posts 3,983 Another couple of ways use It will works for all hidden columns.