XLPadawan Member May 24, 2016 #1 Fill in the empty multiplication table under the following constraints: only one cell can be filled using the keyboard all other cells must be filled using the mouse only Attachments Multiplication Table.xlsx 16.2 KB · Views: 37
Fill in the empty multiplication table under the following constraints: only one cell can be filled using the keyboard all other cells must be filled using the mouse only
Asheesh Excel Ninja May 24, 2016 #2 Hi, Is this what you are looking for Attachments Copy of Multiplication Table.xlsx 17.8 KB · Views: 50
Hui Excel Ninja Staff member May 25, 2016 #3 Select P2:AA13 =ROW(1:12)*COLUMN(A1:L1) Ctrl+Shift+Enter or =(ROW(2:13)-1)*(COLUMN(P1:AA1)-15) Ctrl+Shift+Enter
Select P2:AA13 =ROW(1:12)*COLUMN(A1:L1) Ctrl+Shift+Enter or =(ROW(2:13)-1)*(COLUMN(P1:AA1)-15) Ctrl+Shift+Enter
N NARAYANK991 Excel Ninja May 25, 2016 #4 Hi , If the real constraint is one of minimal typing , then what Asheesh has posted must be correct : 1. In cell P2 , type in =$O2*P$1 and press CTRL ENTER so that the cursor remains in the cell. 2. Drag the cell to the right using the mouse. 3. Drag the range down using the mouse. Of course , if the mouse is used for entering the cell references , that will reduce the typing even more. Narayan
Hi , If the real constraint is one of minimal typing , then what Asheesh has posted must be correct : 1. In cell P2 , type in =$O2*P$1 and press CTRL ENTER so that the cursor remains in the cell. 2. Drag the cell to the right using the mouse. 3. Drag the range down using the mouse. Of course , if the mouse is used for entering the cell references , that will reduce the typing even more. Narayan
XLPadawan Member Jun 2, 2016 #5 Asheesh said: Hi, Is this what you are looking for Click to expand... That's the way I did it, Asheesh.
Asheesh said: Hi, Is this what you are looking for Click to expand... That's the way I did it, Asheesh.