Simple question I think.
I know how to hide single columns or rows, but how do you hide all columns or rows outside of a specified range?
Basically I just want to create a switchboard type page.
Hi,
I have attached a file containing a feature I would like to use but do not know what it is called or where to find it. By clicking a + button users can unhide rows or columns. Click the - button and users can hide those same rows or columns?
Excel Feature.xls
Thanks in Advance,
Jordan
After filling figures in a table how to hide a row/ column having 0 in a paricular column having a particular heading .. what command or program so that in every worksheet or file it can be used , to avoid it doing manually.Kindly suggest ?
Hi!
First... Is there a way to use VBA to hide the rows and column labels?
I dont want the numbers and letters to be visable to the user.
Second... does anyone know if there is a legend or someting like that over excel that gives you the correct name of things. I'm using a swedish version of excel and sometimes its hard to get the exact translations of a sertain thing or button etc. =)
Thanx!!
I have a need, using a macro, to hide selected rows and columns on a worksheet so they cannot be unhidden without using another macro. I have done this with sheets using:
Sheets("Financial Summary").Visible = xlSheetVeryHidden
Can something similar be done with rows and columns? Any ideas?
Ed
I want to hide rows by using Right Click the mouse, however, the menu doesn't show up. Please help!
Hello! I am new here. I have two macros.
1. This Macro Hides all columns whose first entry is "N" and shows all columns whose first entry is "Y".
2. The another Macro unhides all columns i.e. entire data is shown.
I need to modify these two macros to the following (or create new ones)
1. The first macro should hide all columns whose first entry is "N" and shows all columns whose first entry is Y and hides those rows which contains "NO" in this column (whose first entry is Y).
2. This macro should unhide all rows and columns i.e. entire data is shown.
I hope to get some help from experts. I will be really thankful if I get some help.
Hello! I am new here. I have two macros.
1. This Macro Hides all columns whose first entry is "N" and shows all columns whose first entry is "Y".
2. The another Macro unhides all columns i.e. entire data is shown.
I need to modify these two macros to the following (or create new ones)
1. The first macro should hide all columns whose first entry is "N" and shows all columns whose first entry is Y and hides those rows which contains "NO" in this column (whose first entry is Y).
2. This macro should unhide all rows and columns i.e. entire data is shown.
The Macro code is:
Option Explicit
Sub hideCols()
Dim cl As Range
Dim rng As Range
With Worksheets(1)
Set rng = .Range(.Cells(1, 1), .Cells(1, 1).End(xlToRight))
For Each cl In rng
If cl.Text = "N" Then cl.EntireColumn.Hidden = True
Next cl
End With
End Sub
Sub showCols()
Dim col As Long
Dim cnt As Long
cnt = Worksheets(1).UsedRange.Columns.Count
For col = 1 To cnt
If Columns(col).EntireColumn.Hidden = True Then Columns(col).EntireColumn.Hidden = False
Next
End Sub
I hope to get some help from experts. I will be really thankful if I get some help.
I'm trying to write a Macro that will hide columns based on a user input, and then rows based on what is left over.
Basically, when the workbook is opened, I want a box to pop up that says enter store number. Then the store number is typed, and OK is pressed, and it will hide all columns in the range Z:IV that do not have that store number in row 1. There will only and always be one column that will remain unhidden.
After that is done, I want to hide all rows in the range 2:2000 that have a blank or 0 value in that column that was NOT hidden in the above step. This column will be dynamic though.
IE: If you enter store "101" in, all columns right of Y will hide except column AA (just an example), which contains "101" in cell AA2. Then all rows that are blank or have a value of 0 in column AA will be hidden.
Then if you enter store "202" in, all columns right of column Y will hide except column BA this time, which contains "202" in cell BA2. Then all rows that are blank or have a value of 0 in column BA will be hidden as well.
I would like this to all happen in one macro. So when the store # is entered, everything is done and ready to view.
I know this is probably difficult, but if it makes it much easier, I guess I could deal with deleting rows and columns instead of hiding. I would much rather hide, but if deleting is the only way, it is acceptable.
Thanks in advance.
-Matt
How can I hide 1 or more columns based on a cells value
For example,
If there is an X in cell A1, column F will be hidden.
If there is an X in cell A2, column F will be visible.
If there is an X in cell A3, column G will be hidden.
If there is an X in cell A4, column G will be visible.
This could be triggered by a macro.
I am using Autofilter for rows
I am using Excel 97.
Art
Hide Rows & Columns