Microsoft Tip of the Week Excel: Repeat Rows At Top

Microsoft Tip of the Week Excel: Rows to Repeat at the Top

Sometimes it is necessary to have the column headers to print on every Excel Spreadsheet. This can be done using the Rows to repeat at the top option found on the Page Layout Ribbon.

Click on the Page Layout Ribbon and locate the Sheet Options launch arrow.

A new Page Setup box will appear.
Click on the small box next to the Rows to repeat at top. A new Page Setup-Rows to repeat at top box will appear requesting which rows you would like to repeat.
You can click on the row number to highlight the area or highlight manually using your mouse.


Once you have the correct information entered, click on the box again to return to your Page Setup box.
Click OK to secure your task and return to your spreadsheet.

Microsoft Tip of the Week Word: Adding a Text Box

Microsoft Office 2007: Tip of the Week
The Insert Ribbon: Adding a Text Box
The Insert Ribbon Groups include Pages, Tables, Illustrations, Links, Headers & Footers, Text, and Symbols.
One of the upgrades to 2007 includes additional options for the Text Box.

There are total of 36 styles to select from. You can change the size, shape, and color of each box using the formatting Ribbon that appears after you insert the text box.


Give it a try:
Open your word document
Click on the Insert Ribbon
Click on Text Box in the Text group
Select Mod Quote
Change the color to Red using the Text Box Styles Group then Shape Fill or the shortcut colors option
Change the shape to a happy smile face.

Microsoft Tip of the Week Excel: Using Text Orientation and Wrap Text

Excel

Using Word Wrap and Text Orientation on the Alignment Section:

When you need your text to wrap within a fixed width of a cell use the Wrap Text option on the Alignment Section
Click on the Cell(s), and then click on Wrap Text
Give it a try:
Type “Joe Doe is a Waiter.” in cell A1.
Click out of the cell and then click on the cell again.

Click on Wrap Text

Using the Text Orientation for text orientation within a cell:

Click on the cell(s) that you would like to change the orientation. Click on the Text Orientation button on the Alignment Section of the Home Ribbon.
Select the option you need from the menu.

Microsoft Tip of the Week: Make a Cover Page for your documents:

Click on the Insert Ribbon, and then click on the Cover Page button. You will get Cover Page options to select. Click on the cover page you would like to appear, and then fill in the necessary information.