Is the GoTo dialog really useless?

[Jon von der Heyden]

Hmmm, I suppose I gotta agree too now that GoTo has it's uses.

I still believe that Special should be placed somewhere more obvious, maybe even on the right click menu.

Does anyone know what the deal is with XL2007? Have they sorted this out?

 

[Greg Truby]

Does anyone know what the deal is with XL2007? Have they sorted this out?
~Jon

Jon, were you repeating this question? If so, see the latter part of Bill's post on page 2 of this thread.

 

[Jon von der Heyden]

I must be blind

Thanks Greg! I really must get 2007 and start fiddling with it!

 

[Oorang]

Recent Scenario Where I Used Goto:
40000 records, 30 odd columns wide.
Looked up an account then navigated away.
5 minutes later I needed to look again. Didn't have the account number handy, did remember it was around row 25000. Used Goto.

Also Goto keeps a history of places you went to.

Also if you are a named range person goto preloads those ranges. This makes navigation of complex multi-tabbed sheets easier.

 

[Peter_SSs]

I voted "No" due to the "Special..." features as already pointed out.

However, I have often wished that on the "Special" list there was "Non Blanks" and "Hidden cells only". Do either of those appear in Excel 2007?

 

[Zack Barresse]

Re: 2007

Nope.