O'Reilly logo

Learn OpenOffice.org Spreadsheet Macro Programming by Dr. Mark Alexander Bain

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Formatting Cells and Ranges of Cells

If you want to format a cell (or a range of cells) manually, then you select the cells with the mouse and then click on Format | Cell...:

You may prefer to assign a style to the cell, this time using Format | Styles and Formatting (or by pressing F11):

We, of course, don't want to use either of those; we want the macro to do all of the work for us.

You may want to change individual settings: for example, the font face, the font size, the background, or you may want to add an underline or any other of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required