Showing posts with label Spreadsheet Excel. Show all posts
Showing posts with label Spreadsheet Excel. Show all posts

Finding and Replacing and Adding Comments Text or Numbers



►Finding Text or Numbers  
 1-  On theEdit menu, click Find. The Find and Replace dialog box appears. Click the Optins button to display more Find options.
2-  In the Find what box, enter the text or numbers you want to search for. You can enhance your search as per the displayed options: Within, Match case, …
3-  Click Find Next.

Editing Worksheet Data Excel ,Moving , Copying , Inserting Columns

►Editing Cell Contents
1- Double-click the cell that contains the data you want to edit.
2- Make any changes to the cell contents.
3- To enter your changes, press ENTER.
4- If you want to cancel your changes, press ESC.

Entering the Same Data into Several Cells at Once



1-Select the cells where you want to enter data. The cells can be adjacent or onadjacent.
2- Type the data and press CTRL + ENTER.
►Automatic Fill  By dragging the fill handle of a cell, you can copy that cell to other cells in the same row or column. If the cell contains a number, date, or time period that icrosoft Excel can extend in a series,

Entering Data& Text & Numbers&Symbols



 As mentioned earlier, each worksheet is comprised of tabular girded cells. Acell is the basic unit in the worksheet that can hold data, and is the result of a column intersecting a row. One cell in the worksheet is always the active cell. To activate a cell, just click it. The reference of the active cell is displayed in the Name Box of the Formula bar.