If a worksheet spans more than one printed page, you can label data by adding row and column headings that will appear on each print page. These labels are also known as print titles. Follow these steps to add Print Titles to a worksheet: On the worksheet that you want to print, in the Page Layout tab, click Print Titles, in the Page Setup group). In order to repeat rows and columns on every page of the spreadsheet, you must click on the 'Print titles' button and once the dialogue box appears, go to the option titled 'rows to repeat at top'.
Print row and column headings. Click the sheet.
On the Page Layout tab, in the Sheet Options group, select the Print check box under Headings. On the File menu, click Print. You can see how your sheet will print in the preview pane.
Print row or column titles on every page. Click the sheet. On the Page Layout tab, in the Page Setup group, click Page Setup. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat. On the File menu, click Print. You can see how your sheet will print in the preview pane.
Tip: To minimize and expand the Page Setup dialog box so that you can see more of your sheet, click or next to the box that you clicked in. On the File menu, click Print. You can see how your sheet will print before you print it by clicking Preview. Print column titles on every page. Click the sheet.
On the Layout tab, under Print, click Repeat Titles. Under Print titles, click in the Rows to repeat at top box, and then on the sheet, select the row that contains the column titles.
Want to learn how to repeat row and column titles in Microsoft Excel? Follow this step by step tutorial and learn how to do so. Don't forget to check out our site for more free how-to videos! - our feed - join us on facebook - our group in Google+ Microsoft Excel provides its users with the benefit to present data in a spreadsheet form. If you want to repeat rows or certain columns in your excel file, Excel allows its user to customize the sheet as per his/her requirements.
Using Microsoft Excel allows one to arrange their data in an organized manner and also use a number of mathematical functions to carry out complex calculations. In this tutorial, we will teach you how to repeat row and column titles in Microsoft Excel.
![How to make a row print on every page in excel for mac mac How to make a row print on every page in excel for mac mac](/uploads/1/2/5/5/125574188/659486736.png)
Step 1: Inserting a Page Break First of all, open up a spreadsheet in Microsoft Excel. This spreadsheet should contain data which needs to be printed separately and should contain row and column titles. You must start off the process by separating the data and inserting page breaks in it. In order to print the salary slips for employees department wise, you will need to click on the first cell from where the next department begins.
Now, click on the 'page layout' tab and then click on the 'Breaks' button. You will be given two options; select the 'insert page break' option.
![How to make a row print on every page in excel for mac 2017 How to make a row print on every page in excel for mac 2017](/uploads/1/2/5/5/125574188/170044623.png)
Step 2: Using the 'F4' key If the list you are working on is very long, you can simply use the 'F4' key to repeat your last action. Since our last action was to insert a page break, hence using the 'F4' key will insert page breaks. Step 3: Previewing the print page Once you have inserted the page breaks, you can preview the final product by pressing the 'Ctrl+P' key.
Notice that the row or the column title does not appear on any page other than the first one. Step 4-Using the 'print titles' option In order to repeat rows and columns on every page of the spreadsheet, you must click on the 'Print titles' button and once the dialogue box appears, go to the option titled 'rows to repeat at top'. Now, select the rows which you want to repeat. Now click on the 'ok' button in order to proceed further. After completing the above steps, you will notice that the 'print preview' pane will display the rows that you created on every page of the sheet.