Excel help needed: Skipping cell without skipping cell reference
I copied and pasted the formula from one cell on the another cell (with skipping another cell, meaning like I copied and pasted formula from AA1 to AC1 for example). That formula is linked to a table containings cells as well (let's say the table has A,B,C,D etc column). what i wanted to happen was to copy and paste the formula to other cell (with a cell being skipped) without the cell reference embedded on the formula to change by one cell only (not two simply because i skipped one cell to move the formula to the next cell).
Please see attachment.
Thank you
|