Is there a way I can select all the cells in the table and turn them all into
array equations in one swoop?

No, there isn't. If you select multiple cells, then press CTRL+SHIFT+ENTER,
you should be dealing with a SINGLE array formula that returns MULTIPLE
RESULTS which are to be returned to the selected cells.

I can drag equations with relative refences, but I loose the array
portion of the equation.

You are doing something incorrectly. In the situation you desecribe, I can
drag the fill handle, or select all the cells and use Edit/Fill, and the
result is array formulas in all of the destination cells. This is with Excel
XP (2002). What is it that you are doing differently?

On Sat, 22 Jan 2005 10:25:01 -0800, "OkieViking"
wrote:

I am working with a table in which each cell contains an array equation.
Whenever I need to make a change, it turns into a major hassle. I then
have to go through each cell and hit "shift+ctrl+enter" to
turn it back into an array equation.