Hi benishiryo, many thanks for your reply. I am unsure where to put this formula, do you mean in the page setup, print area box? I am unfamiliar with the Ctrl + F3. I have tried the top formula with no success. My data entry starts in row 16 and ends 9999 so would formula be? :

=OFFSET($B$16,0,0,COUNT(B16:B9999),20)

Just for my reference, what does the '20' at the end refer to?