Exceljet

Quick, clean, and to the point

Extend selection right one screen

Windows shortcut 
AltShiftPgDn
Mac shortcut 
Fn

Extends the current selection one screen to the right.

Note: this shortcut is unusual on a Mac because the Command key is required (Option doesn't work), even on Macs with Page Up / Page down keys.

What can I say. It has worked brilliantly. Thank you so much for your help. - Tracey
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course