Excel: Sounds Good (Page 1) 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

Split the Spreadsheet In the next examples, the conditional formulas will be added to the bottom rows in the sample spreadsheet. As you scroll down to the right place, you may lose sight of the labels in Row 1. There is a method to split the Window so you can work more effectively.   Try This: Split the Window 1. Identify the Tool Look at the scroll bar on the right side of the spreadsheet. There is a small rectangle above the Up Arrow. This is the Window frame. You can use it to split the spreadsheet into two identical copies of the same sheet.   2. Use the Tool Run your mouse over the Split until you see a double arrow. Drag the Split down a couple of rows.

View -> Split