| Thread | Last Post | Replies |
|
| show date file updated? | 08 Jan 2008 14:56 GMT | 6 |
Can I have a field that automatically shows the date when the file was last updated?
|
| Howto update prises automaticly | 08 Jan 2008 14:49 GMT | 1 |
I have som excel dokuments with many articles. They all have 3 price kategories each. Is there possible to update all of the prises at one using the forumal: Price*1,05=NewPrice
|
| Allow multiple selections within a checkbox of items | 08 Jan 2008 14:42 GMT | 1 |
How do I create the option within a form to select more than one option within a field?
|
| avoiding a #value! return | 08 Jan 2008 13:51 GMT | 2 |
I have a formula ='[Labour Variance Report wk01.xls]Summary'!$N$55+'[Labour Variance Report wk01.xls]Summary'!$N$56='[Labour Variance Report wk01.xls]Summary'!$N$75+'[Labour Variance Report wk01.xls]Summary'!$N
|
| Can Excel autosize merged cells yet? | 08 Jan 2008 13:48 GMT | 1 |
Begging everyone's indulgence with an old Q: I'm using a somewhat dated version of Excel. (Where it says "Tools" on the menu, it means "polished stones".) In the past, Excel couldn't autosize merged cells--thereby preventing,
|
| Copy worksheet into several worksheets in the same or another work | 08 Jan 2008 13:15 GMT | 4 |
Need help with copying a worksheet into several worksheets in the same or another workbook I have found the Merge Works formula, but, as I understand it, that is different from what I am trying to accomplish. That appears to be for what
|
| Can I show date of last update? | 08 Jan 2008 13:09 GMT | 3 |
Is it possible to have a field that automatically shows the date when the sheet was last updated, ie, when any field contents have been changed? (Apologies if this question is repeated. I posted it yesterday, but it was not in the 'date/Excel' search list today.)
|
| Score Rating | 08 Jan 2008 13:05 GMT | 2 |
All, I would appreciate if you could helpme with the following: I am trying to determine the score level in one cell for the belo creteria: score rate
>80 or <90 "need improvement" |
| Date Format | 08 Jan 2008 11:48 GMT | 1 |
In excel 2003 we used to type the date without / or - When we do that in Excel 2007, we get a lot of hashes (####). How can we get it to behave the same as Excel 2007?
|
| Merge Cell Problem | 08 Jan 2008 09:15 GMT | 4 |
I have created a new worksheet which is very basic with no formulas. I want to merge some cells however the Merge' button on the tool bar is grey'd out. It does not function. I have never come across this before and do not know how to fix. Does anyone have any suggestions ...
|
| Problem opening files from server | 08 Jan 2008 02:50 GMT | 1 |
When attempting to open a file from the server by clicking the short cut to the folder on the server, then the file I get the following message: Windows cannot find 'L:\name_of-file.xls'. Make sure you typed the name correctly, and then try again.
|
| adding cells in a colomn | 07 Jan 2008 23:45 GMT | 2 |
iam a new user to excel and i want to add up all the cells in a single row so from A1 through to A200. does anyone know a formula i can use to add these 200 cells up? thanks anyone. Dawn
|
| Excell 2003 | 07 Jan 2008 22:21 GMT | 1 |
I am trying to print a worksheet where I want a given set of rows to print as Titles, but I can't get Excel to let me do that. In Page Preview, Setup, on the Sheet Tab, I should be able to set my Print Titles, but whatever I do those fields stay grey and un-editable. That is
|
| Summing Duplicates | 07 Jan 2008 22:03 GMT | 3 |
Following is a sample of data exported from our DOS-based order entry system in CSV format: PART# QUANTITY LIST SALE PRICE PRICE
|
| changing from relative to absolute references | 07 Jan 2008 21:39 GMT | 2 |
I have 8 sheets of relative references that I need to change to absolute references. Can I change these in one go please? Thanks Brian
|