• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiplication Table with minimal typing

Hui

Excel Ninja
Staff member
Select P2:AA13
=ROW(1:12)*COLUMN(A1:L1) Ctrl+Shift+Enter

or
=(ROW(2:13)-1)*(COLUMN(P1:AA1)-15) Ctrl+Shift+Enter
 

NARAYANK991

Excel Ninja
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
 
Top