• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Is the report you print out in Excel clear until you get to page 2?

by on
in Excel Training,Office Technology

Is the report you print out in Excel clear as day until you get to page 2? If the column titles were on all the pages, would that help? It’s easy to do.

On the Page Layout tab, under the Page Setup group, click the Print Titles button. This will put you on the Page Setup dialog box in the Sheet tab. Place your cursor in the “Rows to repeat at top:” field. Then click any field on the row that has the column titles, usually the first row. In the field, you’ll now see $1:$1. Click the Print Preview button to see the effect of your change.

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/36253/is-the-report-you-print-out-in-excel-clear-until-you-get-to-page-2 "

Leave a Comment