| Thread | Last Post | Replies |
|
| Can't get update to work | 31 Jan 2009 22:40 GMT | 7 |
I am running Windows XP Home, and recently updated to SP3. The Windows updater is now trying to install the following update: Security Update for Microsoft Office Excel 2003 (KB951548) However, every time it tries, I just get the message, "Some updates could
|
| Field list in Pivot tables | 31 Jan 2009 22:07 GMT | 7 |
I have a problem with the field lists. I have a field for Year. How can I update the field list to include new year like 2009? Please help, Thanks
|
| How to automatically populate a cell? | 31 Jan 2009 21:02 GMT | 4 |
Is there a way to automatically populate a cell with the same data that is entered into a different cell? Say for example I have a 20 column wide spreadsheet. When I enter data into the cell at row 1, column 'A', I want that data to automatically be entered
|
| Smaller left indent ? | 31 Jan 2009 18:23 GMT | 3 |
When aligning text within a cell, a left indent of 1 is too large. In fact, it is often the equivalent of two character in the font of the cell. Is there anyway to specify and indent of 1/2 a character or some other way to reduce the left margin?
|
| Different colors within on cell. | 31 Jan 2009 17:01 GMT | 3 |
1 ; 45 ; 0 I want to change the color of each of the above numbers to bold green, 1, then bold black 45 and finally bold blue 0. Each number in the one cell is from the following formula: =TEXT(C4,0)&" ; "&TEXT(D4,0)&" ; "&TEXT(E4,0)
|
| If percentage is 10% when y or 0% when n | 31 Jan 2009 14:47 GMT | 6 |
I am trying to apply 10%tax when tax needs to be applied (i.e. when next to the item I have placed a y. If there is no tax to be added, (i.e. displayed by an n, then I want it to display 0%. I have placed the 10% tax amount in a cell on it's own, in this case B2,
|
| grid lines | 31 Jan 2009 13:18 GMT | 3 |
i come tables from the net and paste them into Word to format -- removing certain columns. when i paste the tables into excel, i get white spaces in the excel sheet around the information i've pasted in. no matter what i do, i cannot get the original excel grid lines back on ...
|
| How do i add data to the side of a line gragh | 31 Jan 2009 12:35 GMT | 1 |
I cant figure out how to add the data to the side of the graph.
|
| Filtering problem | 31 Jan 2009 06:17 GMT | 2 |
I have run into filtering problem I could use some help with. (using Excel 2003) I have 3 columns of data with about 40,000 rows. Based on a condition of one cell in the rows, a value of Yes or No is set in another column. (there are
|
| Adding a Percentage to a Number (EXCEL 2003) | 31 Jan 2009 05:56 GMT | 2 |
I think I did not explain myself very welll in my first question. I want to add a percentage like 10% to number in column A1 I want to show the total in column A4 - however the formula shows in the A4 field everytime I put my curser over it. I want to hide the formula and show
|
| Range referencing in VLOOKUP function, string concatenate? | 31 Jan 2009 05:36 GMT | 4 |
I am attempting to perform a vlookup in an array, located among a group of 21 other arrays. So, each array has a name beside it, but the arrays all contain Similar, and sometimes identical data. I first use a MATCH function to find the name and its location on the
|
| how to automatically populate a cell? | 31 Jan 2009 03:50 GMT | 1 |
Say I have a 20 column wide spread sheet- columns 'A' ~ 'T'. When I enter data into the cell at row 1 / column 'A', is there a way to have that data automatically populate the cell at row 1 / column 'T'? And if it can be done with cells, can it also be done with entire rows and
|
| Bug in Excel handling exponents | 31 Jan 2009 01:44 GMT | 7 |
If I type -10^6 in a cell, the resulting number is 1,000,000. However, shouldn't the exponent take precedence over the sign? Specifically, shouldn't the result be -1,000,000?
|
| Minus Zero | 31 Jan 2009 01:32 GMT | 11 |
I'm probably missing something obvious, but I have a worksheet where some cells are formatted for currency to two decimal places, with negative numbers showing in red with a leading 'minus' sign. The problem I have is that when the result is zero, the number is displayed
|
| I need to show the last number in a rows in the total pending row | 30 Jan 2009 22:30 GMT | 2 |
I have a column where I list pending cases each month and I need to show the last number in the total pending cell at the bottom of the row. I can use an offset fomula which works if the pending cases begin in row 1. However, I am not able to get it to work if the pending cases ...
|