| Thread | Last Post | Replies |
|
| How do I create a running balance? | 07 Apr 2008 01:21 GMT | 1 |
I am finding it extremely diffucult to have a running balance, G column is the running total, anything in E column is to be subtracted from G column and anything in F column is to be added to the G column total. So G-E+F=G
|
| Cell Number Format includeing other Cell Value | 07 Apr 2008 00:55 GMT | 8 |
I needed to create some conditional number format - to say so... My goal: Cell A1 content is "m2" as I Enter in cell A2: "10" -> the output to cell A2 should be "10
|
| If Formula Question | 06 Apr 2008 23:09 GMT | 5 |
I am struggling with what appears to be an easy formula. Here is what I am trying to do: If the values of cell vale of B4 begins with either 20 or 30 then the (B20*0.5)
|
| conditionned formatting: max. number of rules | 06 Apr 2008 22:37 GMT | 2 |
In Excel 2003, the max. number of rules for conditionned formatting of the same array seems to be limited to 3. Or is there a way to extend it? In contrast, in Excel 2007, I could create 9 rules so far. What will be the maximum number here? Thanks, Sven
|
| Row Deletion Question | 06 Apr 2008 22:27 GMT | 2 |
I have a file with over 3 thousand line items. What I am trying to do is delete an entire row based off an entry in column L. Example Location Customer number CA 23432
|
| leave a cell blank | 06 Apr 2008 22:16 GMT | 2 |
My spreadsheet serves 2 purposes. Printed and manually filled out plus data entry. The cells with formulas show a 0 (zero) if the referenced cells are empty. The problem is the user has the option to ignore the formula and hard code a
|
| Excel 2007 bug? can't add my color to current sheet | 06 Apr 2008 21:44 GMT | 3 |
I do address formatting for property management- I need specific colors to show on my working sheet-yet when I add the colors- I can't see them. they only show up if I check preprint- I need to see them now. Is this a bug or what..It will not show up, how do I get this in. I'm ...
|
| Move cell data to another worksheet cell automatically. | 06 Apr 2008 20:05 GMT | 3 |
I have a sum formula in block F3 of a worksheet called Furlong. It is his total season bowling pinfall. I want the program to automatically transfer this total, each time it is updated, to his team record on a worksheet called Score in block C4. Both worksheets are in the same ...
|
| open corruped Excel File | 06 Apr 2008 18:18 GMT | 1 |
I am using one excel file, but it is corrupted now and its not opening. how to open that file. shahzad
|
| Problem with cell size | 06 Apr 2008 17:21 GMT | 5 |
I have Excel 2002, I am trying to set my cell size to 15 x 15, when I select Row Height 15 I get the required height but when I select column width 15 I get a much wider result, the cells are not square. What am I doing wrong?
|
| Autoincrementing dates | 06 Apr 2008 17:02 GMT | 5 |
I have a column formatted as "Date" with format March-01, etc. If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried A1+1 but the syntax is not understood by Excel 2003. Many thanks.
|
| open a PDF document from excel workbook | 06 Apr 2008 15:28 GMT | 2 |
I want to open a PDF document from excel. How do i do it? eg. i have a word that is hyperlinked to the PDF doc. when one clicks on the word...the PDF document will open up. Plz help
|
| Excel 2007 does not open XLS files by double click | 06 Apr 2008 15:18 GMT | 3 |
Suite: Office 2007 Home and Student Italian version Product: Excel 2007
|
| analizing a sheet | 06 Apr 2008 12:56 GMT | 6 |
I have a sheet of my phone usage. i have a cullom of the country I call,the number i phoned, the time the call took, the price I pay/ I need to fined out
1. How much time and what % for each country.
|
| How do I Sort Multiple Columns Together? | 06 Apr 2008 11:40 GMT | 3 |
I've got a list of data. Each row has a particular part number, its importance and other columns. How do I sort things by importance, so that I end up with all the most important rows at the top? Currently, I tried using the sort function, but it just rearranges the importance
|