This next part of the tutorial I decided to call "How To." It will describe in a fair amount of detail how to perform various tasks using Microsoft Excel 2000.
MERGE AND CENTER: Center a title over a row of cells.
First type in the info. you want centered in Column A (making sure you are in left alignment). Next, highlight the cells you want the info. to be centered upon. (Dont click the row number, it will center info among all 156 columns.) Finally click the MERGE AND CENTER icon from the top. It will center your title in the center of the cells you hilighted.
INSERT A ROW:
Click on the row # where you want to insert a row, then click on INSERT and then ROWS. This will insert a blank row at the location you selected.
INSERT A COLUMN:
Click on the column # where you want to insert a column, then click INSERT and then COLUMNS. This will insert a blank column where you selected.
DELETE A ROW OR COLUMN:
Highlight the row or column you want to delete. click on EDIT-->DELETE. This deletes the current row or column from the spreadsheet.
COPY FORMULAS AND FUNCTIONS:
First off more your cell pointer to the cell you wish to copy. Position the mouse over the lower right hand corner of the cell pointer. This is the auto-fill handle (solid black cross).
Next press down on auto-fill handle with left mouse button and drag mouse, highlighting cells you want to copy contents of current cell to. Now when you have all desired cells highlighted, release mouse button. The contents of the source cell will be copied to the destination cells.
CHANGE COLUMN WIDTH:
Go up to column letter for the current column and point the mouse over the line just to the right of the column letter. Then press on the left mouse button and drag... when you press down the column width will appear. And just drag until the desired column width is reached and release the mouse button.
FORMATTING A NUMBER AS A PERCENT:
Just highlight the # and click the PERCENT icon. Remember, when you format a number as a percent, the number will first be multiplied by 100 and the % sign will be tracked on to the right side of the number.
...AS A DECIMAL:
Highlight your number, and click INCREASE DECIMAL ICON, or DECREASE DECIMAL ICON. To increase the number of decimal places, click INCREASE DECIMAL, to decrease number of decimal places, click the DECREASE DECIMAL ICON.
Highlight number, click FORMAT -- click on CELLS -- click on NUMBERS TAB (if not selected already) -- click on CURRENCY. And if you click on the dollar sign in the toolbar, the number will be formatted in accounting format (the $ will be clear over in the left hand side of the cell).
I think thats a pretty good place to stop. Just as the title indicates, that should get you started with spreadsheets. I would say next step for you is (if you dont already know about them) is databases and Access. That should be the next tutorial I write, "Getting Started with Databases" (lol). I hope that this tutorial has served you well, and if you feel that I left anything out like, WIZARD'S options and such- it was on purpose. I dont have the patience to write anthing much longer than this. Enjoy ;)
No Comments for this page.