Mohsin Web
You are Unregistered, please Login Or Register to gain Full access.
Note: If You Want To Visit Us As Guest Then Click On Do Not Display Again

Modifying A Worksheet

Go down

Modifying A Worksheet Empty Modifying A Worksheet

Post by Admin on Sat Jun 20, 2009 11:07 am


Moving Through Cells
Use the mouse to select a cell you want to begin adding data to
and use the keyboard strokes listed in the table below to move through
the cells of a worksheet.
MovementKey stroke
One cell upup arrow key
One cell downdown arrow key or ENTER
One cell leftleft arrow key
One cell rightright arrow key or TAB
Top of the worksheet (cell A1)CTRL+HOME
End of the worksheet (last cell containing data)CTRL+END
End of the rowCTRL+right arrow key
End of the columnCTRL+down arrow key
Any cellFile|Go To menu bar command

Adding Worksheets, Rows, and Columns

  • Worksheets - Add a worksheet to a workbook by selecting
    Insert|Worksheet from the menu bar.
  • Row - To add a row to a worksheet, select Insert|Rows
    from the menu bar, or highlight the row by clicking on the row
    label, right-click with the mouse, and choose Insert.
  • Column - Add a column by selecting Insert|Columns
    from the menu bar, or highlight the column by click on the column
    label, right-click with the mouse, and choose Insert.

Resizing Rows and Columns
There are two ways to resize rows and columns.

  1. Resize a row by dragging the line below the label of
    the row you would like to resize. Resize a column in a
    similar manner by dragging the line to the right of the label
    corresponding to the column you want to resize.
    - OR -
  2. Click the row or column label and select Format|Row|Height
    or Format|Column|Width from the menu bar to enter a numerical
    value for the height of the row or width of the column.

Selecting Cells
Before a cell can be modified or formatted, it must first be selected
(highlighted). Refer to the table below for selecting groups of
Cells to selectMouse action
One cellclick once in the cell
Entire rowclick the row label
Entire columnclick the column label
Entire worksheetclick the whole sheet button
Cluster of cellsdrag mouse over the cells or hold down the SHIFT
key while using the arrow keys
To activate the contents of a cell, double-click on the cell or
click once and press F2.

Moving and Copying Cells

Moving Cells Modifying A Worksheet Cut
To cut cell contents that will be moved to another cell select
Edit|Cut from the menu bar or click the Cut button
on the standard toolbar.
Copying Cells Modifying A Worksheet Copy
To copy the cell contents, select Edit|Copy from the menu
bar or click the Copy button on the standard toolbar.
Pasting Cut and Copied Cells Modifying A Worksheet Paste
Highlight the cell you want to paste the cut or copied content
into and select Edit|Paste from the menu bar or click the
Paste button on the standard toolbar.
Drag and Drop
If you are moving the cell contents only a short distance, the
drag-and-drop method may be easier. Simply drag the highlighted
border of the selected cell to the destination cell with the mouse.

Freeze Panes
If you have a large worksheet with column and row headings, those
headings will disappear as the worksheet is scrolled. By using the
Freeze Panes feature, the headings can be visible at all times.

  1. Click the label of the row below the row that should remain
    frozen at the top of the worksheet.
  2. Select Window|Freeze Panes from the menu bar.
  3. To remove the frozen panes, select Window|Unfreeze Panes.
    Modifying A Worksheet Freezepanes

    Freeze panes has been added to row 1 in the image above. Notice
    that the row numbers skip from 1 to 6. As the worksheet is scrolled,
    row 1 will remain stationary while the remaining rows will move

Modifying A Worksheet 54kjo810
Modifying A Worksheet T5k5s2
Modifying A Worksheet Nlvsjo
Modifying A Worksheet T5k5s2

Posts : 136
Age : 24
Location :

Back to top Go down

Modifying A Worksheet Empty Re: Modifying A Worksheet

Post by SHAKIL ILYAS on Tue Jun 23, 2009 12:53 pm

Wah Jee Waj Kiya Bat Hai Janab Ki
TOP Poster
TOP Poster

Posts : 201
Age : 30
Location : Yaadon Min

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum