| Thread | Last Post | Replies |
|
| how to automatically add row column headings to inserted table? | 14 Mar 2008 21:32 GMT | 1 |
I have inserted tables into Word and/or Outlook. I would like to "turn on" the Row and Column headers so that the table is referenced.
|
| Format Painter | 14 Mar 2008 20:44 GMT | 1 |
I have tried the way it says to extend my formating down the column but it is not working. Here is what I am doing 1. click cell with formatting I want to apply. 2. click format painter button. 3.click and drag mouse to select cells i want to appy the formatting. 4. release ...
|
| How do I send email addresse from excel spredsheet to aol contact | 14 Mar 2008 20:43 GMT | 1 |
|
| Help w/ calculating weekly Avg | 14 Mar 2008 20:28 GMT | 6 |
I am not sure what formula to use to calculate the weekly average, which is the range of the week data (Monday to Sunday). Example: date range from 2/4 to 2/10/08 week is the sum of data from 2/4 to 2/10 divided by 5 (weekday). Below is a sample of data and results I want to ...
|
| Wrap text in merged cells VBA | 14 Mar 2008 20:13 GMT | 1 |
I have merged cells that need to wrap text. I used the VBA code several of you provided and it is working great for the most part. The problem I am running into is when I have more than one set of merged cells on the same row. I have applied text wrap to each of them. Let's say I ...
|
| Cell Format on Imported Data | 14 Mar 2008 19:37 GMT | 3 |
I have imported data from Oracle (using programing, not import). This is a large file and it brought all numbers over as text. When I choose the column and fomat as number nothing happens. I have to choose each cell change format and enter. This is impossible as there are ...
|
| Excel Formula | 14 Mar 2008 19:32 GMT | 4 |
I am trying to get results for cells with dates in them. Who do get the following results: a2 = begining date (3/4/8) b2 = ending date (3/5/8)
|
| Annual leave without holidays | 14 Mar 2008 19:27 GMT | 3 |
I am working as an H.r and i am looking for a formula concerning the annual leave I have already found a formula that gives the total of the days allowed without the weekends
|
| vacation excluding holidays | 14 Mar 2008 18:29 GMT | 1 |
I am trying to count the total of leave taken without the holidays and the weekends i have used the NETWORKDAYS but i dont know what is the formula in order to have a total
|
| Text overlapping cell border above it | 14 Mar 2008 18:26 GMT | 4 |
When I print from Excel, the text more and more is printing over the cell border above it, the further down it is. How do I prevent this from happening? K
|
| Transpose issue | 14 Mar 2008 18:06 GMT | 1 |
I have a series of email addresses from an Outlook email. I want to use Excel's sort feature to sort these email addreeses looking for duplicates. I have attempted to copy , paste special, and transpose to insert this semi-colon separated row into an Excel column. It does not ...
|
| Date Formula help | 14 Mar 2008 18:02 GMT | 3 |
I am trying to calculate the number of days in a time period excluding Sundays, (i.e., 2/29/08 minus 2/23/08 = 5 ) Can anyone help me?
|
| Hiding Results of Answers for a Quiz | 14 Mar 2008 18:00 GMT | 1 |
Looking for some help here please. I currently have a quiz set up, with simple questions in the A Column. The delegate places their answer in the B Column, and the C Column then states whether it is correct or not.
|
| Not Enough Memory opening 2nd spreadsheet | 14 Mar 2008 17:03 GMT | 2 |
I have 2 spreadsheets each of 24.5MB. If I have one open and try to open the other I get "Not Enough Memory". However my C: has 63.6 GB of avialable memory. Why is this happening and how can I overcome this. Using Office 2000 on Windows XP.
|
| Shared document will not open for user | 14 Mar 2008 16:54 GMT | 1 |
I have a user who is using Excel 2003 on Windows XP. She has a shared workbook that is password-protected on a shared drive. Everyone who has access to the spreadsheet can open it, except for her. It is only this spreadsheet. Her password works fine on other spreadsheets and
|