I have a bunch of worksheet templates (about 40) sent out for people t
fill out. I am looking to consolidate the data in one master exce
worksheet. What is the best way to accomplish this? I have trie
linking sheets, but within the master sheet worksheet, I am usin

hey all, I'm having a problem and dont know exactly how to do this...
I have one column of data (2000 lines worth) all are numerical and all
are different, this is column A
in column B I have another list of numerical data, most of this data

Is it possible for have more than 3 conditional formatting? I have 4
criteria, High, Medium, Low and Complete. I was hoping to have a
different color for each criteria but was only able to get up to three.
Please help.

I'm running Excel2002 and have created a chart using several series of XY
Scatter data. The chart is working fine, but I do not like the order in
which the various groups of source data are listed within the Chart Legend.
They don't appear to be listed either alphabetical or ...

Om man har en timme och omvandlar den i procent så blir 1 timme 100%. Och så
ska man dela upp timmen i 5 minuters perioder så att varje fem minuter blir
0,08. Det vill säga att en kvart inte blir 15 min utan 0,25. Så att en
haltimme inte blir 30 min, utan det blir 0,50. Och 45 ...

We use right and left (custom) headers and footers that Excel places close
to the page edge.  Our proposal requirements say we must fit inside a 1 inch
margin.  How can we change how close to the edges the footers and headers
are placed with respect to the RIGHT and LEFT ...

Well thanks for this, it has opened up the whole new concept of array
formulas for me.  As a novice, however, I seem to be doing something
wrong.
I have carried out the follwing steps;

I'm hoping you guys can help me out. I have a basic formula in cell C2 I
want to copy the formula down in the cells below.
The problem is that when I click the small black box in the corner of
the cell to fill down the same number appears and not the result of the

How do I format cells in Excel to display different weights?

  I have an excel spread sheet that contains numerous zeros in cells.
I would like to replace the zeros with the words hi; however I do not
want to replace zeros in cells that are part of other numbers like
2.07.  I would like the cell that has the value 2.07 to remain 2.07 but

i'm totally new to excel and writing macros and code for it. i need to
create a file which will allow the users to click on the 11th column on
any row and select a value from the combobox that appears in that cell
on clicking.

How can I use the Print Preview function and make any necessary changes to my
worksheet?..I currently do not have a printer installed, but would still like
to be able to have access to the Print Preview functions before I actually
print my worksheet.

Can someone help with a small problem that I'm having. I'm trying to format
a group of cells so I can calculate hours of work , then multiply that by my
hourly wage. I'd like it to read so that I can add a list of hours and then
multiply it by the hour rate of pay. (I.E. 8.30 hr ...

When I have multiple worksheets open, it used to show the number of
open worksheets next to the icon in the task bar.  Now if I have any
number of books open it shows nothing and I have to close each one at a
time to find the right one or go to the Window options in Excel menu.

I need to have the values in these cells "splitted":
A1: Red 8 Y  48
A2: Magenta 2 Y  16
A3: Green     30