| Thread | Last Post | Replies |
|
| Conditional format question | 30 Sep 2006 01:19 GMT | 6 |
When I select and conditional format column A, and then when I conditional format column B using some of the same cells in column A the conditional formatting no longer works for the other column. Here's my formula for column A:
|
| Summing cells defined as Time hh:mm | 30 Sep 2006 00:01 GMT | 4 |
I looked at a couple of similar questions but have not been able to achieve a good result. I have a few cells defined as Time HH:MM. I want to sum them up so I get hours and minutes. In the cell to hold the total, I used "=SUM(N43:N47)". I
|
| formula for scheduling in advance | 29 Sep 2006 23:46 GMT | 2 |
How do I set up a cell to add 12 months to the date in another cell? Example: 'Maint Date' cell has current date--'Next Maint Due' cell needs to have that date plus 12 months.
|
| Excel Office 2003 | 29 Sep 2006 23:44 GMT | 3 |
When I open a new workbook in excel, I get a a workbook with 34.2MB size. Even after a small amount of data is entered and saved the file still is 34.2MB. This makes it too big an attachment to e-mail. Any ideas?
|
| Inability to start Excel after Refresh update | 29 Sep 2006 22:30 GMT | 1 |
Since installing the Refresh update this morning, Excel fails to start in either full or safe mode. Word and Powerpoint work OK. I've also installed the compatability update, to no avail. Is anyone else having this problem? I'm loathe to uninstall the original Excel 2003 at this ...
|
| Multiple Worksheet Protection | 29 Sep 2006 21:44 GMT | 1 |
I have a workbook that has multiple worksheets with the same format. Is there a way to protect cells on these multiple worksheets at the same time. The group feature does not work for this and having to do each worksheet separately is very timeconsuming
|
| excel 2002 -how can you convert a file to a pdf read only file? | 29 Sep 2006 21:36 GMT | 4 |
I use Office Pro XP which includes Excel 2002. I want to convert a file to a read only .pdf file but cant see how.....
|
| AutoFilter Question | 29 Sep 2006 21:25 GMT | 2 |
I have an Excel file that contains 5000 records. When I do the AutoFilter of all records and when I click on the AutoFilter drop-down arrow of a column, I do not see all the information in the list. Therefore, I can not select the information that I want to filter.
|
| Format & calculate time sheet template | 29 Sep 2006 20:44 GMT | 3 |
I'm building a time sheet template to calculate hours worked each day and pay period. My problem is setting up cell formatting to recognize a 3pm to 1:30AM shift, that will work in the calculations.
|
| combo/text box print issue | 29 Sep 2006 20:21 GMT | 7 |
I created a form with combo and text boxes on it. THe form is perfect except typed info in the boxes does not print. I am assuming there is something I need to add to the code or set from false to true, but not sure where to look, any help appreciated.
|
| How can I count up values in a list that includes duplicates? | 29 Sep 2006 20:09 GMT | 2 |
I have a list of values, some of which are duplicated (around 600 rows). I would like to know how many unique values there are in the list, using a formula.
|
| Headers and Footers | 29 Sep 2006 19:56 GMT | 1 |
How do I edit footer so I do not keep adding new ones to the list?
|
| Print selected range in a worksheet | 29 Sep 2006 19:19 GMT | 2 |
hello community Is there a way for me to put 2 selected range of data to be printed out into a single page. When I used the "Print Selection", the two area that I selected appeared to be in different page.
|
| excel worksheet | 29 Sep 2006 19:18 GMT | 1 |
how do I go about putting a footer on several worksheets at once?
|
| Importing to Excel from csv AND keep leading zeros | 29 Sep 2006 19:15 GMT | 2 |
I have a script that saves a csv file and mails it to people as a report. When people open the csv file using Excel the column of account numbers have leading zeros. Not all but most. How can I have them open or import to Excel and keep the leading zeros from
|