headings

Including Headings into Worksheets

Heading presentations can be controlled by changing the font style, font size, font color, cell background color, and location of the heading on a worksheet.

To include a heading at the top of a worksheet:

select the row and column position for the heading
select the cells where the heading will be by putting the cursor in the start cell and drag the cursor to highlight the cells where the heading will go
select align center in the top task bar
(optional) select font style, size, font color in top task bar
row height will automatically change to accommodate large font size
click on the center cell of highlighted cells
type the heading in the format bar
click on any other cell to display heading in worksheet

Including Other Titles

Various types of titles can be included any where in a Worksheet. To create a box with a title:

select any cell where the title will go
make a row wider by putting the cursor on the row boundary, keep the left mouse button down and drag the mouse down to make the row as wide as required (see diagram below)
make a column wider by putting the cursor on the column boundary, keep the left mouse button down and drag the mouse down to make the column as wide as required drag the mouse (see diagram below)
the font size, font style, text alignment, and font color can be selected
as the title is typed in the Formula Bar it will display in the cell

To center, rotate or apply other properties to a title:

select 'Format' in top task bar
select 'Cells' and 'Format Cells' dialogue box will display
select 'middle' for vertical position of title in cell
title can be angled by rotating it
various other properties can be applied by selecting other tabs in 'Format Cells' display

Including Headings From Page to Page

When printing multiple worksheets and to ensure the top heading of the first worksheet is included on the top of every printed page do the following:

select 'File' in the top task bar
select "Page Setup' and 'Page Setup' box will display
select 'Sheet' tab
type in the row number(s) that include the titles wanted to printout on the top of every printed sheet
click 'OK'

Including New Rows and Columns in Worksheets

At times when working on a worksheet additional rows and columns have to be added. To add rows or columns do the following:

select 'Insert' in top Menu Bar
select 'Row' to add a row above the existing row
or
select 'Column' to add new column to the left of the existing column
row numbers and column names will adjust automatically when a new row(s) or column(s) is/are added

Deleting Rows and Columns in Worksheets

At times when working on a worksheet rows and columns have to be deleted. To delete rows or columns do the following:

to select a row to delete click on the row number (far left) the row will be highlighted
select 'Edit' in the top Menu Bar
select 'Delete' and click
row will be deleted and rows will renumber automatically
to select a column to delete click on the letter of the column (top of column)
select 'Edit' in the top Menu Bar
select 'Delete' and click
column will be deleted and other columns will rename automatically