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?
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?
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.
The best and most beautiful things in the world cannot be seen or even touched - they must be felt with the heart. ~Hellen Keller
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!
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!
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.
Yum Yum Divas ~ ~ "Most recipes are not invention . . . but evolutions"
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???
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.