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 Calc 3.x Guide
Previous Page Home Next Page

Applying cell styles

Calc provides several ways to apply cell styles:

  • Using the Styles and Formatting window
  • Using Fill Format mode
  • Using the Apply Style list
  • Assigning styles to shortcut keys

Using the Styles and Formatting window

  1. Ensure the Styles and Formatting window is open by pressing F11 or by selecting Format > Styles and Formatting. Choose the Cell Styles list by clicking the Image:CellStylesIcon.png icon.
  2. Highlight the cell or group of cells to which the styles should be applied.
  3. Double-click on the cell style name.

Using Fill Format mode

This method is quite useful when you need to apply the same style to many scattered cells.

  1. Open the Styles and Formatting window and select the style you want to apply.
  2. Click the Fill Format mode icon Image:FillFormatIcon.png. The mouse pointer changes to this icon.
  3. Position the moving icon on the cell to be styled and click the mouse button.
  4. To quit Fill Format mode, click the Fill Format mode icon again or press the Esc key.
Image:documentation_caution.png When this mode is active, a right-click anywhere in the document undoes the last Fill Format action. Be careful not to accidentally right-click and thus undo actions you want to keep.

Using the Apply Style list

You can also add an Apply Style drop-down list to the Formatting toolbar and select a style from the list to apply it to the selected cells:

  1. Click the down-arrow at the right-hand end of the Formatting toolbar. On the drop-down menu, click Visible Buttons.
  2. On the submenu, click Apply Style. The menus close and the Apply Style list now appears on the toolbar between the Styles and Formatting icon and the Font Name list.
Adding an Apply Style list to the Formatting toolbar.

Assigning styles to shortcut keys

You can create keyboard shortcuts to apply commonly-used cell or page styles, including custom styles that you have created. See Chapter 14 (Setting up and Customizing Calc) for instructions.


OpenOffice Calc 3.x Guide
Previous Page Home Next Page

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