GoTo Special Examples

GOTO Special Ex 1

To follow along go to 5.5.1

Using the Go To Special feature, identify the cells that are conditional formatted and data validation.

Highlight D13- K13 and identify which cell has a different formula (Inputs and Calculations)

Identify all the constants in this sheet – Colour them light blue.

Solution

Fill in Gaps Ex 1

To follow along go to 5.6.1

We need to fill in the gaps in column A so that it always contain the sales sector (Government or Private). Use GOTO special

Solution

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