How do I sort an Excel worksheet containing merged cells?

Hi All I have been asked to model cashflows for a company for 30 years monthly (i.e. 360 data calculation cells). The calculations are complicated and cannot...

Hi, I'm currently using Excel 2003 to do some actuarial work. I notice that when I generate a large number of random numbers(say 10000) and run the spreadsheet...

Hi all, I'm doing some IT coursework and have a macro that creates a chart from some data in a worksheet. All works well until you run the macro again - now...

I would like when I enter a negative number in a cell to automatically be red. Is there anyway I can do that?

In a workbook with a large number of worksheets and lookup formulae I have encountered a new problem. In the past I've seen the problem where 'Calculate' is...

Okay, this is insanse. Have a spreadsheet where I input data into one cell, a calculation based on that data is run via vb macro, and then a single column of...

I need to extend the conditional formating from a range of three cells to the whole document. The issue is that for each group of three cells, I need...

I help with a food pantry and the existing cliant data list was created in word seperated by commas. I am told to put all 1500 or so cliants in to note pad,...

The page break generates the "PAGE 1, PAGE 2", ect., as big, grey letters in the middle of the page. How can I change the look and placement of them. I find...

I'm new to macros and excel........ I have several excel spreadsheets that I need to filter daily. I would like to create a macro that can segment the...

Is it possible to select a group of data on a graph/cross-plot and then ZOOM to or HIGHLIGHT that data in the spreadsheet? I hope it's possible and I am just...

I am having problem with the new excel 2003. I have a total sheet that I use totals from other workbooks. I use the = sign that I pick the cell I want from...

Using Excel 2000, Windows98se & HP Deskjet 5550 printer. Using symbols from the symbol.ttf font on the spreadsheet: I can see them in the cells as well as in...

How can I get that key stroke to move a whole page at time with that key? Thank you, Arturo

I have a working SUMPRODUCT formula {=SUMPRODUCT(($C$4:$C$4341=z8)*(audittypefm1="Standard"))} that I need to change the 1st array to C5623. When I do I get a...

How many worksheets can you have in one workbook. Right now we're doing a file for all weeks of the year and we've got 30 in it, but it won't allow us to...

I use a spreadsheet for taking orders on the phone. The spreadsheet has all of the items we carry listed on it. At the end of the sale I have to delete the...

Addendum to Previous post: I realized I omitted one crucial element from my previous post: I want the fractional data label to be a non-simplified...

We have spreadsheets on our intranet Sharepoint Team Sites. If a user opens one of those spreadsheets from the intranet with Internet Explorer, closes the...