Table/Cell Formatting

There are number of options for formatting cells by marking the cells you want to format and going to Format > Cell from the top toolbar. You can also format a row or column. Within the formatting screen, the number tab allows you to change how Excel processes and displays any numbers in a cell. Options include using numbers as values, percentage, currency, dates, fractions and several other options. The alignment tab simply allows you to control how to align the data and the fonts tab provide options for size and style of font. You can really improve a spreadsheet by taking advantage of the border tab where you can choose the style of lines around the cell, row or column including the line type and choices of where the line resides on the cell. The pattern tab allows you to choose a color and pattern background for the document. The protection tab basically allows you to lock or hide a cell, which is most often used to lock titles of columns or rows that you won't want to change and don't want to change by accident.

Printing Excel Files

When you go to print the file, you will want to use the print preview to make sure that nothing is spilling off onto additional pages. Make sure that when you print a table, you select the cells you want to print and use the File > Print Area > Set Print Area function in order to ensure you are not printing blank cells that can throw off the page. Usually in any Excel document you have to modify the margins and page set up to get the table to print properly. You may also need to go into your columns and adjust the width to columns that may end up with too much white space. You can do this by going to Format > Column > Width.