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.