how to create a table given data...

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!

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.

--
Cordially,

Bob Sullivan
Microsoft Office Master Instructor


"aidenkun via OfficeKB.com" wrote:

> 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!
>

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/as...346401033.aspx

And instructions for creating a table here:

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

aidenkun via OfficeKB.com wrote:
> 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!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html