Archive for April, 2009

CREATING AND SAVING NEW STYLES IN OPENOFFICE WRITER

Monday, April 13th, 2009

As in MS Word, you can create your own styles, both character styles and paragraph styles. There is another type of style that you can create in Oo Writer, which is the frame style, that controls objects like graphics, frames, etc., but we will cover that in another article at a later date.

Just like in MS Word, paragraph styles affect indentation, spacing, font, and font size and apply to the entire paragraph. Character styles affect the size and color of individual characters.

Creating a new style in Oo Writer is just formatting within the Styles and Formatting window.

Follow the steps below:

  1. Select your text.
  2. Choose Format | Styles and Formatting to display the Styles and Formatting window.
  3. Click the appropriate icon at the top for the type of style you wish to create. Right-click in the blank part of the window and choose New.
  4. In the Style window, name your style and specify your other formatting options.
  5. Click OK to close the window and save your style.

You can modify your style much like you do in MS Word – simply select the style and choose Modify.

Yet again, these two programs are not all that different from one another except OpenOffice is FREE.

Move to the End of a Long Column in MS Excel Quickly

Monday, April 6th, 2009

This is one of those little tips that most folks aren’t aware of but are ever so grateful for the knowledge once they have learned it. Why??? Because it saves time and keystrokes of course!

To jump to the bottom of a very long column, simply select a cell in the column and double-click the top or bottom edge of the cell.

In a nanosecond you will be at the bottom of the data in that column, regardless of whether its 12,000 rows long!

To return to the top of your data, click the edge of the cell. Clicking the left or right edge of the cell works in the same manner for going across rows.

Now aren’t you glad I shared that with you? Just think what else you could learn if you were a Premium subscriber!