i have data in a column, with data of share prices from 2nd june to 5th may, but i want the data to be inverted so stock prices of 5th june appear at the top...

Greetings all, This should be easy, but for the life of me I can't come up with the formula solution myself. I would like to truncate some text characters...

i have recently purchased microsoft office 2007. I have noticed that when I am working on files and saving them that I sometimes see a blue square symbol...

When I print preview it shows that it will print correct and then when printed it has a space in between letters. Example: Area Chamber of Commerce prints as...

Hi, I created a chart and put it where I want. Later when I went to Print Preview (PP), it would appear (and print) smaller, and up and to the left. I...

I have a big list of names that i need to replace for numbers .... is there any way to do this in excel? example: Eduardo Gomez 3382736 46639...

I have numbers in cells I2:I20, cell I21 is blank and then more numbers in cells I22:I30 and I31 is blank. This will repeat down the sheet. I would like a...

I have a spreadsheet that I am working on in Excel 2007 but in compatibility mode. Problem is that when I open it in 2003 the colors are all different and it...

Hello, I'm getting confused by how Excel is screwing this up. I have a list of data, for example: Score Name 5 John 2 Paul 6 Luke The table is pulled...

Hello, I understand how conditional formatting works but can't seem to figure out a formula - will you please help? What formula would I use in order to...

I've created a button to save a file with a name created from a cell, but I need to be able to save it to a particular location which is other than the...

I can see IV 65536 is the end cell when I press CNTRL END I have tried removing lines and columns then saving and recalling the file. The problem is when I...

Somehow the header bar of a spreadsheet has got "stuck" "under" the menu/ toolbar at the top. So I can't move the spreadsheet. Any suggestions would be very...

What is the formula to count "pending" issues (cells K2 thru K3015) that were supposed to be resolved by "1/15/2009" (cells H2 thru H3015)? K2:K3015 =...

I want to reference a particular cell (call it N1018) from within an array contained in a formula so that the starting row for the array is determined by the...

i have to fill sheet row wise. data related to certain column are important to fill (say C,D,F & K column) i want to do following things as i start filling...

Excel 2003 I'm making an organizational chart but as I add boxes, the other boxes get smaller and so does the font. If I click on them and try to drag them to...

Is it possible to change in an entire sheet at one time any double line border (right, left, top, or bottom) with a single line border?

Hi, does anyone know how this is possible? Thanks

Dear All I would like to Print the Number to Text ... Examble If cell contains the value of : 5,11,22,000.55 : convert to " 5 Crore , 11 Lakhs , 22 Thousand...