Match Rows of a Spreadsheet in Excel

Asked By 0 points N/A Posted on -
qa-featured

In Excel, I want to redo the matching rows (Rows A to C) in a spreadsheet imprinting any sheet of the workbook. Also, whenever I try to do that, I am unable to choose different sheets at the same time. I also tried selecting all the sheets and tried printing them but still no luck. It appears that this is a “sheet only property.” Is there any other ways aside from this? I’d be grateful to those who can help.

SHARE
Answered By 0 points N/A #114182

Match Rows of a Spreadsheet in Excel

qa-featured

 

1.       Go to File then Page Setup and click on the Sheet tab.

2.       In the Rows to repeat at top, type a value or you can click on the icon at the right of each area box and select the rows.

3.       Click the Collapse dialog button again to come back to the Sheet dialog, and hit OK.

4.       The keyboard shortcut  F4 key Repeats the last worksheet action otherwise go to Edit > Repeat)

Login/Register to Answer

Related Questions