We have a guy at work who has an excel spreadsheet with about 8 tabs, he would like Just the tabs to be different colors so when he emails it to the client, he can tell them, just be concerned with the red tabs, or yellow tabs etc.....
2006-09-21 16:05:24 · 4 answers · asked by Mikila H 1 in Computers & Internet ➔ Software
When I right click on the tab, where it says sheet 1, I get the following, Insert, Delete, rename, move or copy, select all sheets and view code.
When I selected the sheet and went to the toolbar up top and then format, went to pattern and changed the shading, it filled in the background with color, which is cool, but he wants it for just the tab itself.
BTW- thanks for answering me though. Its my first time.
2006-09-21 16:15:45 · update #1
Ahhh yes, we are plagued with the 2000 version at work.
2006-09-21 16:17:59 · update #2
This functionality has only been available since Excel 2002.
2006-09-22 01:35:21 · answer #1 · answered by O Caçador 6 · 1⤊ 0⤋
put the cursor on the tab, click the right mouse button while the cursor is on that tab, a menu pops up, the second-last item on the menu is "tab colour" , click the left mouse button on it, and a pallette of colours pops up, left click on the colour you want and click on OK, and its done ! :)
oh !!! After you've completed your spreadsheets and editing, if you're going to send it out, I'd advise you to "PROTECT" the Excel file before you send it to a client, so that they cannot alter it and then say you quoted other than what you really did quote. This advice could save your job. On the top menu bar, left click on Tools, then on the menu click on Protection and on the next menu click on the appropriate Protect item, It will give you 2 boxes to type in a password, so only you can edit it later, and your client can't mess up the info on it and claim you quoted otherwise. THIS is the way. Thanks for your best answer vote.
2006-09-21 23:38:33 · answer #2 · answered by million$gon 7 · 0⤊ 0⤋
In Excel 2003, you can right click on the tab (sheet?) and select "Tab Color". I'm not sure if this works in older versions of Excel
2006-09-21 23:09:58 · answer #3 · answered by Aldo the Apache 6 · 1⤊ 0⤋
u can do that ... right click on a tab. go to fomat. u ll find a pattern option there. change the colour ... njoy ..... n plz. if it works giv me the best answer .... bye
2006-09-21 23:08:33 · answer #4 · answered by robokid 2 · 0⤊ 0⤋