Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have Office - Student and Teacher Edition 2003
I am having trouble making a table ... I try to make a Data Table and try to define $E$3:$G$16 as the range in the row input cell area so I can make this a one-input data table and then I enter C$9$ for the column cell input area a pop up pops up saying that the input (row) cell reference is invalid I hope this not a bug that can only be fixed if you have the full version of the software any clues? |
#2
![]() |
|||
|
|||
![]()
it should be $C$9
Pumaman wrote in message ... I have Office - Student and Teacher Edition 2003 I am having trouble making a table ... I try to make a Data Table and try to define $E$3:$G$16 as the range in the row input cell area so I can make this a one-input data table and then I enter C$9$ for the column cell input area a pop up pops up saying that the input (row) cell reference is invalid I hope this not a bug that can only be fixed if you have the full version of the software any clues? |
#3
![]() |
|||
|
|||
![]()
Perhaps this recent post might help in getting
the hang of setting up a one variable data table: http://tinyurl.com/562dj -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Pumaman" wrote: I have Office - Student and Teacher Edition 2003 I am having trouble making a table ... I try to make a Data Table and try to define $E$3:$G$16 as the range in the row input cell area so I can make this a one-input data table and then I enter C$9$ for the column cell input area a pop up pops up saying that the input (row) cell reference is invalid I hope this not a bug that can only be fixed if you have the full version of the software any clues? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format spreadsheet so no input allowed if certain cell is =<0 | Excel Worksheet Functions | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |