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.