Question: A worksheet contains over 4 0 0 rows. The first 1 0 rows contain input data, and functions containing summary statistics are in the last
A worksheet contains over rows. The first rows contain input data, and functions containing summary statistics are in the last rows. What is the most efficient method to see the input area and summary statistics at the same time without having to scroll back and forth between sections? point
Use the Split command and adjust one pane to see the input section and another pane to see the summary statistics.
Open multiple windows of the same workbook and use the Arrange Windows command to tile the windows.
Select the summary statistics and use the Freeze Panes option.
Display a Watch Window for the input section as you view the summary statistics section.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
