{"id":9340,"date":"2022-04-08T13:06:58","date_gmt":"2022-04-08T13:06:58","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=9340"},"modified":"2024-03-28T13:49:29","modified_gmt":"2024-03-28T13:49:29","slug":"set-columns-to-repeat-at-left","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/set-columns-to-repeat-at-left\/","title":{"rendered":"Set Columns to Repeat at Left in Excel"},"content":{"rendered":"\n
When you use default Excel settings to print a multi-page Excel file that has row headers in the first column, readers will find it difficult to remember which information belongs to which row in the subsequent pages.<\/p>\n\n\n\n
To make it easy for your readers to follow which information belongs to which row, it is important to set the column that has row headers to repeat on the left side of each page. These repeating row headers are also known as print titles.<\/p>\n\n\n\n
When the print titles are set, the readers will be able to see which row headings or print titles apply to the information in the columns they see on the subsequent pages.<\/p>\n\n\n\n
In this tutorial, I will show you how to locate the Page Setup<\/strong> menu in the Page Layout<\/strong> tab and define the column that you want to be repeated on the left side of each page.<\/p>\n\n\n\n Follow these steps to add print titles or row headers to the left of each page of your Excel file.<\/p>\n\n\n\n\n