| Thread | Last Post | Replies |
|
| excel file will not open | 25 Jul 2006 21:20 GMT | 2 |
Someone gave my a floppy disk with an excel file on it and it will not open. He told me that the computer that he was working on it froze-up and he rebooted the pc and known it won't open. Try repaired it through excel
|
| How do I set default for a column so that first letters are caps? | 25 Jul 2006 20:46 GMT | 2 |
if a column is names, how do i set it so that the first letters are all caps?
|
| How do you make titles for columns in worksheets? | 25 Jul 2006 20:36 GMT | 3 |
I just want to make titles for columns in worksheets. I can't get information on this no matter how I phrase the query.
|
| checkbook register | 25 Jul 2006 20:21 GMT | 5 |
down loaded check book rei can't get checkbook register to do the math
|
| Removing rows based on prescence in another sheet | 25 Jul 2006 19:54 GMT | 1 |
I have a large sheet using columns A-E and I need to remove certain rows from it. I need to remove any row where cells A and D of that row occur together in columns A and D of another sheet in the same row as each other.
|
| Splitting an expense | 25 Jul 2006 19:10 GMT | 4 |
Amature here! Expense amount = 1,370.25 in A1 Client #1 owes 1/2 = $685.13 (A2) Client #2 owes 1/2 = $685.12 (A3)
|
| Sort by part of a number | 25 Jul 2006 18:48 GMT | 2 |
I need to file by claim number where the number is P1- 358V-852 P1-358V-058 The correct order would be by the last three characters. Can this be done in an easy way?
|
| Create a pivot from CSV or access | 25 Jul 2006 18:44 GMT | 1 |
I have a CSV file and I wish to create a Pivot out of this.I am converting it in to access and then planning to create a pivot from access.I am converting it in to acces so that no of rows do not do not become a limitation in excel .
|
| About procedures in microsoft support | 25 Jul 2006 18:27 GMT | 4 |
Is it possible someway to save (or print) all the answers of a newsgroup of Microsoft support (for example EXCEL team), without going question by question? Thank you.
|
| Conditional formating | 25 Jul 2006 18:16 GMT | 9 |
Need help figuring out a formula please. If "date entered" in cell exceedes todays date by 4 days, then format the cell background "Red". Thanks so much for any help you can give.
|
| how to auto copy excel cells to outlook email | 25 Jul 2006 17:50 GMT | 1 |
great site. not sure if this is the right place to post this: here's what i'm trying to do: i have to send daily emails to a list of people. the info on the email is in an excel doc (eg cells A1 to e5)
|
| Sorting numbers as Text | 25 Jul 2006 17:46 GMT | 6 |
I frequently work with a lists of text data, some of which consists of digits or digits + alpha characters. These are always formatted as tect fields. When I sort them i get a dialog box asking if I would rather sort digits as numbers or as text. Sorting as text provides the ...
|
| show only the required part of the sheet | 25 Jul 2006 16:35 GMT | 3 |
i want excell to display only the selected part of the sheet where there is data in it and rest all should not be displayed. e.g. from a1 to aa155 should only be displayed.
|
| Inserting a Drop down Menu | 25 Jul 2006 16:33 GMT | 2 |
Very simple questions so I'll keep it short. How do I insert a drop down menu into Excel? Thanks for any help.
|
| Sum in numbers for text values | 25 Jul 2006 15:49 GMT | 4 |
Help! I have been asked by work to create a spreadsheet for tracking the number of companies we are speaking to. I need to calculate the total number of companies in a certain column but some companies are listed twice as we have different contacts in each company.
|