| Thread | Last Post | Replies |
|
| How do I print odd numbered pages | 28 Feb 2006 00:54 GMT | 1 |
I want to print double sided. The even numbers on one side and the odds on the other. Is there a way to do this in Excel
|
| Pivot Table Error message | 28 Feb 2006 00:26 GMT | 1 |
I have created a pivot table in an Excel workbook. When I open the work book, I can a message telling me that there are errors that Excel has repaired and to save the workbook. There is also a log file that is as follows:
|
| Button for goal seek?! | 27 Feb 2006 23:49 GMT | 6 |
Hello I have the following data: 5 6 12
|
| Worksheets | 27 Feb 2006 22:22 GMT | 3 |
I keep a workbook of weekly expenses per employee for about 5 employees. The workbook consists of a sheet for each week plus monthly total. I also keep a sperate workbook which contains on worksheet with all the months totals and the year to date. 13 column
|
| I want glitter images to insert | 27 Feb 2006 22:00 GMT | 1 |
I want to insert glitter images in my report how can I find them
|
| Button or key to conditionally change text foreground color? | 27 Feb 2006 21:40 GMT | 7 |
I would like to find some quick method (some sort of visible button or hotkey) for the user of a worksheet to change the text foreground color for certain cells in a block of cells (A1:I9) to some specific color if and only if the cell is blank. I.e. when the user hits this "red"
|
| Random number generation | 27 Feb 2006 21:35 GMT | 3 |
I've got a table of numbers - that are sequential but not consecutive Is it possible to Randomise them - I.e make them non sequential? TIA
|
| Checking for duplicates - think this is simple | 27 Feb 2006 21:32 GMT | 9 |
Hi. I'm not much an Excel guy, so I'm hoping someone can help me fairly quickly. Thanks so much in advance! I have several columns of numbers, say 10 columns of numbers with the same number of rows (again, let's keep it simple and say 10 rows -
|
| tab key jumps to next page | 27 Feb 2006 21:22 GMT | 1 |
On one workstation, I somehow have accidentally set it that when I pus the tab key, it jumps to the next page to the right instead of the nex cell to the right. Even though I don't think it would be too easy t accidentally write a macro, I have tried looking through my list o
|
| rounding issues | 27 Feb 2006 21:16 GMT | 1 |
I have a simple formula to multiple a cell with another and subtract from another:=IF(K14<0,K14,IF(K17<K16,K14-K17*K15,K14-(K17*K15))) . I also have the cell set for currency and two decimals over. The calculations are automatically rounded up to the nearest $$. how can I
|
| Wage multiplied by hours and minutes | 27 Feb 2006 20:48 GMT | 5 |
I'm trying to make 3 rows. The first is hours and minutes, the second is wage, and the third is total. I tried using one of Office XP Professional formula's, but its not exact. I think thats because its counting the time wrong, but am not sure. Any help would be apprecitated.
|
| Removing a blank cell between data | 27 Feb 2006 20:07 GMT | 1 |
I have imported data into excel and in the resulting worksheet column A contains zip codes. The zip codes are one cell above the coordinating row of data that I need to work with. How do I move the zip codes down one cell to line up with the rest of the row. My worksheet is ...
|
| Reference Books | 27 Feb 2006 19:19 GMT | 2 |
I am new user of Excel. Can anyone recommend a reference book for a new user of Excel. At this time I believe I need a "New User's" type of reference and not an all inclusive 'bible of Excel'.
|
| Adding combination of non consecutive cells | 27 Feb 2006 18:12 GMT | 3 |
Fairly new to Excel. I have learned how to sum the totals of a number of consecutive cells in a vertical column. I select the cells, stopping the selection where I want the total to appear ... then select sum from the tool bar at the top. How to sum (add) when the cells are not ...
|
| Can IF function produce a blank cell? | 27 Feb 2006 17:32 GMT | 8 |
I'm using the IF function to create a column of data which will be charted. If the IF criterion isn't satisfied, I'd like it to output a blank cell, rather than a zero or some other number, so it won't be charted. Is there any way to do this? Thanks,
|