| Thread | Last Post | Replies |
|
| Mail merge matching fields | 30 Aug 2007 18:32 GMT | 3 |
How do I increase print fields on mail merge labels
|
| Filter data and fill only filtered data | 30 Aug 2007 18:26 GMT | 1 |
It is truly amazing what a terrible job microsoft did in putting together Excel 2007. What a complete disaster. Here is my problem: I have filtered data that I want to flag as "Y" for example. If I put the
|
| Trailing Periods (Dot Leaders) | 30 Aug 2007 18:18 GMT | 5 |
Is there any way to add the trailing periods, dot leaders to cells that contain text and in the next cell a dollar amount, I have someone requesting it so that it is easier for them to see which amount corresponds to that description. If you manually insert them, you have to ...
|
| filters and summing in status bar | 30 Aug 2007 18:11 GMT | 1 |
when i filter on anything, it doesn't show me the sum of the totals in the status bar. how do i get this to show me.
|
| File Properties | 30 Aug 2007 18:06 GMT | 2 |
I have added file properties to an Excel file, and I can view them when the file is open. However, when I go through Explorer, the properties are not visible? Fix?
|
| seeking help on how to automatically shift an average range as new data is added | 30 Aug 2007 17:59 GMT | 2 |
Cells b20 through m20 contain numerical values by month. These cells get their data from an external source; using code I gleaned from here and elsewhere on the 'net this data will be automatically populated. That is, today the cells for August 07 through March 08 (f20 - m20)
|
| SUMIF and {multiple criteria} | 30 Aug 2007 17:53 GMT | 7 |
Can anyone help me to understand why this formula gives the correct result: =(SUMPRODUCT((Region="Asia")*(DECONS="Ontime")*(SPLIT={"E","W"})) +SUMPRODUCT((Region="Asia")*(DECONS="Ontime from
|
| Updated Cells in different workbooks | 30 Aug 2007 17:49 GMT | 4 |
Is it possible to update cell a1 in 7 different workbooks or files at the same time? Thanks.
|
| From Excel 2000 to Excel 2003 | 30 Aug 2007 17:42 GMT | 3 |
Our office is just moving from Office 2000 - Office 2003. Can someone give me a quick idea of some of the major changes between Excel 2000 and 2003? I understand that there were some major changes to Excel in the 2002 version. I have also been able to find some articles with ...
|
| How do I copy a worksheet for each day of the year? | 30 Aug 2007 17:40 GMT | 9 |
I'm trying to create a new sheet for each day of the year. It needs to contain the day and date but I really don't want to copy and paste 2 years of forms and manually change the date. Please can anybody help.
|
| Preserve cell formatting as SSN | 30 Aug 2007 17:36 GMT | 2 |
I've got a couple cells formatted as Special, then Social Security Number. When users enter the spreadsheet they are presented with a series of VBA forms for data entry, and on one of them they input a SSN. The idea is to let them enter the ssn with or without dashes, and have ...
|
| Recent problem opening files with Excel 2003 | 30 Aug 2007 17:34 GMT | 2 |
When I double click a file or when I right click to open a file, the file will not open. The only way I can open a file is by opening it through Excel. I tried reinstalling Excel and Office as well as disabling Norton Security; but to no avail.
|
| How do I merge address information in Excel into Word? | 30 Aug 2007 17:34 GMT | 1 |
I am trying to take information in Excel that is split up in columns, such as first, middle, and last name plus each field of their address and merge it into word for printing on envelopes. I have tried all that has been suggested on this site and what I get is a bunch of boxes. ...
|
| make backup excel | 30 Aug 2007 17:32 GMT | 2 |
I'd like to make a backup of an Excel file, but NOT in the same folder. I'd like to make a true backup, not in the location of my original file but on another physical drive. So I don't mean the auto backup function which saves the backup in the same
|
| zip code with mail merge | 30 Aug 2007 17:24 GMT | 4 |
the 1st zero gets dropped from zip codes when address spreadsheet is used for mail merge.
|