If you click on a cell with the mouse you will see its name appear on the left hand side of the formula bar. As you click on different cells the name in the formula bar will change accordingly. Alternatively, you can select different cells in the worksheet using the arrow keys or the Enter and Backspace keys.
You can select a range of cells by clicking on a single cell at one corner of the range then, with the mouse button held down, drag the selection so that it extends over the other cells. To select an entire row of cells you can click on the row number, and you can select columns by clicking on the appropriate letter.Finally, you can select the entire worksheet by clicking on the grey box against the letter A and number 1.
Changing to a New Worksheet
If you want to include some related data, but don’t want to overload your current worksheet you can begin a new sheet. To do this click on any of the tags below the cells to display the corresponding sheet.
To make individual sheets of data easily recognisable you can name each sheet that you use. To name the current sheet double click the sheet label (Sheet1, Sheet2 etc) to select it, then enter a new name for that worksheet and press Enter. If you need more than three worksheets, go to the Cells group on the Home tab and click the Insert button. From the menu select Insert Sheet.
Entering Data
To enter data into a cell first select the cell. As you start to type you will notice that buttons materialize in the formula bar and that the data appears simultaneously in the formula bar and in the selected cell.
Having typed the data for that cell you can then press the Enter key or click on the tick button. The formula bar will then clear leaving only the cell reference displayed.
If you need to edit the contents of a cell you can do this via the formula bar. First click on the cell in question so that its contents appear in the formula bar. Then click within the formula bar to produce a cursor with which to edit the cell contents.
Formatting Text
A worksheet containing raw data is not very clear, but you can improve its appearance by applying different formats to some key cells. The most popular formats are available through tools in the Font and Alignment groups on the Home tab.
The button in the lower-right corner is very useful for headings. If you select a single cell, then extend the selection horizontally across adjacent cells you can then click on
this button to center the single cell contents across the selected range.
Finally, you can adjust the width of any column by positioning the cursor between two lettered column headings and dragging the column wider. To automatically adjust any column to accommodate its widest entry, simply double click the column label. Row heights can be adjusted in a similar way.
Formatting Text Using Styles
Excel 2007 offers a more powerful way to quickly format text, using the tools in the Styles group on the Home tab. Select one or more cells, then from the Styles group, click the Cell Styles button.
Formatting Tables
Alternatively, you can select all of your data, or a self-contained subset, and format the entire selection as a table.
Select your data, then from the Styles group on the Home tab, click the Format as Table button. You will see a large choice of colored table formats, choose and format to apply to your selected data.
Formatting Numbers
To clarify your worksheet further you can specify the format in which selected numbers are displayed. To do this, select the cells containing the numbers in question, then from the Number group on the Home tab, click the drop down list.
Select any numbering style, or for more options, select the More Number Formats option. In the dialog box that appears, you will see a list of categories of numbers and for each category there will be a second list containing possible formats. You can then choose a format for your selected data.
In addition, there are buttons in the Number group which will quickly format numbers as currency, percentages, or fixed numbers of decimals.
Formatting Dates
If you choose the date format for numbers, you have a great deal of control over how
your dates appear in the worksheet. If you select Date from the dialog box above you
will be offered a choice of formats, but you can create your own format by clicking
the Custom option. You can then build a date format using the letters d, m and y for
date month and year as follows
dd two digit day number 01, 02, … 31
ddd three letter day Mon, Tue, … Sun
dddd full day name Monday Tuesday, … Sunday
mm two digit month number 01, 02, …12
mmm three letter month name Jan, Feb, … Dec
mmmm full month name January, February, … December
yy two digit year 98, 99, 00, …
yyyy four digit year 1998, 1999, 2000, …
So the date format dddd dd-mmm-yy would give dates in the form:
Monday 06-Mar-00
No comments:
Post a Comment