| Thread | Last Post | Replies |
|
| How to COPY from cells to cells w/o affecting respective formulae underneath ? | 21 Apr 2004 00:12 GMT | 1 |
Would highly be appreciated if can be told on: How to copy data from cells ( formulated with "a") to cells ( formulated with "b")
|
| Comment box drops down too far off page | 21 Apr 2004 00:01 GMT | 1 |
Hello,...I have a form in which I have created some comment boxes. Th biggest complaint that I get is regarding the comment box that pops u from the last line of the form. It drops down too far and they alway have to scroll to read the entire box. When I edit the comment box i
|
| Embedded Option Button Grouping | 21 Apr 2004 00:00 GMT | 1 |
I am trying to embed 3 groups of option buttons in an Ecxel spreadsheet. I was wondering how to differentiate the radio buttons from each group (i.e. have 3 separate lists) without having to resort to VBA and proper forms.
|
| Excel File backup | 20 Apr 2004 23:47 GMT | 2 |
I have a excel file with 8 sheets & i would like to have a backup fil for this with values alone in it.something like paste special values i the backup file. Regards,
|
| Rounding question | 20 Apr 2004 22:22 GMT | 1 |
I am new here and did not find the answer to what I need. I have two sections of data. The first group of rows I need all th numbers to round DOWN to the nearest thousand (zero if less tha 1000).
|
| Limiting an AVERAGE to a maximum number of values? | 20 Apr 2004 21:55 GMT | 1 |
I've got a table for which I want to find the average of the right-most (filled) 12 columns. To be specific, the data in the table is organized by month, and I want to, for each given row, see what the average is for the prior year (12 months).
|
| MSWorks & MSOffice | 20 Apr 2004 19:35 GMT | 3 |
I have MSWorks & am attaching files to 3 MSOffice users. They cannot access the downloads (gibberish). Is there any way I can make the 2 programs compatible?
|
| File size and server limit | 20 Apr 2004 19:33 GMT | 2 |
A spreadsheet I am building has reached a painful size of 32MB where am getting calls from IT on a daily basis as the file ties up most o the resources on the server. Anyone has any idea on size limitation and speed?
|
| Combobox on a worksheet | 20 Apr 2004 19:01 GMT | 6 |
Here's what I want to do: Offer the user the ability to quickly select a print area and print it. Here's what I've done so far: Defined [named] a number of ranges, each being a potential print area.
|
| Table Question | 20 Apr 2004 18:59 GMT | 3 |
Good Day I have a table (a1:n2400) that retrieves info from 7 days of the week (different files). Once I filter out the blanks I have all the info I need, unsorted.
|
| Password Protecting Validation Lists | 20 Apr 2004 18:06 GMT | 4 |
It seems as though when you password protect a worksheet it still allows another user to change the intial selection selected when using Data Validation and allowing a specific entry as per a predefined List. Is there anyway to prevent changes to a Data Validation selection after ...
|
| take the content from 7 cells randomly | 20 Apr 2004 17:46 GMT | 1 |
I need to add in to my present formula a random word from a list of word all held on cells L1 to L7 Kind anyone help pls.... Kind regards
|
| Formatting Date from imported data | 20 Apr 2004 17:20 GMT | 1 |
Hi~ I have tables that are automatically exported from Access on a monthly basis into excel spreadsheets-- the tabs are named after the tables that are imported - data imported
|
| Large excel file is very slow | 20 Apr 2004 15:44 GMT | 1 |
We have a few excel files. These files are about 25 Mb each. When we want to open a file, it takes about 3 minutes to open it. When we want to save these files it takes about 5 minutes. We try different files on different pc's. So it's not the fil
|
| Cell entries display problem. | 20 Apr 2004 15:41 GMT | 6 |
A10 is Sum(A1:A9). When I enter values in these cells, cells A1, A2, A3, and A4 do not display values,however, the values is there!A10 shows correct sum and the values appears on the print screen. How have no idea how this happens. Please help!
|