How can you view hidden rows with a "Go To" command?

I have hidden rows in a spreadsheet and I want to review a particular row or
column by using a "Go To" without un-hiding every row.

If I use the "go to" command, it will go to the desire row; however, it will
not display the row or column for viewing.

Is this possible?

Thanks

Brandy

in Go-To, type A14 for example. Press enter. Then go to FormatRowUnhide


"Brandy" wrote in message
...
How can you view hidden rows with a "Go To" command?

I have hidden rows in a spreadsheet and I want to review a particular row
or
column by using a "Go To" without un-hiding every row.

If I use the "go to" command, it will go to the desire row; however, it
will
not display the row or column for viewing.

Is this possible?

Thanks

Brandy

Yes, that's correct; however, is there a command that will do it all in one?

So, if I go to D1, is there a command that will open the row for viewing?

Thanks

Brandy

"Gaurav" wrote:

in Go-To, type A14 for example. Press enter. Then go to FormatRowUnhide


"Brandy" wrote in message
...
How can you view hidden rows with a "Go To" command?

I have hidden rows in a spreadsheet and I want to review a particular row
or
column by using a "Go To" without un-hiding every row.

If I use the "go to" command, it will go to the desire row; however, it
will
not display the row or column for viewing.

Is this possible?

Thanks

Brandy

not that I know of...but same thing can be done using keyboard as well.

Alt+O R U

This will unhide the row you entered in Go-To.


"Brandy" wrote in message
...
Yes, that's correct; however, is there a command that will do it all in
one?

So, if I go to D1, is there a command that will open the row for viewing?

Thanks

Brandy

"Gaurav" wrote:

in Go-To, type A14 for example. Press enter. Then go to FormatRowUnhide


"Brandy" wrote in message
...
How can you view hidden rows with a "Go To" command?

I have hidden rows in a spreadsheet and I want to review a particular
row
or
column by using a "Go To" without un-hiding every row.

If I use the "go to" command, it will go to the desire row; however, it
will
not display the row or column for viewing.

Is this possible?

Thanks

Brandy

Thank you, thank you!

You are good... Excellent job

Brandy

"Gaurav" wrote:

not that I know of...but same thing can be done using keyboard as well.

Alt+O R U

This will unhide the row you entered in Go-To.


"Brandy" wrote in message
...
Yes, that's correct; however, is there a command that will do it all in
one?

So, if I go to D1, is there a command that will open the row for viewing?

Thanks

Brandy

"Gaurav" wrote:

in Go-To, type A14 for example. Press enter. Then go to FormatRowUnhide


"Brandy" wrote in message
...
How can you view hidden rows with a "Go To" command?

I have hidden rows in a spreadsheet and I want to review a particular
row
or
column by using a "Go To" without un-hiding every row.

If I use the "go to" command, it will go to the desire row; however, it
will
not display the row or column for viewing.

Is this possible?

Thanks

Brandy

Install this event sub into your workbook:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.EntireRow.Hidden Then Target.EntireRow.Hidden = False
End Sub
Post if you need help on how to install!

Regards,
Stefi

€žGaurav€� ezt Ã*rta:

not that I know of...but same thing can be done using keyboard as well.

Alt+O R U

This will unhide the row you entered in Go-To.


"Brandy" wrote in message
...
Yes, that's correct; however, is there a command that will do it all in
one?

So, if I go to D1, is there a command that will open the row for viewing?

Thanks

Brandy

"Gaurav" wrote:

in Go-To, type A14 for example. Press enter. Then go to FormatRowUnhide


"Brandy" wrote in message
...
How can you view hidden rows with a "Go To" command?

I have hidden rows in a spreadsheet and I want to review a particular
row
or
column by using a "Go To" without un-hiding every row.

If I use the "go to" command, it will go to the desire row; however, it
will
not display the row or column for viewing.

Is this possible?

Thanks

Brandy

How do you install?

I'm in MS VB

Thanks

Brandy

"Stefi" wrote:

Install this event sub into your workbook:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.EntireRow.Hidden Then Target.EntireRow.Hidden = False
End Sub
Post if you need help on how to install!

Regards,
Stefi

€žGaurav€� ezt Ã*rta:

not that I know of...but same thing can be done using keyboard as well.

Alt+O R U

This will unhide the row you entered in Go-To.


"Brandy" wrote in message
...
Yes, that's correct; however, is there a command that will do it all in
one?

So, if I go to D1, is there a command that will open the row for viewing?

Thanks

Brandy

"Gaurav" wrote:

in Go-To, type A14 for example. Press enter. Then go to FormatRowUnhide


"Brandy" wrote in message
...
How can you view hidden rows with a "Go To" command?

I have hidden rows in a spreadsheet and I want to review a particular
row
or
column by using a "Go To" without un-hiding every row.

If I use the "go to" command, it will go to the desire row; however, it
will
not display the row or column for viewing.

Is this possible?

Thanks

Brandy

Glad I could help.


"Brandy" wrote in message
...
Thank you, thank you!

You are good... Excellent job

Brandy

"Gaurav" wrote:

not that I know of...but same thing can be done using keyboard as well.

Alt+O R U

This will unhide the row you entered in Go-To.


"Brandy" wrote in message
...
Yes, that's correct; however, is there a command that will do it all in
one?

So, if I go to D1, is there a command that will open the row for
viewing?

Thanks

Brandy

"Gaurav" wrote:

in Go-To, type A14 for example. Press enter. Then go to
FormatRowUnhide


"Brandy" wrote in message
...
How can you view hidden rows with a "Go To" command?

I have hidden rows in a spreadsheet and I want to review a
particular
row
or
column by using a "Go To" without un-hiding every row.

If I use the "go to" command, it will go to the desire row; however,
it
will
not display the row or column for viewing.

Is this possible?

Thanks

Brandy

Alt+F11(VB Editor),
Right click on your worksheet name among MS Excel objects
View code
Copy and paste code in the code window
Stefi


€žBrandy€� ezt Ã*rta:

How do you install?

I'm in MS VB

Thanks

Brandy

"Stefi" wrote:

Install this event sub into your workbook:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.EntireRow.Hidden Then Target.EntireRow.Hidden = False
End Sub
Post if you need help on how to install!

Regards,
Stefi

€žGaurav€� ezt Ã*rta:

not that I know of...but same thing can be done using keyboard as well.

Alt+O R U

This will unhide the row you entered in Go-To.


"Brandy" wrote in message
...
Yes, that's correct; however, is there a command that will do it all in
one?

So, if I go to D1, is there a command that will open the row for viewing?

Thanks

Brandy

"Gaurav" wrote:

in Go-To, type A14 for example. Press enter. Then go to FormatRowUnhide


"Brandy" wrote in message
...
How can you view hidden rows with a "Go To" command?

I have hidden rows in a spreadsheet and I want to review a particular
row
or
column by using a "Go To" without un-hiding every row.

If I use the "go to" command, it will go to the desire row; however, it
will
not display the row or column for viewing.

Is this possible?

Thanks

Brandy

I did that...

Brandy

"Stefi" wrote:

Alt+F11(VB Editor),
Right click on your worksheet name among MS Excel objects
View code
Copy and paste code in the code window
Stefi


€žBrandy€� ezt Ã*rta:

How do you install?

I'm in MS VB

Thanks

Brandy

"Stefi" wrote:

Install this event sub into your workbook:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.EntireRow.Hidden Then Target.EntireRow.Hidden = False
End Sub
Post if you need help on how to install!

Regards,
Stefi

€žGaurav€� ezt Ã*rta:

not that I know of...but same thing can be done using keyboard as well.

Alt+O R U

This will unhide the row you entered in Go-To.


"Brandy" wrote in message
...
Yes, that's correct; however, is there a command that will do it all in
one?

So, if I go to D1, is there a command that will open the row for viewing?

Thanks

Brandy

"Gaurav" wrote:

in Go-To, type A14 for example. Press enter. Then go to FormatRowUnhide


"Brandy" wrote in message
...
How can you view hidden rows with a "Go To" command?

I have hidden rows in a spreadsheet and I want to review a particular
row
or
column by using a "Go To" without un-hiding every row.

If I use the "go to" command, it will go to the desire row; however, it
will
not display the row or column for viewing.

Is this possible?

Thanks

Brandy

Just as easy to right-click on the sheet tab without going to the VBE

From the worksheet.right-click and "View Code" opens the VBE

Paste in then Alt + q to return to the Excel window.



Gord Dibben MS Excel MVP


On Mon, 15 Sep 2008 06:57:01 -0700, Stefi
wrote:

Alt+F11(VB Editor),
Right click on your worksheet name among MS Excel objects
View code
Copy and paste code in the code window
Stefi


„Brandy” ezt írta:

How do you install?

I'm in MS VB

Thanks

Brandy

"Stefi" wrote:

Install this event sub into your workbook:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.EntireRow.Hidden Then Target.EntireRow.Hidden = False
End Sub
Post if you need help on how to install!

Regards,
Stefi

„Gaurav” ezt írta:

not that I know of...but same thing can be done using keyboard as well.

Alt+O R U

This will unhide the row you entered in Go-To.


"Brandy" wrote in message
...
Yes, that's correct; however, is there a command that will do it all in
one?

So, if I go to D1, is there a command that will open the row for viewing?

Thanks

Brandy

"Gaurav" wrote:

in Go-To, type A14 for example. Press enter. Then go to FormatRowUnhide


"Brandy" wrote in message
...
How can you view hidden rows with a "Go To" command?

I have hidden rows in a spreadsheet and I want to review a particular
row
or
column by using a "Go To" without un-hiding every row.

If I use the "go to" command, it will go to the desire row; however, it
will
not display the row or column for viewing.

Is this possible?

Thanks

Brandy

.... and does it do what you expected?
Stefi


€žBrandy€� ezt Ã*rta:

I did that...

Brandy

"Stefi" wrote:

Alt+F11(VB Editor),
Right click on your worksheet name among MS Excel objects
View code
Copy and paste code in the code window
Stefi


€žBrandy€� ezt Ã*rta:

How do you install?

I'm in MS VB

Thanks

Brandy

"Stefi" wrote:

Install this event sub into your workbook:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.EntireRow.Hidden Then Target.EntireRow.Hidden = False
End Sub
Post if you need help on how to install!

Regards,
Stefi

€žGaurav€� ezt Ã*rta:

not that I know of...but same thing can be done using keyboard as well.

Alt+O R U

This will unhide the row you entered in Go-To.


"Brandy" wrote in message
...
Yes, that's correct; however, is there a command that will do it all in
one?

So, if I go to D1, is there a command that will open the row for viewing?

Thanks

Brandy

"Gaurav" wrote:

in Go-To, type A14 for example. Press enter. Then go to FormatRowUnhide


"Brandy" wrote in message
...
How can you view hidden rows with a "Go To" command?

I have hidden rows in a spreadsheet and I want to review a particular
row
or
column by using a "Go To" without un-hiding every row.

If I use the "go to" command, it will go to the desire row; however, it
will
not display the row or column for viewing.

Is this possible?

Thanks

Brandy