آموزش Excel 2000-EN

[A M I R]

[h=2]Inserting and Deleting Rows and Columns

[h=3]Challenge!Practice inserting and deleting columns and rows using one or more of the methods explained in this lesson.

​

 

[A M I R]

[h=2]Adjusting Column Width and Row Height

[h=3]Introduction
[h=4]By the end of this lesson, learners should be able to:
Adjust column width and row height


​

 

[A M I R]

[h=2]Adjusting Column Width and Row Height

[h=3]Adjusting Column Widths
By default, Excel's columns are 8.43 characters wide, but each individual column can be enlarged to 240 characters wide.

If the data you are entering in your worksheet is wider or narrower than the default

column width, you can adjust the width so it is wide enough to contain the data.

You can adjust column width manually or use AutoFit.

​

 

[A M I R]

[h=2]Adjusting Column Width and Row Height

[h=3]Adjust Column Width Two Ways
[h=5]Manually:
Place your mouse pointer to the right side of the column header.

The mouse pointer changes to the adjustment tool (double-headed arrow).

Drag the edge of the column header to the desired width and release the button.




​

 

[A M I R]

[h=2]Adjusting Column Width and Row Height

AutoFit:



Place your mouse pointer to the right side of the column header.

The mouse pointer changes to the adjustment tool (double-headed arrow).

Double-click the column header border.

Excel "AutoFits" the column, making the entire column slightly larger than the largest entry.

To access AutoFit from the menu bar, choose Format

Column

AutoFit Selection.

​

 

[A M I R]

[h=2]Adjusting Column Width and Row Height

[h=3]Adjusting Row Height
Adjusting row height is much like adjusting column width.

​

 

[A M I R]

[h=2]Adjusting Column Width and Row Height

[h=5]To Adjust Row Height:
Place your mouse pointer to the lower edge of the row heading you want to adjust.

The mouse pointer changes to the adjustment tool (double-headed arrow).

Double-click to adjust the row height to "AutoFit" the font size.

Drag to manually increase or decrease size.

​

 

[A M I R]

[h=2]Adjusting Column Width and Row Height

[h=3]Did You Know?

When entering data into a worksheet, never leave blank columns between data-filled

columns. Blank columns create major problems when performing advanced Excel functions

such as making charts, sorting data, etc.

Don't use columns to create space between your columns. Instead, adjust column

width so your data is easy to read and understand.



​

 

[A M I R]

[h=2]Inserting and Deleting Cells

[h=3]Introduction
[h=4]By the end of this lesson, learners should be able to:

• Insert cells

• Delete cells

​

 

[A M I R]

[h=2]Inserting and Deleting Cells

[h=3]Inserting Cells
When working in an Excel worksheet, you may need to insert or delete cells without inserting or deleting entire rows or columns.

​

 

[A M I R]

[h=2]Inserting and Deleting Cells

[h=5]To Insert Cells:
Select the range where new cells should be inserted.

Right-click and choose Insert.

The Insert dialog box opens and presents the following four choices:

Shift cells right: cells in the same row are shifted right.

Shift cells down: selected cells and all cells below them in the same column are shifted.

Entire row: inserts an entire row of cells.

Entire column: inserts an entire column.

Choose an option and click OK.

Your result displays in the spreadsheet.

Remember, you can also use the Insert/Delete dialog box to insert/delete columns and rows.

​

 

[A M I R]

[h=2]Inserting and Deleting Cells

[h=3]Deleting Cells

[h=5]To Delete Cells:
Select one or more cells.

To delete cell contents but leave the cell in place, press the Delete key.

OR

Right-click and choose Delete.

The Delete dialog box opens and presents the following choices:

Shift cells left: cells in the same row are shifted right.

Shift cells up: selected cells and all cells below them in the same column are shifted.

Entire row: deletes an entire row of cells.

Entire column: deletes an entire column.

Choose an option and click OK.

Your result displays in your spreadsheet.

​

 

[A M I R]

[h=2]Inserting and Deleting Cells



[h=3]Challenge!

Practice inserting and deleting cells using the Insert/Delete dialog box.
​

 

[A M I R]

[h=2]Moving and Copying Cell Contents

[h=3]Introduction

[h=4]By the end of this lesson, learners should be able to:
Move and copy cell contents using:

• Cut, copy, paste

• Drag and drop

​

 

[A M I R]

[h=2]Moving and Copying Cell Contents

[h=3]Moving and Copying Cell Contents
If you're not happy with the location of your data, you don't have to delete

it and start entering data all over again. Instead, you can move it around in the worksheet


Basic moving and copying techniques can be reviewed in our Office 2000 lessons.



​

 

[A M I R]

[h=2]Moving and Copying Cell Contents

[h=4]Copying and Pasting Cells
The Office 2000 Clipboard is very helpful if you want to transfer information

within a worksheet. In fact, the Clipboard allows you to store up to 12 items

and paste them one at a time or all of them at once. To turn on the Clipboard

toolbar, choose View

Toolbars

Clipboard from the menu bar






​

 

[A M I R]

[h=2]Moving and Copying Cell Contents

[h=5]To Cut, Copy and Paste:
Select a cell or cells to be duplicated.

Click on the Copy button. "Marching Ants" appear around the selected cells.

If you want to move the information from one cell to another, click the Cut button instead.

Click on the cell where you want to place the duplicated information. The cell will be

highlighted. If you are copying contents into more than one cell, click the first cell

where you want to place the duplicated information


Press the Enter key. Your information is copied to the new location.

Select a cell or cells to be moved or duplicated and right-click to open the shortcut menu.

​

 

[A M I R]

[h=2]Moving and Copying Cell Contents

[h=3]Differences in Excel's Cut, Copy, and Paste Functions
While basic cut, copy, and paste functionality works in Excel, you should know that Excel handles it a bit differently:

You must paste data you've cut or copied immediately. If you don't, the cut or copy operation is cancelled.

When you cut a selection, you can paste it once. You can't paste the selection multiple

times. Instead, you must copy and paste the same information over and over again


When you cut a cell, it's copied to the Clipboard. That information

remains on the Clipboard until you paste it by pressing Enter or the Paste button


You can't paste cells on top of existing data. If you do, the existing data is overwritten.

​

 

[A M I R]

[h=2]Moving and Copying Cell Contents

[h=3]Using Drag and Drop

Drag and drop is useful in Excel when you can actually see where you want to move your data to a new location.

​

 

[A M I R]

[h=2]Moving and Copying Cell Contents

[h=5]To Use Drag and Drop:
Select some cells you'd like to move to a new location.

Position the mouse pointer near one of the outside edges of the

selected cell (however, avoid the fill handle in the lower right during this process).




The mouse pointer becomes a small white arrow.

Keeping the mouse pointer on the outer edge of the selected

cell, press and hold the mouse button and drag the cells to a new location

Basic drag and drop techniques can be reviewed in Office 2000 lessons.





​