Wakelin Solutionz Pty Ltd

SPECIALISTS IN PERSONAL & ORGANISATIONAL PRODUCTIVITY

Phone: +61 421 551 254      Email:  wakelinsolutionz@bigpond.com

Select the visible cells on a worksheet (e.g. after using filter, or subtotals)

1. Highlight the visible data you want to select

2. Press F5 to bring up the GoTo dialog box

3. Click on Special

4. Click on Visible Cells Only and press OK

Excel Tips Index