Excel Spreadsheet Discussion forum: Excel Questions - ask them here
Views: 37, Replies: 65 » Jump to the end |
|
|||
| 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. |
|
|||
| 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 |
|
|||
| 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 |
|
|||
| 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. |
|
|||
| 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 |
|
|||
| 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. |
|
|||
| 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. |
|
|||
| thanks for the link GardenGuy! I have the function I wanted working. Tam |
|
|||
| Tam, great to see you here, welcome! Glad you found your answer! |
|
|||
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.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 |
|
|||
My boss likes everything on 1 page, easy to read.  As much as I love him, he has ADHD. |
|
|||
| 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. |
|
|||
| 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! |
|
|||
| 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. |
|
|||
| 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 |
|
|||
| 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. |
|
|||
| 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.  |
|
|||
| Great tips , guys! Thanks! I saw that you can also add a picture... have you tried that one? |
|
|||
| 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. |
| « 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.
