Match Rows of a Spreadsheet in Excel

Asked By Julie Montes 0 points N/A Posted on - 01/05/2012

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.

• Status: Open
• Question Views: 1167
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Miche Janet 0 points N/A #114182

Match Rows of a Spreadsheet in Excel

 

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)

About Miche Janet

Questions
2

Answers
31

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 01/09/2012
• Question Category: MS Excel