Press F5 and in the box under reference enter A1:E30000 or if there is data
in every row select cell A1 and hold down Ctrl+Shift and press the down arrow
key and then the right arrow key and all continuous data will be slelected.

"Mike H." wrote:

What is the method of highlighting say from row 5 to row 30,000, and columns
1 - 5 where there is data?