Splitting the Screen

Apache OpenOffice 4.1 Calc Guide

Chapter 1: Introducing Calc

< Previous Section

Next Section >

• What is Calc?
• Spreadsheets, Sheets, and Cells
• Parts of the Main Calc Window
  • Menu Bar
  • Toolbars
    • Displaying or Hiding Toolbars
    • Palettes and Tear-off Toolbars
    • Moving Toolbars
    • Docking/Floating Windows and Toolbars
    • Customizing Toolbars
    • Formatting Toolbar
  • Formula Bar
  • Sidebar
  • Right-click (Context) Menus
  • Individual Cells
  • Sheet Tabs
  • Status Bar
• Starting New Spreadsheets
  • Starting a New Document from a Template
• Opening Existing Spreadsheets
• Opening CSV Files
• Saving Spreadsheets
  • Saving as a Microsoft Excel Document
  • Saving as a CSV File
  • Saving in Other Formats
• Password Protection
• Navigating within Spreadsheets
  • Going to a Particular Cell
  • Moving from Cell to Cell
    • Customizing the Effects of the Enter Key
  • Moving from Sheet to Sheet
• Selecting Items in a Sheet or Spreadsheet
  • Selecting Cells
  • Selecting Columns and Rows
  • Selecting Sheets
• Working with Columns and Rows
  • Inserting Columns and Rows
  • Deleting Columns and Rows
• Working with Sheets
  • Inserting New Sheets
  • Deleting Sheets
  • Renaming Sheets
• Viewing Calc
  • Using Zoom
  • Freezing Rows and Columns
  • Splitting the Screen
    • Splitting the Screen Horizontally
    • Splitting the Screen Vertically
    • Removing Split Views
• Using the Navigator
  • Moving Quickly through a Document
  • Choosing a Drag Mode
• Using Document Properties

< Previous Page

Next Page >

Splitting the Screen

Figure 28: Split screen example

Another way to change the view is by splitting the screen. A screen can be split horizontally, vertically, or both. You can therefore have up to four portions of the spreadsheet in view at any one time.

For example, let's say you're working with a large spreadsheet, one of whose cells contains a number that is used by three formulas in other cells. Splitting the screen allows you to position the cell containing the number in one section, and each of the cells with formulas in the other sections.

That then allows you to change the value in the cell, and observe how it affects each formula.