Summary:
This tutorial will cover the basics of formatting worksheets within the Excel workbook and is aimed at users who already have a basic understanding of Excel. We will cover merging cells, using a series, modifying columns and rows, changing fonts, changing cell content alignment, rotate text, use number formats and add borders and shading for visual effects.

Details or Sample:
This tutorial will cover the basics of formatting worksheets within the Excel workbook and is aimed at users who already have a basic understanding of Excel. We will cover merging cells, using a series, modifying columns and rows, changing fonts, changing cell content alignment, rotate text, use number formats and add borders and shading for visual effects.

Cell Merging and AutoFill
In this section we will create a title for our worksheet. A title should be centered at the top of the page and this is easily accomplished using the cell merge operation.
Begin by opening Excel with a new blank workbook and select cell A1. Key ABC Employee Time Sheet into the selected cell and press the enter key. If the formatting bar is not visible in the toolbar section, simply click "view", "toolbars", "formatting", so that toolbar will be visible.
Next, select cells A1:J1 (A1 through J1) and then locate the Merge and Center button located on the formatting toolbar. This button contains the letter "a" with an arrow on each side. Click this button and notice that ABC Employee Time Sheet is now centered across the top and those cells have been merged into one cell, A1.

Working with a series and adding labels.
Our time sheet will assume that each of your employees works with different clients on different days.
Select cell B3 and key the word Monday into that cell. Click the green checkmark in your formula bar. Using the checkmark will keep the active cell in place, whereas hitting the enter key would jump to cell B4.

We will use AutoFill to finish the days of the week. Excel uses the AutoFill function to enter a series of data like numbers, days, and months. You will notice that since you used the checkmark function in the formula bar, the cell B3 is still selected with a dark border. AutoFill works a bit like drag and drop using a fill handle.
Position your mouse pointer by the lower right corner of the border. When it turns into a thin black cross simply click and hold your left mouse button. Drag the fill handle to cell F3. A screen tip will appear as you drag the fill handle over to cell F3 that displays the values that will be entered into the cells.

You can also use the fill series option, which is a little different than the AutoFill function.
Select cell B4 under the heading of Monday. Key the number 1 into the cell and then click the green checkmark. This time you will right-drag to cell F4 by holding the right mouse button down instead of the left mouse button. When you reach cell F4 a shortcut menu will appear. Click on fill series in the shortcut menu and the numbers 1 though 5 will appear in the corresponding cells. If you use the left mouse button to drag across the cells then it will just repeat the number 1 in each cell instead of using the series of numbers 1 to 5.

Now we will move to cell G3 and key in the word Total and then proceed to cell A3 and key in the word Client. Now we will list the clients that our company has in cells A5:A12.
Select cell A5 and enter Jazz Band, then hit the enter key to jump to cell A6 and continue through the list of clients;
Rustlers Restaurant
Show Dog
Extreme Realty
Lucky Leaf
Shorty"s
Jump Start
Nightingale
Enter the word Total in cell A13 and then save your work.

Modifying the size of rows and columns
You will notice that the clients you just entered will be overlapping into the adjacent cells. Excel is set to display eight characters by default in each cell.
One way to change the size of your cells is to use the AutoFit command. The AutoFit command will automatically resize the width of your column to the width of the widest cell needed. In this case, Rustlers Restaurant contains the most characters so the whole column would adjust itself according to that cell data.

Move your mouse pointer into the column heading section between columns A and B it will change into a horizontal resize pointer. Double-click the divider between columns A and B. The column widens to accommodate the longest entry, Rustlers Restaurant.

Purchase this content for your website...

Pricing:
Usage:	$10	[Add to Cart]

Downloads: 1
Written by: Ann King
Available File Types:Text
Words: 1509