Apply Heading Styles in Word using the Keyboard

by rhyttinen on March 11, 2010

Rather than using the Ribbon to apply a heading style to your text, you can accomplish the same thing using keyboard shortcuts. This can be a time-saver if you work with multiple styles. Plus you can apply heading styles to your text regardless of what Ribbon is active.

To apply a Normal Style, press the Ctrl + Shift + N keystroke combination.

To apply a Heading 1 Style, press the Ctrl + Alt + 1 keystroke combination.

To apply a Heading 2 Style, press the Ctrl + Alt + 2 keystroke combination.

To apply a Heading 3 Style, press the Ctrl + Alt + 3 keystroke combination.

{ 0 comments }

Change Ruler Preferences in Word 2007

by rhyttinen on March 10, 2010

By default, Word displays ruler measurement in inches. This may not be what you want however – or, you may need change ruler measurement depending on the type of document on which you are working. Other options include: inches, centimeters, millimeters, points and picas.

If your ruler is not visible, click the Ruler checkbox in the Show/Hide group of the View Ribbon.

To Change Ruler Preferences in Word

  1. Click the Microsoft Office Button
  2. Click Word Options.
  3. In the left pane, click Advanced
  4. Scroll downward until you see the Display heading.
  5. Click the “Show measurements in units of” drop-down list.
  6. Choose the desired measurement.

Change Ruler Preferences in Word

If your ruler is not visible:

  1. Click the View tab on the Ribbon.
  2. Click the Ruler checkbox in the Show/Hide group

Applies to Word 2007

{ 0 comments }

Quickly Resize Columns in Excel

March 9, 2010

Many people don’t know that you can quickly resize columns in Excel with just a click of the mouse to accommodate the largest cell entry. Just position your mouse pointer over the right border of the column header and double-click.
This trick also works with multiple columns. Select the columns you wish to resize and double-click [...]

Read the full article →

Adding space between right-aligned text and border in Excel

March 8, 2010

When applying a right-aligned format to column labels in Excel, the text ends up being squeezed right against the borders, which does not make for easy reading. To fix this problem, you can add easily add some space between the border and your text.
To add a space between right-aligned text and border:

Click the Home tab [...]

Read the full article →

Sorting Data in an Excel Table

February 25, 2010

Once you have entered data into a table, you can reorganize it in alphabetical or numerical order. For example, you may want to sort a list of customers alphabetically by last name or numerically by sales. Excel allows you to sort by in either ascending (A to Z for alphabetical data, smallest to largest for [...]

Read the full article →

Totaling Data in an Excel Table

February 24, 2010

You can quickly total data in a table using the new Total Row feature on the Table Styles Options group of the contextual Design Ribbon. Clicking the Total Row check box will add a new row at the end of the table, with the word Total in the leftmost cell. Clicking in any of the [...]

Read the full article →

Creating a Table in Excel

February 23, 2010

In Excel, an organized, related consecutive collection of data in rows and columns is called a Table (referred to in previous versions of Excel as “Lists”). Entering your data in table format allows you to easily sort, analyze, format and manage your data later.
Excel uses column labels in the first row of your table. If [...]

Read the full article →

Applying Quick Styles to a PowerPoint Table

February 18, 2010

PowerPoint includes several quick table styles that you can add to your table. These table formats include preset colors and border styles that you can instantly apply to an existing table. Under the contextual Design tab under the Tables tab, you will see several preset Table Style thumbnails displayed on the Ribbon. Move your mouse [...]

Read the full article →

Using Word as a Blog Editor

February 17, 2010

Did you know that you can use Microsoft Word as a blog editor? Word actually has a powerful blogging feature that allows you to publish your blog posts directly to your site. Additionally, blogging with Word allows you to use the options on the Word blogging Ribbon: WordArt, Symbols, SmartArt, Shapes, ClipArt, SpellChecker and more. [...]

Read the full article →

Inserting a Table into an Existing PowerPoint Slide

February 16, 2010

In yesterday’s post, we saw how to insert a table into a new PowerPoint slide. Of course, you can easily insert a table into an existing slide as well.

To Insert a Table on an Existing Slide Layout

Click the Table button on the Insert Ribbon.
Click Insert Table on the menu.
Enter the number of rows and columns [...]

Read the full article →