| Thread | Last Post | Replies |
|
| Can a cell be made to flash? | 04 Apr 2006 11:33 GMT | 2 |
Is it possible to have either the text or background in a cell flash or blink at a regular rate? Regards
|
| Macro won't delete? Any ideas? | 04 Apr 2006 11:26 GMT | 2 |
I inserted an Excel 5.0 dialog worksheet into my spreadsheet. Excel seemed to insert also a macro, which I then located (Tools -> Macro -> Macros, then deleted all the macros in the document). I also deleted the worksheet. However, since then, Excel asks me every time I open it ...
|
| Change Columnheadings | 04 Apr 2006 10:31 GMT | 2 |
Normally my columns name are letters (A, B, C....IV), but now I have got Numbers (1, 2, 3,....256). Does anyone now how I can change back to Letters. //Lasse
|
| function to retrive last entry in a column | 04 Apr 2006 08:54 GMT | 1 |
How to retrive the last entry in a series of rows in a column.
|
| Freezing Panes | 04 Apr 2006 05:25 GMT | 3 |
Explain the term Frozen Panes
|
| lost password | 04 Apr 2006 05:14 GMT | 1 |
Is there a way to override a lost password? I'm trying desparetly to remember, but it's not happening. Any help would be greatly appreciated!
|
| Average Attrition Rate | 04 Apr 2006 04:55 GMT | 1 |
Our company attrition rate calculation = Attrits / Average Headcount. I want to use the same calculation for any set of agents, whether th agents are in classroom trianing or production. The problem is tha the training group needs to back into the number of agents that need t
|
| sorting data, formula contance | 04 Apr 2006 04:46 GMT | 2 |
When I sort a group of cells by highest number to lowest one column changes the formula to match where the cell moves to. So if cell J9 moves to cell J8 in the sorting, the formula in the j column adjusts accordingly to match the new position by one. I want the formula to ...
|
| wrapping text across a number of columns | 04 Apr 2006 03:32 GMT | 8 |
I wish to wrap text across a number of columns and ensure this text is justified.
|
| Sorting by file extension in a worksheet | 04 Apr 2006 01:43 GMT | 3 |
I have an excel worksheet which has a list of file names from a directory and various stats about each file. I need to be able to sort them by the file extension. Eg.
|
| Counta | 04 Apr 2006 00:04 GMT | 2 |
I am using COUNTA to count data in a range of cells - the data in this instance is dates formatted as say Jan-06 - should work ok except that the formula is also counting cells which maybe blank but contain other formulas - what do I need to do to just return a result for the data ...
|
| Changing the Excel color palette | 04 Apr 2006 00:00 GMT | 2 |
I want to be able to set the RGB value for a fill color in a macro. The color palette does not have the soft pastels I want to use. The problem stems from the fact that changes to the color palette don't carry over if I open the worksheet on another computer. So using the ...
|
| Unhiding Information | 03 Apr 2006 23:35 GMT | 2 |
How can I retrieve hidden/deleted information?
 Signature Antoinette ------------------------------------------------------------------------
|
| Is there a way to eliminate specific cells from formulas? | 03 Apr 2006 22:01 GMT | 9 |
I am creating a table showing daily and weekly averages of Production lines. I want to create a weekly chart but I dont want the weekly totals to include the daily sum and averages. Is there a way to eliminate those cells from the weekly totals?
|
| Is it possible to add dates? | 03 Apr 2006 21:52 GMT | 7 |
Ok will try and explain with the example below..... in column A as header `Dates` in row A2 `all` (meaning all dates for that month) in row A3 15-29 (meaning from 15th to 29th of that month)
|