Make First 2 Columns Appear on Every Printed Page (2003)

Topic

New Reply

Is there an easy way (other than copy/paste and fit) to have the first two columns of a fairly large spreadsheet appear on every printed page as the first two columns of those pages? The first two columns contain the identification data for the reports and it would be a lot easier to read if that ID data were on every page similar to how Headers & Footers would look but on the left side instead.
Thank You

Reply | Quote

Replies

File | Page Setup | Sheet tab | Columns to repeat at left
(use “Rows to repeat at top” for page headers).

Reply | Quote

Thank you Dean.

Reply | Quote