Unable to unhide hidden columns

I have an important file that in times past I've been able to hide and
unhide rows and columns as needed.  Now, a number of worksheets will
suddenly no longer unhide.  Is there a way to force hidden columns to
be unhidden, but will not prevent them from being hidden later?
Thanks for any help.

Michael
0
8/8/2008 2:20:51 PM
excel 39879 articles. 2 followers. Follow

3 Replies
623 Views

Similar Articles

[PageSpeed] 19

If you hid them using a macro with xlveryhidden they can only be unhidden by 
code.
Else, goto the cells cell(above the 1 and to the left of the A 
titles)>format>rows>unhide
OR, row height??? set to 0
-- 
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
<MichaelRLanier@gmail.com> wrote in message 
news:829bf3a0-682a-4c6e-bece-2a81bc020b9f@k13g2000hse.googlegroups.com...
>I have an important file that in times past I've been able to hide and
> unhide rows and columns as needed.  Now, a number of worksheets will
> suddenly no longer unhide.  Is there a way to force hidden columns to
> be unhidden, but will not prevent them from being hidden later?
> Thanks for any help.
>
> Michael 

0
dguillett1 (2487)
8/8/2008 2:48:30 PM
Maybe you unhide them, but have the windows frozen so you can't scroll to see
them.

In xl2003 menus, I'd use:
window|unfreeze panes
then scroll up/to the left

(after you've unhidden the rows/columns)

MichaelRLanier@gmail.com wrote:
> 
> I have an important file that in times past I've been able to hide and
> unhide rows and columns as needed.  Now, a number of worksheets will
> suddenly no longer unhide.  Is there a way to force hidden columns to
> be unhidden, but will not prevent them from being hidden later?
> Thanks for any help.
> 
> Michael

-- 

Dave Peterson
0
petersod (12005)
8/8/2008 3:24:29 PM
If say column D is hidden because it has been made to zero width, use Go to 
and go to D1. You can then resize.
Gus

<MichaelRLanier@gmail.com> wrote in message 
news:829bf3a0-682a-4c6e-bece-2a81bc020b9f@k13g2000hse.googlegroups.com...
>I have an important file that in times past I've been able to hide and
> unhide rows and columns as needed.  Now, a number of worksheets will
> suddenly no longer unhide.  Is there a way to force hidden columns to
> be unhidden, but will not prevent them from being hidden later?
> Thanks for any help.
>
> Michael 


0
8/12/2008 9:46:52 AM
Reply:

Similar Artilces:

number of columns in a customized Form
Hi, We need some times more than 3 columns in a row on a customized form, is this possible? has any one tried this out? any hint is highly appreciated. Regards not possible in the standard forms and not heard of any solution to increase the capability. ======================= John O'Donnell Microsoft CRM MVP http://codegallery.gotdotnet.com/crm "Max.f FirstCity" <max.f@first-city.com> wrote in message news:e%23oXeStbGHA.1856@TK2MSFTNGP03.phx.gbl... > Hi, > We need some times more than 3 columns in a row on a customized form, is > this possible? has any ...

how do I display last two digits of a SSN in a separate column
I am trying to create a formula to take an existing list of 8 or 9 digit numbers and display the last two numbers in a separate column. Is this possible? Try =RIGHT(A1,2) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "katbone1" wrote: > I am trying to create a formula to take an existing list of 8 or 9 digit > numbers and display the last two numbers in a separate column. Is this > possible? Hi Use a formula =3Dright(A1, 2...

Unable to delete account
I closed my old loan account after refinancing, haven't created a new loan account yet, but my old mortgage payment is still showing up under the "Special","Debt" section on the budget main page, overstating my expense total. It is not listed on the Expenses page of the budget, and there doesn't seem to be any way to delete it from within the budget pages. I then tried to delete the closed loan account, but got an error, with a hyperlink taking me to a MS support web page that said to run the repair utility. I did, ran the standard version, checked the log...

Column Labels #6
The Lables have changed from A,B,C to 1,2,3 and I can not change them back. Any one can help please? Tools|Options|General|Uncheck R1C1 Reference style Fafa wrote: > > The Lables have changed from A,B,C to 1,2,3 and I can not change them back. > Any one can help please? -- Dave Peterson Hi, Go to Tools->Options and choose General tab. In that uncheck 'R1C1 reference style' Regards Govind. Fafa wrote: > The Lables have changed from A,B,C to 1,2,3 and I can not change them back. > Any one can help please? Thanks a lot. BR Fafa. "Dave Peterson"...

Unable to create more Windows NT accounts for Exchange mailboxes
Hi Guys, Currently our Exchange server stopped allowing the creation of more Windows NT Accounts with the following error"Insufficient System Resources exist to complete the requested service".Pls is there a way out of this? We run Exchange 5.5 SP3 on Windows NT Server. -- Buchi ...

Change formulas in a column based on a selection.
I have checkboxes from the forms toolbar in Column A linked to corresponding Cells in Column B. I have this formula in the corresponding cell in Column E =IF($B2,"Computer 1","") So when checkbox A2 is checked it displays "Computer 1" in Cell E2 I have this formula in the corresponding cell in Column F =IF($B2,I2,"") So when checkbox A2 is checked it displays the value in Cell I2. What I'd like to accomplish is to have a way to select the heading for Column I, J, K, L or M so that all the formulas in column F would change based on tha...

Add Column to a Table
Hello- How do I add a column to a table and enter in it the text "FY 2007" in every row? I basically forgot to add that field when I created the table and now I woul like to add it. Thank you. Filo Create the field with the design table interface. Make a backup. Make a new query, open it in SQL view, type something like: UPDATE yourTableNameHere SET yourNewFieldNameHere = "FY 2007" and run the query. That should do it. Hoping it may help, Vanderghast, Access MVP "Filo" <Filo@discussions.microsoft.com> wrote in message news:C8123088-0DA3-4C2D-9...

costumize item(all) form columns
hi item (all ) form is consists of 5 fixed columns (item lookup code ,item type ,Desc. ,Qty and price ) so can i replace price column with department or category etc.(like costumizable columns in outlook expres or windows explorer ) ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the...

count one column based on value in adjacent column
Does anyone know how to count the number of cells in one column based on a value in a second column? Example: Column 1 Column 2 Car Green Car Car Green Boat Green Train Green The empty cell was intentional. I would like to count the number of "Green" in Column 2 only if it coincides with "Car" in Column 1, so the result would = 2. I tried using Dcount but I couldn't get it to work. Thanks in advance for any help that you can provide. One way In say, C1: =sumproduct((a1:a100="Car")*(b...

Replace a certain Character in a column
To make a long story short, I have a lot of serial numbers (for example SWGMM036478, and I need to remove all of the "S" character automatically. Is there anyway that I can do this easily in Excel. have over 600 serial numbers and they all have the letter "S" at th beginning and they are not supposed to be there. Any tips? Thanks -- Message posted from http://www.ExcelForum.com Select the cells that contain the serial numbers. Choose Data>Text to Columns Select Fixed Width, click Next In the Data Preview window, click after the S, to add a break line. Click N...

How to sort alphabetically 2 columns?
I have never use the sorting function in Excel and would like to ask for a helping hand� light curing unit Photopolymerisationsger�t plaster model Gipsmodell separation agent Separator, Trennmittel body resin Body-Kunstharz releasing Abl�sen, herausl�sen I want to sort the left column of alphabetically. The entire line (both columns) must stay intact (side by side). Could someone please tell me how to do it? Thanks, Murgi ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroup...

Sort as "reference column"
Column A has a random sorted list of text values, column D also consists of same values but not in the way sorted as column A. What I want is to sort Column D just like Column A but with the adjacent columns to the right (Column E,F also) should sort together with column D. -- kingjeremy ------------------------------------------------------------------------ kingjeremy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26444 View this thread: http://www.excelforum.com/showthread.php?threadid=474882 Hi One way would be to use helper columns. Start by adding a ...

how do i reference multiple rows/columns with one function?
I'm trying to reference multiple columns/rows on one worksheet to summarize in another. Can I do this with one function? Can I add a row or column on the original sheet later and have it ripple through to the other page? You can do this a number of simple ways... Each sheet can have your data in a standard format (say for regions - each sheet would have that regions numbers in it) and have a summary sheet that references all of the other sheets - if they are formated the same, it is as simple as entering the = sign in the summary cell, and then selecting the cell in each sheet you wa...

Trimming an entire Column of text
Richard Scholler posted this solution on Ozgrid: Sub TrimCol() Dim r As Range Set r = Intersect(ActiveCell.EntireColumn, ActiveSheet.UsedRange) r.Value = Evaluate("IF(ROW(" & r.Address & "),IF(" & r.Address & "<>"""",TRIM(" & r.Address & "),""""))") End Sub I just get a #NUM! when I use this. Does anyone know why? This solution using Evaluate is in several places on the web. http://www.ozgrid.com/forum/showthread.php?t=77535 hi, ! > Richard Schol...

Excel link to data in other worksheet only refreshes one column
In an Excel workbook, I want to link data from one worksheet (a list of companies containing three columns of data - name, ID#, Ref#) to several other worksheets in the workbook (where various calculations will occur). I used the Import Data feature to link between worksheets. When I update data in the source worksheet (add a company name, ID#, Ref#), only the company name is updated/refreshed in the dependent worksheets. I need all three data elements from the source worksheet to be refreshed in the dependent worksheets. Anyone understand the problem and how to fix it? ...

Unable to display public folder
I have 1 user (out of 60) that is unable to display 2 (out of a bunch) of public folders. Here are some of the things I've tried: - Set him to be an owner of the folders. - Removed and reinstalled Office 2000 and applied service packs (be we all know that a lot of the settings remain after a removal!) - Logged him in at a different machine...which works fine, so I'm assuming his problem is local with 2000 and not with the exchange 2003 server? Short of wiping his entire machine a reinstalling the OS, is there something else I could try? Maybe manually removing all the setup files? ...

Smart CListCtrl column sizing
Hi, I was wondering, is there an easy way to make the column sizing of this control smarter? For example, after you insert items for the first time, it should resize a column so all items fit, unless that'd cause a scrollbar to be required. The same should happen after items are inserted. SetColumnWidth(i, LVSCW_AUTOSIZE_USEHEADER); could be used, but that'd be a bit slow because it'd iterate through all items every time. And is there a way to submit feature requests for MFC to MS? Because I'd like to see smarter behaviour not just in my app, but in all other apps (includ...

Unable to use User Defined Charts
When I try to save a user define chart, i am getting the error message: "microsoft excel cannot save the user defined chart b/c the chart gallery does not exist or is currently in use" At that point, I am prompted to save my file, which I do, and then I can see and use the user defined chart for the time being. HOWEVER, once i close out of excel and reopen it, the user defined chart is gone. Does anyone know what my options are to get this resolved? Thanks for any suggestions. As an aside, I was told (by Gord Dibben) that i need to be using XLUSRGAL.XLS and X...

How to filter rows with commom N�'s in any column
Hello, How is it posible to filter the common N� that may appear in an coloumn Examlpe: Coloumn:A B C D E F Row1: 2 6 8 10 15 20 Row2: 1 2 5 16 25 30 Row3: 4 8 12 19 45 48 Row4: 2 4 15 20 25 28 Row5: 6 9 19 29 39 49 Row6: 8 19 25 28 41 45 In this example I want to filter all the rows that have the common N�8 The filtered Result Should be shown as below: Coloumn:A B C D E F Row1: 2 6 8 10 15 20 Row3: 4 8 12 19 45 48 Row6: 8 19 25 28 41 45 Thank You Moti -- Message posted from http://www.ExcelForum.com Use an Advanced Filter with criteria: B C D E F G 8...

Combination stacked column/line chart
I think my problem lies in how I have my data plotted in my spreadsheet???? ...

unable to use interface IWMPSettings2
Hi I added two wrapper classes CWMPPlayer4 and CWMPSettings2 to wrap interfaces IWMPPlayer4 and IWMPSettings2 respectively. I have a windows media player control on my dialog box. I have added a control variable "wmp" of type CWMPPlayer4. The problem is that I can't get pointer of CWMPSettings2 . the fuction CWMPSettings2 ::get_settings is (this code is automatically generated when I add the class from activeX dll) LPDISPATCH get_settings() { LPDISPATCH result; InvokeHelper(0x5, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL); return result; } when I do CWM...

Unable to logon to CRM 1.2
Still unable to logon to CRM 1.2, I've switched developer error flag on and this is what I get Microsoft CRM Unhandled Error Details: Could not load type CrystalDecisions.Enterprise.SessionMgr from assembly CrystalDecisions.Enterprise.Framework, Version=9.2.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.TypeLoadException: Could not l...

Unable to add printers to windows server 2008 x64
I am having difficulties adding any printers to my Server 2008 SP2 box. Every time that I go to add a printer through TCP/IP port, I come up with an error saying: "Printer driver was not installed. Operation could not be completed (error 0x00000057)" I managed to get one printer running on PCL5e drivers but the test pages I'm printing have the last line of the text cut off. I have made sure that I'm by no doubt trying to install the printer with the 64 bit drivers. I've checked and double checked. this is the error E:\>winerror 0x00000057 87...

Subreport columns not showing
I have read about Microsoft's bug regarding multiple-column subreports, but have still not been able to fix my issues: I have two reports. One is a one-column report with a header, in which I want to insert a subreport - another report that I have created (that works fine when opened by itself) that creates columns of data. Settings are 5 columns 1" wide and 5" tall. Fields are in the Detail section of the report and the report boundaries are tight to the data text boxes. Currently set column setting as "Across then down", though have tried both ways. When the rep...

SOLUTION to: MAPI was unable to load the information service gwmsp1.dll
http://reviews.cnet.com/5208-6129-0.html?forumID=29&threadID=18051&messageID=407394 Hope this helps! Brad ...