| Thread | Last Post | Replies |
|
| Pasting MS word tables into Excel | 10 Jun 2005 19:00 GMT | 2 |
I have a MS Word doc that contains a table. In the each cell of the table are multiple lines of text (an address). I want to get that information to a spread sheet. The key is that I want to paste all the contents of a cell in the Word table into a single cell of the spread ...
|
| rotate an Excel chart pasted into Word | 10 Jun 2005 18:53 GMT | 6 |
I created a chart in Excel that is best viewed and printed in landscape view. But after pasting it onto a page of my Word document, I can't figure out how to rotate it 90 degrees to better fit the page.
|
| Excel files not showing read-only | 10 Jun 2005 18:36 GMT | 2 |
We have users who share files working with Excel and they are sometimes able to open an Excel file and edit it even when it is already open. - A read-only alert does not pop-up. Already checked out the Share Workbook option and it sin't set to allow
|
| Worksheet functions | 10 Jun 2005 18:25 GMT | 2 |
How do I create a function that will add an amount according to the date? Like a late fee?
|
| Setting a dynamic range in a formula | 10 Jun 2005 18:13 GMT | 3 |
I have a column of numbers and I always want the following arra formula to use the last 12 entries: =(PRODUCT(1+D1:D12/100)-1)*100 Any suggestions?
|
| Change part of data within a cell. | 10 Jun 2005 17:53 GMT | 2 |
I have a long list of data in the format: a-bb-ccc-yyy-zz Where all letters are numbers, i.e: 1-01-100-200-00
|
| MsgBox in footer | 10 Jun 2005 17:25 GMT | 1 |
I have a spreadsheet that I would like to put the message, "Last updated on: xx/xx/xxxx" in the center section of the footer. The date is never consistent, so the user would need to be prompted to enter the date. I am envisioning something like a message box.??
|
| Sorting specific data | 10 Jun 2005 17:14 GMT | 3 |
I need help to sort the contents of a cell. Cell A1= 01201 I wish to sort the numbers in A1 into descending numerical order. The
|
| Help with an array function | 10 Jun 2005 17:10 GMT | 4 |
okay, I've got a worksheet (Individual Week Totals Tracking) that uses an array function to call on another worksheet (Lantigua) and sums the cells in each column holding a specific date in the Lantigua worksheet.
|
| how to sort cells with sheet reference | 10 Jun 2005 16:02 GMT | 1 |
i an unable to sort the data in cells containing a reference to anothe sheet. it seems as though excel is treating this reference as absolut and not relative. is there any way to do this, such that thes equations adjust to the sorting? any thoughts would be appreciated.
|
| Entering Formula into Merge Cells Question | 10 Jun 2005 15:54 GMT | 1 |
:) Here is the situation. Merged S6 through u6 into one cell. Merged s7 through u7 into one cell. Merged s8 through s8 into one cell.
|
| Validation Lists? | 10 Jun 2005 15:26 GMT | 3 |
I have made a drop down using the List in Validation with two options, say X and Y. 95% of the time either X or Y will be chosen but I would like to give the user the option to type into the same cell any value, not necessarily X or Y. I could take out the Validation and let the
|
| pivot table adding in a formula | 10 Jun 2005 13:30 GMT | 2 |
I have a pivot table and i want to add a cumulative total going down the pivot table. example part number | total parts | cumulative total parts to here
|
| Multiple Pivot Tables, Same Worksheet, Single Page Field | 10 Jun 2005 13:30 GMT | 2 |
I have an Excel spreadsheet with multiple worksheets in it, each with different data. In all the worksheets there is a common element (Year). I would like to create a master page that has multiple pivot tables in it. However, at the top of the page I would like a single page ...
|
| Back up data directory | 10 Jun 2005 13:11 GMT | 1 |
Excel wants to access a backup directory on my d-drive which is my CD-DVD removable drive. When I go to the Tools-Options panel and select any tab I get a pop-up saying that "cannot access 'd:\data\Excel' ".
|