Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ARGH! Office 2007 - Excel where is "Go To" command 15

Status
Not open for further replies.
ladyck3

ladyck3

Technical User
Jan 3, 2003
800
US
I heavily use the Edit > Go To > Visible Cells Only option in Excel 2003 and previous versions. For the very life of me, I can't find that feature in 2007.

Our office was forced to update as a company standard, this learning curve is just frustrating me to NO END!

Please help! I tried the HELP FILE but that does not seem to explain it either... they talk about "go to" but they don't tell you where the function is.

Another thing... "LISTS" I used to go to Insert > Define Name > Lists and create lists for data validation but I can't find that either....

Thanks in advance....
ladyck3

LadyCK3
aka: Laurie :)
 
Sort by date Sort by votes



L,

Wasn't it Lucy that uttered, "ARGH!" ;-)

Skip,

[glasses]Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![tongue]
 
Upvote 0 Downvote
Nope... ME... Laurie... ARGH! And not in a pirate sort of way, in a "I don't need MORE GREY HAIR" Sort of way!! Thanks to Bandenjamin for the link to the online tutorials, when I have "time" I will definately check it out.

SKIP!!! AS ALWAYS you are such a Godsend! I LOVE YOU for this link... this "reference card" is JUST what I need in a PINCH.... I realize you may not have written it (or maybe, you guru, you did) :) but I am SO THANKFUL for the link!

I immediately printed out a copy for me and one for each of my two upper management bosses because we all utilize the dog... out of Excel. They were pleased as well. So I would give you 3 stars if I could but alas I can only do one... but you really deserve a BAZILLION for this treasure....

THANK YOU!!!!!!!

LadyCK3
aka: Laurie :)
 
Upvote 0 Downvote



L,

Using 2003@work but 2007@home and NOT lovin' it!

I get so frustrated not being able to operate as usual.

ARGH! fgrup!

Skip,

[glasses]Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![tongue]
 
Upvote 0 Downvote
Hey Skip....

By any chance do you know of there are similar images for Word, Access and PPT?

Access, which I am not real fluent on...I've created databases but they are basically one big table with many forms and ASP pages created to show that data....

PPT is the effective way for us to report to HQ information because pictures speak a thousand words...

Word... well Word "is" the app used for Outlook and all communication in between :)

Thanks in advance... my new best friend!! :)


LadyCK3
aka: Laurie :)
 
Upvote 0 Downvote
LadyCk3,

Those aren't tutorials. Its like a backward compatible virtual machine. If you have a task that you want to perform in Office 2007 that you know how to do in 2003, you do pull that up, it gives you a 2003 interface then you do the task, it will then show you how to do the same thing in 2007. I pretty much keep one open almost all the time so I can quickly do old tasks. After a couple times it sinks in pretty quick :D

--Dan
Whenever you find yourself on the side of the majority, it is time to pause and reflect.
Mark Twain
 
Upvote 0 Downvote
WOW, Dan, I guess I did not give it much of a chance.... I'm out of here for the day but I can guarantee you it will get a looksee in the morning! :)

Thank you!

LadyCK3
aka: Laurie :)
 
Upvote 0 Downvote
Star for both.

VERY useful info

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Laurie,

F5 will take you to GoTo in either Excel or Word.

Member- AAAA Association Against Acronym Abusers
Only here temporarily during job transition....again....but better this time.
 
Upvote 0 Downvote


Also, in the Name Box, you can enter a range reference OR a Named Range, and it will "fly" you there in an instant.

So...

if you had a Range Name of The_Moon...

Skip,

[glasses]Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![tongue]
 
Upvote 0 Downvote
You guys, once again I want to say THANK YOU!

Dan....I found the ability to download the help files (for lack of finding the proper term) and have them on my pc so I can access ANYTIME...

I love this, I wish I could give you a bazillion stars!!!

Laurie


LadyCK3
aka: Laurie :)
 
Upvote 0 Downvote
Man! I thought I had learned all I needed to know about Excel (hence my handle) but then I got XL 2K7 - what a mash-up!!

Just about to reinstall Office 2003, and came across this thread WOW!!!

I've said it before, and I will prob'ly say it many times again - SKIP, you are truly our saviour and Guru! [bigsmile]

If ah was a girlie, ah'd surely kis you, but as ah'm a guy, yer'll hev ta settle fer another sparkly thang!

Chris

So you ride yourselves over the fields,
and you make all your animal deals,
and your wise men don't know how it feels...

Ian Anderson
 
Upvote 0 Downvote
MeGusta, I agree, Skip is a total GURU but check out the first response that I got, its really awesome... I have Skip's card hanging in my cube but find myself going to the visual comparison more often than not.... its worth stars for sure!!

Laurie


LadyCK3
aka: Laurie :)
 
Upvote 0 Downvote
We can try and arrange for his pic to hang in your cube...lol....sorrrry, couldn't help it.

Member- AAAA Association Against Acronym Abusers
Only here temporarily during job transition....again....but better this time.
 
Upvote 0 Downvote
We haven't gone to 2007 yet, but I've archived this thread to reference when we do.


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.
 
Upvote 0 Downvote




Hey, I got this from someone else, an' HIS pic is tacked to my cube!

Skip,

[glasses]Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![tongue]
 
Upvote 0 Downvote
Hey xlhelp,

Excellent point! Will you please make a copy of his pic from your cube and email it to me?

<ducking and running>

hehehehe

Boys! :)

hehehehe

LadyCK3
aka: Laurie :)
 
Upvote 0 Downvote
Skip, xlhelp.... remember one thing...

Whoever has the bigger spreadsheet does not win! Size does not matter.

Ok, we've gone too far off topic, but I could NOT resist!

LOL!

LadyCK3
aka: Laurie :)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Snirt
  • Locked
  • Question
MS-Office 2013 Excel Issue
Replies
1
Views
302
SkipVought
S
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
307
SkipVought
S
Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
393
mintjulep
M
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
906
combo
combo
C
  • Locked
  • Question
Office 2000 XL
Replies
6
Views
884
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top