adding a table in a sheet

[hau]

Hi all,

How can I add a table in worksheet?
How can I specify the "Rows input cells" and "column input
cells" in a sheet?

Regards

 

[JulieD]

Hi Hau
to answer your question
if you have the following (very simplistic example)
A
1 1000
2 100
3 =A1/A2

and you want to find out what the result would be if you had different
numbers in A1 and A2, so somewhere else on your worksheet say D1 type =A3
and press enter, now set out the rest as so:

D E F G
1 500 1000 1500
2 50
3 100
4 150

now click in D1 and then drag to G4 (this is the table area) and from the
menu choose Data / Table - your row input reference is A1 (because that
relates to the values in E1, F1, & G1) and the column input reference is A2,
because that relates to the values in D2, D3, D4

Click OK and the "result" of what would happen if you substituted these
numbers in your original formula will be displayed - as you can see cell F3
displays the result of your original calculation (which is always a good
check).

Hope this helps

Cheers
JulieD

 

[BrianB]

To make a worksheet table just type column headings across row 1 - i
you do not leave any spaces Excel will recognise the table. you ca
then type data underneath.

specify the "Rows input cells" and "column input cells"

You do not need to. In some cases (where you have blank cells in
table) Excel might get it wrong, when you will need to select th
table