Skip to main content

Posts

Showing posts with the label How to Print Headers on Every Page

How to Print Headings on Every Page in Excel?

Sometimes you may need to print same column headers on every page in Microsoft Excel. And to do so, you don't need to manually copy the headers on every page. You can simply set a command from page setup option to print column headers on every page automatically!  In my previous post, I discussed about how to lock or freeze column headers . By freezing rows or columns, you can just show headers at the time of scrolling. But they will be printed on the first page only.  In this tutorial, you will learn - how to print same column headers on every page automatically .  .  . Applies to: MS Excel 2000/ XP MS Excel 2007/ 2010/ 2013 Note: This tutorial has been prepared using Excel 2013. So, few options may differ slightly. Let's start -  Open a previously saved worksheet or create a new one in MS Excel. Go to the Page Setup option from Page Layout Tab (Office XP/ 2000 users should find it under Edit Menu). Go to the Sheet tab...