Excel Notes

To insert content:

1. Click a cell to select it. 2. Enter content into the selected cell using your keyboard. The content appears in the cell and in the formula bar. You can also enter or edit cell content from the formula bar.

to select a cell

1. Click a cell to select it. When a cell is selected, you will notice that the borders of the cell appear bold Cursor and the column heading and row heading of the cell are highlighted. 2. Release your mouse. The cell will stay selected until you click another cell in the worksheet

To use the fill handle to fill cells:

1. Select the cell or cells containing the content you want to use. You can fill cell content either vertically or horizontally. 2.Position your mouse over the fill handle so the white cross Cursor becomes a black cross Cursor. 3. Click and drag the fill handle until all of the cells you want to fill are highlighted. 4. Release the mouse, and your cells will be filled.

To delete content within cells:

1. Select the cells containing content you want to delete. 2. Click the Clear command on the Ribbon. A dialog box will appear. 3. Select Clear Contents.

To cut and paste cell content:

1. Select the cells you want to cut. 2. Click the Cut command. The border of the selected cells will change appearance. 3.Select the cells where you want to paste the content. 4. Click the Paste command. The cut content will be removed from the original cells and entered into the highlighted cells.

To delete cells:

1. Select the cells you want to delete. 2. Choose the Delete command from the Ribbon.

To access formatting commands by right-clicking:

1. Select the cells you want to format. 2. Right-click the selected cells. A dialog box will appear where you can easily access many commands on the Ribbon.

to select multiple cells

1.Click and drag your mouse until all of the adjoining cells you want are highlighted. 2. Release your mouse. The cells will stay selected until you click another cell in the worksheet

To copy and paste cell content:

1.Select the cells you want to copy. 2. Click the Copy command. The border of the selected cells will change appearance. 3. Select the cell or cells where you want to paste the content. 4. Click the Paste command. The copied content will be entered into the highlighted cells

To drag and drop cells:

1.Select the cells you want to move. 2. Position your mouse on one of the outside edges of the selected cells. The mouse changes from a white cross Cursor to a black cross with 4 arrowsCursor 3. Click and drag the cells to the new location. 4. Release your mouse, and the cells will be dropped there.

comments:

Cells can contain comments from multiple reviewers.

Formatting attributes:

Cells can contain formatting attributes that change the way letters, numbers, and dates are displayed. For example, dates can be formatted as MM/DD/YYYY or M/D/YYYY.

Formulas and functions:

Cells can contain formulas and functions that calculate cell values. For example, SUM(cell 1, cell 2...) is a formula that can add the values in multiple cells.

text:

Cells can contain letters, numbers, and dates.

To access more merge options:

Click the drop-down arrow next to the Merge & Center command on the Home tab. The merge drop-down menu appears. Merge & Center: Merges selected cells into one cell and centers the text Merge Across: Merges each row of selected cells into larger cells; useful when merging content across multiple rows of cells rather than creating one large cell Merge Cells: Merges selected cells into one cell Unmerge Cells: Unmerges selected cells Accessing more Merge options

the cell

Each rectangle in a worksheet is called a cell. A cell is the intersection of a row and a column. Each cell has a name, or a cell address based on which column and row it intersects. The cell address of a selected cell appears in the name box. Here, you can see that C5 is selected. You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5.

To modify row height:

Position the cursor over the row line so the white cross Cursor becomes a double arrow Double-arrow. Positioning the mouse over the row line Click and drag the row downward to increase row height or upward to decrease height. Increasing the row height Release the mouse. The height of each selected row will be changed in your worksheet. Increased row height

To modify column width:

Position your mouse over the column line in the column heading so the white cross Cursor becomes a double arrow Double-arrow. Positioning mouse over the column line Click and drag the column to the right to increase column width or to the left to decrease column width. Increasing the column width Release the mouse. The column width will be changed in your spreadsheet. Increasing the column width If you see pound signs (#######) in a cell, it means the column is not wide enough to display the cell content. Simply increase the column width to show the cell content.

To wrap text:

Select the cells with text that you want to wrap. Selecting cells to wrap Select the Wrap Text command on the Home tab. Selecting the Wrap Text command The text in the selected cells will be wrapped in your worksheet. Cells with wrapped text If you change your mind, reclick the Wrap Text command to unwrap the text.

To merge cells using the Merge & Center command:

Select the cells you want to merge. Selecting A1:D1 (A1, B1, C1, D1) Select the Merge & Center command on the Home tab. Selecting the Merge & Center command The selected cells will be merged, and the text will be centered. A1 after merging with A1:I1 If you change your mind, reclick the Merge & Center command to unmerge the cells.

To insert columns:

Select the column to the right of where you want the new column to appear. For example, if you want to insert a column between A and B, select column B. Selecting the column Click the Insert command on the Home tab. Selecting the Insert Cells command The new column appears in your worksheet. The inserted column By default, Excel formats inserted columns with the same formatting as the column to the left of them. To access more options, hover your mouse over the Insert Options button and click the drop-down arrow that appears.

To delete columns:

Select the columns you want to delete. Selecting the columns Click the Delete command on the Home tab. Selecting the Delete command The columns are deleted from your worksheet. The columns are deleted

To set column width with a specific measurement:

Select the columns you want to modify. Click the Format command on the Home tab. The format drop-down menu appears. Select Column Width. Increasing the column width The Column Width dialog box appears. Enter a specific measurement. Increasing column width to 258 pixels Click OK. The width of each selected column will be changed in your worksheet.

To insert rows:

Select the row below where you want the new row to appear. Selecting the row Click the Insert command on the Home tab. Selecting the Insert Cells command The new row appears in your worksheet. The inserted row When inserting new rows, columns, or cells, you will see the Insert Options button Cursor by the inserted cells. This button allows you to choose how Excel formats them. By default, Excel formats inserted rows with the same formatting as the cells in the row above them. To access more options, hover your mouse over the Insert Options button and click the drop-down arrow that appears.

To delete rows:

Select the rows you want to delete. Selecting the rows Click the Delete command on the Home tab. Selecting the Delete command The rows are deleted from your worksheet. The rows are deleted

To set row height with a specific measurement:

Select the rows you want to modify. Click the Format command on the Home tab. The format drop-down menu appears. Select Row Height. Increasing the column width The Row Height dialog box appears. Enter a specific measurement. Increasing row height to 60 pixels Click OK. The selected rows heights will be changed in your spreadsheet.

To access more paste options:

There are more Paste options you can access from the drop-down menu on the Paste command. These options may be convenient to advanced users who are working with cells that contain formulas or formatting.