Here we have the option of creating a new list, using an existing one, or choosing a list from our Outlook Contacts.
Let's learn how to create a data list.Ĭlick the button on the far left side of the Catalog Tools Format tab called the Add List button. They will remain this way until you create or select a data list.Īs we mentioned at the beginning of the article, you can either create a list or import a list for a catalog. If this is the first time you've used catalog pages in the current publication, most of the buttons will be greyed out and inactive. This will open the Catalog Tools Format tab, as illustrated below. Click the Catalog Pages button in the Pages group. Next, go to the Insert tab in the Ribbon. If you want to follow along while we create our catalog, go ahead and open a blank template.
When we finish, Publisher will automatically take all of the information in the product list, and insert it into our template, creating eight individual pages with three products on each page. We are going to show you the easy way in this article. The easy way is going to be compiling the product list, then creating a single template using the Catalog tools. There are two ways we can do this. There is the hard way, in which we would design eight separate pages and manually enter everything using the techniques learned. We will put three items on each page of our publication so that we have room for the price, pictures, and description. In this article, we're going to show you how to create a catalog by creating one of our own. For our catalog, we are going to pretend we're a retailer with 12 high-quality hair care products for which we need to create a catalog. If you wish to import a list of items, you will import an Excel spreadsheet. You can create catalogs using Publisher by either creating a list of items to add to the catalog – or by importing a list of items into Publisher.
You can remove the reference to take your changes back.A catalog is defined as a list of items. From now on, every printed page will start with header row. If you want to repeat a column or columns, use the Columns to repeat at left option.Ĭlick OK to save your settings. In the example below, we set Rows to repeat at top to 2 nd row to repeat. For example, to print the header row on each page, click the button and select the header row reference. Regardless of how you get to this step, you will need to be on the Sheet tab in the Page Setup dialog.Ĭlick the reference selector icon corresponding to the heading type you want to be repeated. You will see two reference inputs under the Print titles section. Once the dialog is open, go to the Sheet tab. You can find the link at the end of the Settings section. On the Print window, click the Page Setup link to open the Page Setup dialog. Follow the File > Print path in the Ribbon.You can access the Print page using one the following: First, open the Print page and go to the Page Setup window. The other option is a little longer than the Ribbon approach. This menu contains the options to print header row in Excel to repeat on every printed page.
Then, click on the Print Titles icon to open the Page Setup dialog. When working on your workbook, begin by going into the Page Layout tab in the Ribbon. Let's see these two methods more in detail. From the Print window, just before printing.There are 2 ways to open the Page Setup window. You need to activate this feature from the Page Setup options. In this article, we are going to show you how to print header row in Excel to repeat on every printed page in Excel 2016, Excel 2013, Excel 2010 and Excel 2007.īy default, Excel does not print the headings of tables. If your worksheet contains multiple pages, you will see header rows or columns only printed in the first page by default.