How to go to a particular worksheet

[sdsurzh]

Hi,


How to go to a particular worksheet in an workbook which contains 45 worksheets.


(I know the worksheet name Any shortcut is available)


Thanks,

Suresh Kumar S

 

[Luke M]

1. Hit Ctrl-g, type name of sheet and !A1, eg

Sheet1!A1


2. Right-click on sheet scroll arrows( bottom left), select "More sheets", choose desired sheet.

 

[sdsurzh]

Thanks Luke M

 

[Luke M]

You're very welcome, thanks for the feedback!