Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

OpenOffice 3.x Getting Started Guide
Previous Page Home Next Page

Selecting sheets

You can select either one or multiple sheets. It can be advantageous to select multiple sheets at times when you want to make changes to many sheets at once.

Single sheet

Click on the sheet tab for the sheet you want to select. The active sheet becomes white (see Figure 4).

Multiple contiguous sheets

To select multiple contiguous sheets:

  1. Click on the sheet tab for the first sheet.
  2. Move the mouse pointer over the last sheet tab.
  3. Hold down the Shift key and click on the sheet tab.

All the tabs between these two sheets will turn white. Any actions that you perform will now affect all highlighted sheets.

Multiple non contiguous sheets

To select multiple non contiguous sheets:

  1. Click on the sheet tab for the first sheet.
  2. Move the mouse pointer over the second sheet tab.
  3. Hold down the Control key and click on the sheet tab.
  4. Repeat as necessary.

The selected tabs will turn white. Any actions that you perform will now affect all highlighted sheets.

All sheets

Right-click over any one of the sheet tabs and select Select All Sheets from the popup menu.

Working with columns and rows


OpenOffice 3.x Getting Started Guide
Previous Page Home Next Page

 
 
  Published under the terms of the Creative Commons License Design by Interspire