copy formula horizontally

  1. S

    copying formula horizontally so column reference changes

    HI there, I actuall y have two problems here 1) in a cell A1 ive got this reference ='A4115'!C16 (where A4115 is a worksheet name), when a copy and paste this into cells A2 and A3 and so on the column C in the formula changes to D, and then E, how do I change this so that the number changes...

Some videos you may like

This Week's Hot Topics