Excel Spreadsheet Discussion forum: Excel Questions - ask them here

 
Page 1 of 4 • 1 2 3 4

Views: 38, Replies: 65 » Jump to the end
Imageweeds
Jul 11, 2010 9:17 AM CST
FL. Panhandle
Not all those who wander are lost.
A thread for questions! I'll bet you already figured that out!
I started a PAGE to collect quick tips for easy reference.
Talk with people around the world.
Visit Carpe diem and seize the day!
Also, Jigsaw Puzzles, Excel forum and tutorials.
Tammy
Jul 16, 2010 8:03 AM CST
Name: Tam
NE PA
Glad I found you. I've been using excel for years for basic stuff. Now I'm trying to put together a spreadsheet to use to track what projects our engineers are working on. I have an idea of what I want to do but not how to do it.
I'd like to have the user be presented with a list of options in a pulldown menu when they click on a cell. I want to keep the list separate so its easy to maintain. Any idea where to start to find this function?

Tam
ImageGardenGuyAZ
Jul 16, 2010 8:50 AM CST
Name: Alan
Chandler, AZ; 85225
Sunset Zone 13
Tam, see the following link:

http://office.microsoft.com/en-us/excel-help/create-a-drop-d...

Alan
The best and most beautiful things in the world cannot be seen or even touched - they must be felt with the heart. ~Hellen Keller
Imageweeds
Jul 16, 2010 12:20 PM CST
FL. Panhandle
Not all those who wander are lost.
Wow, thanks Alan, I will have to play with that too. Thanks!
Talk with people around the world.
Visit Carpe diem and seize the day!
Also, Jigsaw Puzzles, Excel forum and tutorials.
ImageGardenGuyAZ
Jul 16, 2010 2:46 PM CST
Name: Alan
Chandler, AZ; 85225
Sunset Zone 13
Connie, I think ...was it you, maybe it was someone else. I think you can use that to go to the exact Tab you want to for the various companies within your many tabbed spread sheet.
The best and most beautiful things in the world cannot be seen or even touched - they must be felt with the heart. ~Hellen Keller
Imageweeds
Jul 16, 2010 2:51 PM CST
FL. Panhandle
Not all those who wander are lost.
That was someone else and we use the arrows at the bottom, right click and gives a list of sheets...see the tips section in pages...not sure that is what you are talking about. back later!
Talk with people around the world.
Visit Carpe diem and seize the day!
Also, Jigsaw Puzzles, Excel forum and tutorials.
[Last edited Jul 17, 2010 6:47 AM CST]
Quote | Post #317902 (6)
Imageweeds
Jul 17, 2010 7:04 AM CST
FL. Panhandle
Not all those who wander are lost.
I can't do the drop down box, my brain is too small.
Talk with people around the world.
Visit Carpe diem and seize the day!
Also, Jigsaw Puzzles, Excel forum and tutorials.
Tammy
Jul 19, 2010 7:21 PM CST
Name: Tam
NE PA
thanks for the link GardenGuy! I have the function I wanted working.
Tam
Imageadinamiti
Jul 22, 2010 8:46 AM CST
Name: Adina Dosan
Balotesti, Romania
Tam, great to see you here, welcome! Glad you found your answer!
Adina
Please visit us at Carpe diem cubit!
http://cubits.org/cjr/
Imageadinamiti
Jul 22, 2010 8:56 AM CST
Name: Adina Dosan
Balotesti, Romania
I just experimented a spreadsheet with colors, numbers and all. It's such fun! I have an old Excell and find it more friendly too. I only highlight the cell and click on the Backround color icon.Do you think my boss will appreciate colored cells and columns? Rolling on the floor laughing
Adina
Please visit us at Carpe diem cubit!
http://cubits.org/cjr/
ImageGardenGuyAZ
Jul 22, 2010 9:10 AM CST
Name: Alan
Chandler, AZ; 85225
Sunset Zone 13
It depends on the boss. My boss loves color coding. The key word is 'color coding" Other bosses I've had do not. Ask him! :) If your coloring it just to make it look pretty, and the colors have no significance, I'm not sure any boss likes it. At my company anyway, they know color prints are more expensive, and prefer you not have color. Especially if it is being printed out.

Alan
The best and most beautiful things in the world cannot be seen or even touched - they must be felt with the heart. ~Hellen Keller
Imagesmiley
Jul 22, 2010 10:39 AM CST
Name: Julie
Kenmore, NY
My boss likes everything on 1 page, easy to read. Blinking As much as I love him, he has ADHD.
Imageweeds
Jul 22, 2010 4:41 PM CST
FL. Panhandle
Not all those who wander are lost.
Adina, glad you are playing with excel colors...it is fun isn't it? I say, who cares if the boss likes it, just so you do! Just kidding of course.
Julie, I guess you will have to filter out just what he wants when he walks up so he only sees what he needs! One step ahead of him!
Talk with people around the world.
Visit Carpe diem and seize the day!
Also, Jigsaw Puzzles, Excel forum and tutorials.
Tammy
Jul 22, 2010 4:44 PM CST
Name: Tam
NE PA
At my last company, the executives LOVED colors. They wanted everything colored light a signal light. Green meant everything is good, Yellow meant trouble brewing and Red meant a big problem. There were guidelines to use to determine the color to use. Have fun Adina!
Imageweeds
Jul 22, 2010 4:46 PM CST
FL. Panhandle
Not all those who wander are lost.
Good point Tammy. I use colors at school for grades, YIKES. You know what red means!
Talk with people around the world.
Visit Carpe diem and seize the day!
Also, Jigsaw Puzzles, Excel forum and tutorials.
ImageGardenGuyAZ
Jul 22, 2010 4:55 PM CST
Name: Alan
Chandler, AZ; 85225
Sunset Zone 13
That is what I meant by "color coding". The colors mean something.

alan
The best and most beautiful things in the world cannot be seen or even touched - they must be felt with the heart. ~Hellen Keller
Imageweeds
Jul 22, 2010 4:57 PM CST
FL. Panhandle
Not all those who wander are lost.
Yeah Alan, but just random coloring can be oh so much fun!
Talk with people around the world.
Visit Carpe diem and seize the day!
Also, Jigsaw Puzzles, Excel forum and tutorials.
ImageTwinLakesChef
Jul 23, 2010 3:49 PM CST
Name: Arlene Marshall
Twin Lakes, IA & Orange, CA
Zone 4B
I think in color so color is good in spread sheets. All numbers make my eyes glaze over. I have to keep the 1,000 separator on number so I read them right. My brain doesn't look at 1000.00 and say, "Its one thousand dollars". I could read it as one hundred dollars.

DH, on the other hand thinks in numbers and has no color in his brain. Hilarious!
Yum Yum Divas ~ ~ "Most recipes are not invention . . . but evolutions"
Imageadinamiti
Jul 25, 2010 7:02 AM CST
Name: Adina Dosan
Balotesti, Romania
Great tips , guys! Thanks!
I saw that you can also add a picture... have you tried that one?
Adina
Please visit us at Carpe diem cubit!
http://cubits.org/cjr/
Imageweeds
Jul 25, 2010 8:18 AM CST
FL. Panhandle
Not all those who wander are lost.
Yep and make charts and lots of things. I have started back working and my time is limited but I want to do some more pages on how to do more things. This is great that you and others are learning more and sharing with all of us!
I like this, don't you???
Talk with people around the world.
Visit Carpe diem and seize the day!
Also, Jigsaw Puzzles, Excel forum and tutorials.

Page 1 of 4 • 1 2 3 4

« Back to the top
« Cubits.org homepage
« Carpe diem cubit homepage
« Excel Spreadsheet Discussion forum

You must first create a username and login before you can reply to this thread.

Carpe diem

This is a meeting place for people all over the world to discuss and share information about all areas of this ever shrinking globe. NEW!! I have added a forum for discussions about using Excel and tutorials in the PAGES section.

» Home
» Forums
» Articles
» Pages
» Links

Cubit owner: weeds

Admin team:

» Contact the admins













Want to browse around and see what other Cubits are about? Try the Cubit Finder