Fill in all the blanks

Please purchase the course before starting the lesson.

When you get reports, you sometimes need to ‘fix’ them so that you have no blanks and each line has all the information. Below a report, but we need to fill in the blanks i.e. London should appear in A3 to A7. We could spend all day copy and pasting each one down or else we can use the GOTO Special tool.

GoTo Special

See below, all the blank cells are told to look at the cell above it and you have the blanks filled in.

GoTo Special

To see the full course contents click here.

Back to: Intermediate Excel Course > The Specials- GOTO and Paste