The Style List window lists available
styles for you to apply to a cell or cell range. You can use this
window to apply, create, edit, add, and remove formatting styles.
To dock the Style List window, you can drag the
title bar to the left or to the right side of the workspace. To undock
the Style List window, press Ctrl, and then double-click
a free space in the Style List window, or directly
drag it out. The window can be docked or can float and be placed where
you want it.
To access the Style List window and
apply a style to a cell:
- Click or press F11 (Mac special use). You can also click the Style List icon
on the sidebar.
- Select the cell or cell range.
- Double-click the style element in the Style list.
- Style type
- Different style types for choice.
- Cell Styles
- Displays the list of the available Cell Styles for indirect cell formatting.
- Page Styles
- Displays the Page Styles available for indirect page formatting.
- Apply
- Allows you to assign a style to the current cell or cell range.
- New...
- Creates a new style based on the formatting of the current selection.
You can also click the dropdown to choose New Style from
Selection from the submenu.
- Modify...
- Modifies the selected style. You can also click the downward pointing
arrow to choose Update Style from Selection from
the submenu.
- Fill Style
- Applies the selected style to the selected cell or cell range.
Click this icon, and then drag a selection in the spreadsheet to apply
the style. To exit this mode, click the icon again, or press Esc.
- Load Style
- Opens the Load Styles dialog to import styles from another spreadsheets
or documents.
Note: You can undo changes to style attributes by pressing
Ctrl+Z. You can redo changes to style attributes by pressing Ctrl+Y.