Hide row

T

theillknight

To hide a column, you have three options:

1) Ctrl-0 (the number, not the letter)
2) Right-click on the column and choose 'Hide'
3) Click on any cell in the column, go to Format - Column - Hide.

For a row, it's a similar process except the hotkey is Ctrl-9
 
G

Guest

a was finda looking for a vba function
-----Original Message-----

To hide a column, you have three options:

1) Ctrl-0 (the number, not the letter)
2) Right-click on the column and choose 'Hide'
3) Click on any cell in the column, go to Format - Column - Hide.

For a row, it's a similar process except the hotkey is Ctrl-9.
--------------
theillknight's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=10991
View this thread: http://www.excelforum.com/showthread.php?threadid=270298

.
Click to expand...
 
D

Dave Peterson

rightclick on the worksheet tab that should have this behavior.
select view code and paste this into the code window:

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("D:D")) Is Nothing Then Exit Sub

If Target.Value = "" Then
'do nothing
Else
Target.EntireRow.Hidden = True
End If

End Sub
 
Top