| Thread | Last Post | Replies |
|
| Office Service Pack 3 - No CD ROM | 09 Jan 2006 15:30 GMT | 1 |
My CD ROM does not work on my computer and I'm probably not going to get it fixed (will be getting a new computer later). Office Service Pack 3 automatically started and it asked for the Microsoft CD, which won't work on the computer. I had to cancel it.
|
| how do i copy a formula when cell references r not together | 09 Jan 2006 15:25 GMT | 1 |
in cell reference H5 i have a formula H4*H3, I have copied this formula through to DG5. In cell reference H7 I have a formula H6*H3 which i have also copied through to DG7.I have formulas right down to cell reference H299 (H298*H3) Is there a quick way to repeat the copy bearing ...
|
| Average data/reduction | 09 Jan 2006 15:19 GMT | 2 |
I have a number of worksheets where each contains two rows of data representing wind speed and direction recorded every 10sec (8636 records per day). I would like to average every 60 records so that each record on a new worksheet (or rows)represents the average wind speed and ...
|
| xlb default | 09 Jan 2006 14:51 GMT | 1 |
Is there a way to change the default for the Tools|options|view|Pag breaks to have the page breaks show on all sheets on all workbooks? have tried changing a xlt workbook buy going into every sheet an checking the box to show the page breaks and saving it. When I open
|
| How do I add grid lines to a LONG list with 3 columns? | 09 Jan 2006 13:33 GMT | 5 |
I am trying to switch from my old PC that used works to this new Hewlett-Packard that uses Excel. When I downloaded my file of this use list of library books (Column 1 = Author's last name, Column 2 = authors 1st name, Column 3 = Book title), it didn't include the grid lines to ...
|
| More than 6 conditional Formats....VBA Coding Advise please | 09 Jan 2006 12:38 GMT | 8 |
If I have a range of cells A1:M20 Column K has a validation list with 6 Options....Yes, No, W, X, Y, Z The conditional formatting is limited to 3 conditions. Can anyone provide code that would permit the colour of the cells in each
|
| Can I combine "if" and "and" formulas? | 09 Jan 2006 11:17 GMT | 7 |
I have information in the following cells: A1 = customer name B1 = product type (software, services, training, support, etc.) C1 = sale price
|
| Link sums from worksheet to worksheet | 09 Jan 2006 10:58 GMT | 3 |
Is there a way to link cells and/or calcs from one worksheet to another worksheet within the same file? If so, then how? Thanks much.
|
| Multiple Cell Function | 09 Jan 2006 10:18 GMT | 2 |
I'm hoping that what I'm about to say is going to make sense! What I want is a 'table' where once one field is a column is filled in manually, all remaining fields are automatically populated. Take a look at the following table for an example of what I am trying
|
| is it excel (microsoft)mistake about time calculating? | 09 Jan 2006 09:49 GMT | 1 |
i ve list of time like that 18:20 , 18:40, 19:00 changing every 20 minutes. theese are column heads. and now i want to call these datas under time columns compare with same time another sheet. it works with all other times except 21:00, 03:00, 06:00.
|
| help witha formula | 09 Jan 2006 09:42 GMT | 3 |
I need a little help with a formula, I manage a night crew and need to total their hours when they start at night and finish in the mornings. In other words a worker starts at 7.00 pm or 11pm and might finish at different times say at 2:20 am, or maybe 4 or 5 in the morning. Can ...
|
| Removal of lines | 09 Jan 2006 09:38 GMT | 1 |
I am just a self taught beginner, so could someone please explain to me how can I remove the lines separating the columns e.g. between columns A B & C, in lines 1 and 2, so that if I have a heading on a worksheet, which is meant to incorporate more than one column, e.g. 2006, so ...
|
| Moving the formula bar out of the way | 09 Jan 2006 08:09 GMT | 11 |
I have some long formulas that cause the formula bar to display over the column letters. It helps when I check formulas to see what columns are in the formula without having to moving back and forth to a blank cell. Is there a way to move the formula bar so I can see the column
|
| Advice on timing of posts appearing | 09 Jan 2006 04:11 GMT | 3 |
I've noticed over the last few days that some of the posts I've made are taking a very long time to appear. Last night I replied to mevett's post "Link to a changing cell? You'll see ..." at 11:58pm (my time). Over an hour later it hadn't appeared, so I posted another one
|
| IS THERE A AUTO TEMPLATE FOR INVOICES | 09 Jan 2006 03:48 GMT | 1 |
Is there a template available that would fill in invoice numbers autmatically when opened with a new number?
|