How to Repeat specific rows or column on every printed page in excel

Premier Solution
Premier Solution
13.1 هزار بار بازدید - 8 سال پیش - This video shows how to
This video shows how to make a top row of the excel sheet repeated in every page while printing

Click the page setup
then click  "Page Layout" tab
click the "Print Titles" option.
With the "Sheet" tab selected, next to "Rows to repeat at top," click the icon that looks like a spreadsheet.
Click and select the row you wish to appear at the top of every page.
Press the [Enter] key, then click [OK].

~-~~-~~~-~~-~
Please watch: "How to get total in various tables in Excel Easily @PremierSolution"
Effortlessly Sum Up Data In Multiple ...
~-~~-~~~-~~-~
8 سال پیش در تاریخ 1395/05/09 منتشر شده است.
13,102 بـار بازدید شده
... بیشتر