| Thread | Last Post | Replies |
|
| Always show the content of a specific cell in the frame of Excel | 13 May 2008 17:49 GMT | 1 |
Is it possible always to show the content of a specific cell in the frame of Excel (so you always can see it). Then it is possible always, for examble, to see the sum of some cells, when you are filling the underlying cells with numbers.
|
| Help...... | 13 May 2008 17:48 GMT | 1 |
I have 3 seperate excle(Crystal.xls, AMETITSG.xls, ITSGAsia.xls). If any data added in Column A of Crystal.xls and any data added in column D of AMETITSG.xls should be automatically added in Column A of ITSGAsia.xls TIA
|
| Help with printing gridlines | 13 May 2008 16:48 GMT | 2 |
I have a wksht where I can see the gridlines, and have selected a checkmark to print out with the gridlines. However, if I do a print preview or print, the gridlines are missing in the output. I must have turned something off accidentally.
|
| save as pdf crashes | 13 May 2008 16:29 GMT | 1 |
I am having difficulty with the Excel 2007 'save as pdf' functionality. I have posted the troublesome file at the link below: http://dollar.biz.uiowa.edu/~jgoodson/TestRecourse.zip When attempting to save the 'chart1' worksheet as a pdf file, Excel
|
| Rotating Work Schedule | 13 May 2008 15:23 GMT | 7 |
I have put Monday Tuesday Wednesday Thursday Friday Saturday Sunday 3/24/2008 3/25/2008 3/26/2008 3/27/2008 3/28/2008
|
| Cannot open shared Excel file because it is locked by own id | 13 May 2008 15:05 GMT | 1 |
A fellow user maintains an Excel file on a Windows Server 2000 box that is shared across a network. This user accesses the Excel file from his desktop which is running Windows XP SP2. Frequently, he cannot open his shared Excel file because it is locked by his own id.
|
| Excel ignoring date format when saving to Text | 13 May 2008 14:16 GMT | 1 |
I have a spreadsheet that look fine on the screen, perfectly formatted date wise. It's a 2003 SP2 spreadsheet. When I save it to text (Tab delimited) or any other text format it reverts to mm/dd/yyyy formating instead of british dd/mm/yyyy.
|
| Problems referencing dates with the MATCH formula | 13 May 2008 11:59 GMT | 12 |
I am finding this a little unpredictable. Sometimes it works fine; for example: A B C D Date Mar-08 Feb-08 Jan-08
|
| Referencing Dates with the MATCH formula | 13 May 2008 09:11 GMT | 1 |
I am finding the MATCH formula to be a little unpredictable when used with dates: Sometimes it works as I would expect. For example: A
|
| Forcing a cell to be formatted as text - when using the Match Index functions | 13 May 2008 09:05 GMT | 7 |
Hello - I am trying to do use the Match and Index functions to perform a Vlookup. However, the column for which I am attempting to match values will not convert to text format (thus disallowing me from doing the Lookup).
|
| using a map to fill in a textbox | 13 May 2008 04:15 GMT | 4 |
I have created a geographical map with different provinces in Excel 2003. I have assigned a macro to each province and it works well. I have also created a userform. When the province textbox is prompting for input, I want the map to appear
|
| Extracting the data according to the number of cell | 13 May 2008 02:27 GMT | 4 |
I have a minor Excel formula problem. In my example has following data, cell A5 shows "apple", A6 shows "salt", A7 shows "sugar" and A8 shows "fish". On another hand, cell B3 is the "criteria" data showing 3.
|
| Re : Excel Wrap-Text with Relatively Loose Strings | 13 May 2008 01:44 GMT | 3 |
Re : Excel Wrap-Text with Relatively Loose Strings 1. Enters an Excel worksheet (received from the wilderness). 2. In a fixed-width cell, there is an entry such as the following string :-
|
| date reformatting | 13 May 2008 01:28 GMT | 1 |
I have a date m/d/yyyy and would like to convert it to mm/dd/yyyy. I tried format-custom-mm/dd/yy but it is returning m/d/yyyy can someone help me out?
|
| Autofill time schedule with gaps | 12 May 2008 23:07 GMT | 4 |
I'm trying to teach myself Excel XP (using "...for Dummies"). I used Autofill to create a daily time schedule column, but in alternating cells (e.g., 6:00 AM/[empty cell/6:30 AM/[empty cell]. Is this an Autocomplete or Autofill function? Also, it uses military time. How do I get ...
|