| Thread | Last Post | Replies |
|
| can a .csv file be formatted? | 28 Dec 2005 21:38 GMT | 4 |
I have had to place all my information from a word document to a csv file. However, I notice that the formatting is not saved and the content appears in lines without any line or para breaks. The formatting is very important in the project. Each time I try to reformat, it goes ...
|
| how do you delete cells when they are connected with a formula | 28 Dec 2005 21:28 GMT | 10 |
All I know how to do is enter info into a cell. This is a list of numbered employees. Usually, I would just seleted the cell and delete, but I get ###error. The formula is =+sum (A73+1) Please help!!!
|
| How do I save an excil file? | 28 Dec 2005 20:14 GMT | 2 |
One of my excil files are damaged from installing another system. How do I restore this file?
|
| How do I update copy of worksheet | 28 Dec 2005 19:49 GMT | 1 |
Is there a way to update a copy of a spreadsheet(2 worksheets of 4 on source) without manually opening the copy and updating the links?
|
| safe ratio and monthly payment what does it mean | 28 Dec 2005 19:47 GMT | 1 |
I downloaded an office tool,Consumer Debt Manager, and the statement "safe ratio and montly payment" is in a cell. What does it mean?
|
| delete cells with formulas | 28 Dec 2005 18:19 GMT | 1 |
I have a spreadsheet of employees' names, #'s, etc. I need to delete rows and add new names, etc. The formulas says =+SUM(A73+1) for example. I can't just highlight the row and delete because it gives me an error #REF!+1. Please help.
|
| Equation Evaluation at Multiple Points | 28 Dec 2005 15:47 GMT | 1 |
I have seen this done but how to do it eludes me. What I'm looking for goes something like this. Fill a column with numbers (like 1, 2, 3,...) Fill the next column with the same equation.
|
| pivot chart mystery fields | 28 Dec 2005 15:37 GMT | 5 |
I've been given the task to reverse engineer an excel pivot chart that an ex-employee created. When i look at the data source it pulls in all the fields from a particular table from an access database. However, once it gets to Step 3, and i select Layout, all of a sudden there ...
|
| Conditional row deletion based on value in a row | 28 Dec 2005 15:30 GMT | 3 |
I am trying to create a macro that will delete all rows in a worksheet that have the value 0 in column B. The macro should only delete rows where the value equals 0, and not rows where the value contains 0 (for example, 10). Ideally I'd like to have this in a form that I could ...
|
| How do I reconcile two sheets with in a .xls book? | 28 Dec 2005 15:15 GMT | 2 |
How do I reconcile two sheets with in a .xls book?
|
| Change time scale in a chart by changing cell value | 28 Dec 2005 04:49 GMT | 1 |
I have the following problem. I want to change the time scale in a chart (XY scatter) by changing th dates in another worksheet. In other words, I have a chart showing th results from 1 January 2005 up to 31 January 2005. Now I want to see i
|
| How to do a conditional format for multi cells | 28 Dec 2005 04:35 GMT | 2 |
Lets say based on a value in A5 I would like to change the text format for cells d5:g5 (four columns), what would be the best procedure to do this, can it be done using conditional format if each cell d5,e5,f5,g5 or is there another way. By that do I input a conditional format ...
|
| Capping a formula value? | 27 Dec 2005 23:40 GMT | 2 |
Greetings, Experts, Thanks for reading this message. I'm trying to figure a formula that reaches a cap, and if the formula wants to return a value over the cap, it displays the cap. if it is below the
|
| How do I set excel to open a hyperlink with the enter/return key? | 27 Dec 2005 23:29 GMT | 1 |
In our old excel program, when you "landed" on a cell with a hyperlink and then pressed the enter key, it would open the hyperlink...the way our new one is set up, when you press the enter key, you move down on the page...How do I reset the key?
|
| when starting excel, .doc & .dat file come up ????? | 27 Dec 2005 23:17 GMT | 2 |
When I got my new computer at work XP Pro operating, w/2003 Office pro, every time I open Excel, about 12 .doc & .dat file pop up saying not excel format files, and I have to say close to everyone. Then, if automatically defaults to opening an excel file that is someone elses. ...
|