how to create a table given data...

[aidenkun via OfficeKB.com]

hi everyone,

This might be an easy one but i dont understand the instructions that help
section gives me. I have some data (5X5) which i want to put into a table.
When i go to data and table command im not too sure what to put in the "Row
input cell" and "column input cell" part.
i thought it might correspond to the data where the rows are and the clums
are.but i keep on getting the "input cel reference is invalid".
any help is appreciated.

Cheers!

 

[Bob Sullivan]

Hello,

Are you trying to create a two variable (two column) data table, one that
shows the range of possibilities of a formula? Then make one value go down a
column, and make another value go across a row. Don't put the first row value
under the first column value.

 

[Debra Dalgleish]

There's a loan sample file on the Microsoft site that uses a table. It
might help you get started:

http://office.microsoft.com/en-us/assistance/HA010346401033.aspx

And instructions for creating a table here:

http://support.microsoft.com/kb/282851/EN-US/