Why control columns and rows?The width of columns and the height of rows are controlled to enable data to fit into the cells.
To change the width of a column
Insert a HeadingOnce the desired width of a column is achieved, a heading can be included in the top cell of the column. NOTE: You type the text inside the cell. The text will also show in the 'Formula Bar'.
The heading text can be controlled:
Changing Row SizeChanging the height of any row is done in the same manner as changing column width.
Selecting areas of an Excel worksheetAny area of a worksheet can be selected. Put your cursor at one corner of the requried area, hold the left mouse button down, drag the cursor to highlight area required, release mouse button. The selected area is highlighted. Once an area is highlighted, all this area can have certain format features you may want to apply to all the cells included in the area.
Features such as:
Applying Grid Lines to CellsAlthough an Excel worksheet displays grid lines on the monitor, these grid lines will not print unless borders are applied to the cells. Grid lines can be applied in various ways. Grid lines can be applied to all sides of an area, only to the bottom of an area, only to the top of an area, only vertical lines to be shown, or only horizontal grid lines showing. Prior to printing out any worksheet select: File - 'Print Preview' to ensure the worksheet will print the grid pattern defining the cells the way you need.
To apply grid lines:
Renaming WorksheetsNaming work sheets facilitates keeping track of and organizing work sheets.
Worksheets can be renamed for Class Lists, Inventory, and other types of data.
To rename any worksheet:
Type the new name of the work sheet e.g. 'History 10 Class List' (see diagram below)