| Thread | Last Post | Replies |
|
| Column Headings are numbers | 08 Mar 2005 23:39 GMT | 1 |
I have been working with Excel for sometime. I recently opened a new workbook and the column headers have changed to numbers as opposed to letters. How do I get them changed back??
|
| print a spread sheet with grid lines | 08 Mar 2005 23:34 GMT | 6 |
I have tried going to file page set up and clicking on grid lines but still can not get excel to print the grid lines with the figures in them Thanks
|
| Excel formula for seperating two words in the same cell. | 08 Mar 2005 23:34 GMT | 2 |
How do I seperate two words in the same cell, seperated by a comma into to seperate cells. eg. John,Smith (in cell A1) converted to John (in cell B1) and Smith (in cell C1)?
|
| DSUM - SUMIF help needed..... | 08 Mar 2005 23:25 GMT | 8 |
I have a spreadsheet that tracks the time that employees spend on various projects (this gets billed to customers). It looks something like this: EMPLOYEE NAME | DATE | PROJECT | COST CATEGORY | HOURS
|
| Gradebook woes | 08 Mar 2005 23:16 GMT | 2 |
As Eeyore says, "here we go" I am implementing a gradebook with excel. How can I three assignments weighted differently and still give me an average in one cell? I also would like to have columns open to add assignments and to have those assignments
|
| close only one workbook | 08 Mar 2005 21:44 GMT | 1 |
When several workbooks are open in Excel 2003 and I try to close only one workbook, all open workbooks close without saving any of the workbooks. How to correct so that each can be saved and closed individually?
|
| Conditional Formatting of a row | 08 Mar 2005 21:38 GMT | 1 |
I want to use Conditional Formatting to color a row (or 10 cells across) based on the value of one cell. If the specific cell value is "W" I want the row colored green. If it is "D" I want the row red, and so on according to my rules.
|
| Problem formatting for phone number | 08 Mar 2005 20:45 GMT | 1 |
Can anyone tell me how to use the cell validation or some other method to put the numbers entered in a cell in a proper phone number format? (###) ###-#### Thanks,
|
| Converting Rows of Data to Columns | 08 Mar 2005 20:43 GMT | 3 |
I have the following data, for example. Location # Vendor # 151 250368 151 312956
|
| Changing an Environment Variable. | 08 Mar 2005 19:39 GMT | 5 |
Is it possible to do? I know the Environ function will return the value of one but can find nothing in Help that will allow me to change one. No big deal, just curious.
|
| Excel's 3-D Graphs are So Poor; WHY? | 08 Mar 2005 19:12 GMT | 4 |
While Excel's 2-D graph capabilities are excellent, 3-D graph quality is very poor indeed; unless I am missing something. Just try to plot any 3-D small table and see. I can't see how could be called 3-D graph since it breaks each or mix all!
|
| How to convert excel Docs to pocket excel on my mobile device | 08 Mar 2005 19:03 GMT | 1 |
Like the titile saids, "How do I convert Excel Document/Files that I have on a PC to my mobile device", so that I can not only view them on my PDA, but also edit them when needed. As for now I cannot read what I copy to my PDA. But when transfered back to
|
| Windows in taskbar | 08 Mar 2005 16:42 GMT | 2 |
I have a user who rings me up every couple of weeks to say that Windows in Taskbar has switched itself off. Does anyone know of a keyboard shortcut that she might be hitting to do this unintentionally? Thanks.
|
| Combining Excel and Word | 08 Mar 2005 16:15 GMT | 2 |
I work at a firm where we prepare monthly bills for our clients. The bill consists of three Word documents and one cover letter. I prepare the calculations on several spreadsheets in one Excel workbook. I would like the calculations to automatically update the Word documents. ...
|
| Printing the last modified or saved date in the header/footer | 08 Mar 2005 16:03 GMT | 1 |
Is it possible to print the last modified or saved date in the header/footer, instead of the date printed? If not, is there a way to put this value in the worksheet itself?
|