Trick Excel into Changing where Absolute references ($) look

Please purchase the course before starting the lesson.

You can use Excel’s CUT and PASTE (as opposed to COPY PASTE) to make exact copies of areas in a spreadsheet and avoid the risks highlighted elsewhere with regards using COPY PASTE. Watch the video clips to see how to do this.

To see the full course contents click here.

Back to: Advanced Excel Course > Formula Tips and Tricks