Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get address of last cell in range in Excel
  • Lookup entire row in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to get relative row numbers in a range in Excel
  • How to use Excel OFFSET function

Data Analysis Examples

  • Create Scatter Chart in Excel
  • How to Create Gantt Chart in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Remove Duplicates Example in Excel
  • Error Bars in Excel

Data Validation Examples

  • Excel Data validation with conditional list
  • Excel Data validation require unique number
  • Data validation must not exist in list
  • Excel Data validation unique values only
  • Excel Data validation allow uppercase only

Split Worksheet Window in Excel

by

To view multiple distant parts on worksheet at once, you will need to split your worksheet. To split your worksheet (window) into an upper and lower part (pane), execute the following steps.

1. First, select a cell in column A.

2. On the View tab, in the Window group, click Split.

Worked Example:   How to Break Worksheets into Pages in Excel

3. Notice the two vertical scroll bars. For example, use the lower vertical scroll bar to move to row 49. As you can see, the first 6 rows remain visible.

4. To change the window layout, use the horizontal split bar that divides the panes.

Worked Example:   List worksheet index numbers in Excel

5. To remove the split, simply double click the split bar.

Note: in a similar way, you can split your window into a left and right pane by selecting a cell in row 1 before you click View, Split. You can even split your window into four panes by selecting a cell that is not column A or row 1. Any changes you make to one pane are immediately reflected in the other ones.

Worked Example:   Prevent invalid data entering in specific cells

Post navigation

Previous Post:

SUMIF function in Excel

Next Post:

Paste Special Operations in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to Remove Leading Spaces in Excel
  • How to find and replace multiple values at same time in Excel
  • PHONETIC function: Description, Usage, Syntax, Examples and Explanation
  • SEARCH, SEARCHB functions: Description, Usage, Syntax, Examples and Explanation
  • How to get top level domain (TLD) in Excel
  • Calculate date overlap in days in Excel
  • Assign points based on late time in Excel
  • Create date range from two dates in Excel
  • NETWORKDAYS function: Description, Usage, Syntax, Examples and Explanation
  • Display Date is workday in Excel
  • ODDLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • YIELDDISC function: Description, Usage, Syntax, Examples and Explanation
  • ODDFPRICE function: Description, Usage, Syntax, Examples and Explanation
  • PMT, RATE, NPER, PV and FV Financial Functions in Excel
  • Calculate interest rate for loan in Excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles