| Thread | Last Post | Replies |
|
| disable tab function on sheet tab | 19 Apr 2008 16:27 GMT | 4 |
Please help me on this question. When I right click on the sheet tab, I can rename the sheet name. How do I disable function by using VBA? Thanks a lot.
|
| Setting column widths the same on multiple worksheets | 19 Apr 2008 16:00 GMT | 2 |
I have a workbook w/ sheets of data for every month. I have adjusted column widths on my January sheet. Now I want to set all the columns on the other sheets to the same width as the corresponding columns on the January sheet. Is there some way to copy multiple column width ...
|
| Sorting | 19 Apr 2008 15:40 GMT | 2 |
Column A has the following data ABCD02052008 ABCD02062008 ABCD2062008
|
| International number formatting in Excel 2007 | 19 Apr 2008 13:40 GMT | 1 |
I am in the UK, I have been asked by a friend in France (who is a translator) how he can arrange for his French version of Excel 2007 to show numbers in the standard English nnn.nn format as against the standard French nnn,nn format to which his PC defaults. He and I are both ...
|
| Multiple lookup | 19 Apr 2008 13:20 GMT | 8 |
I have a worksheet that list all employees by employer number. I have a second worksheet whereby I would like to enter the employer number and have all the employees associated with that employer number listed. How best can I do this?
|
| Deleting Extra Page | 19 Apr 2008 11:40 GMT | 2 |
Aloha, How do I delete an extra page so it does not print?
|
| How to lock and unlock a cell using formulas in excel | 19 Apr 2008 11:33 GMT | 1 |
1. I am trying to lock & unlock a cell depending upon a change in value of the other cell. 2.Is there any way that we can desplay a user message or a error message if a condition is not meet.
|
| colour change as a result of a figure | 19 Apr 2008 09:06 GMT | 1 |
Hi. I really hope somebody can help me. I need to know how to create the following result please: if the value of the sum in a cell equals zero then make the font colour white, but if the value of the sum is greater than zero then make the font
|
| Automating Task within Excel To Send Emails | 19 Apr 2008 08:05 GMT | 4 |
We have a user who currently uses a simple spreadsheet to list certain types of enquiries they get. They would like to set up a macro, or such, to enable an automatic prompt, for example an email, to be sent to a member of staff if something hasn’t been done by a certain time to ...
|
| Lookup table color | 19 Apr 2008 06:26 GMT | 4 |
I have a very complicated formula that says, add these two cells and if it is less than zero to go to a lookup table and display the results in the the table. my question is, how can make it higlight the cell or use the color of a cell in the lookup table so i can easily tell ...
|
| Cell Formatting | 19 Apr 2008 03:05 GMT | 2 |
I am working on a spreadsheet in Excel 2007 that I did not produce. There is a DATE coumn that displays the dates in the 5 digit NUMBER format even when entered in a regular form such as 4/8/2008. I have tried reformatting the column in DATE format without any success. The ...
|
| Color numbers to use different formulas | 19 Apr 2008 02:48 GMT | 1 |
Can color font decide what formula to calculate IF statment
|
| Formula to show when the julian date changes | 19 Apr 2008 01:03 GMT | 1 |
I have a list of Julian dates and I need to know if there is a formula that I can use to count the number of instance the julian date changes.
|
| help on excel assigment! URGENT! | 19 Apr 2008 00:56 GMT | 5 |
Please contact me if you can help me get started on an assigment that i have due today!
|
| How to make formula results not show? | 19 Apr 2008 00:04 GMT | 9 |
I have a summary spreadsheet. I have two columns that require consecutive dates. (ex. 12 consecutive Mondays). These dates have to be fluid. If the first date goes in B9, then B10 thru B20 need to autopopulate. I can do this easily by putting =B9+7 in cell B10 and then dragging ...
|