When you insert a row in Excel 2007, by default the inserted row has the formatting details as that of the previous row. Input the following information to demonstrate this:
1. Click cell A1 and press the SHIFT key and click cell E1. Five cells are now selected.
2. Change the color of the cells to yellow and the color of the text to red.
3. Click cell A2 and press the SHIFT key and click cell E2. Five cells are now selected.
4. Change the color of the cells to blue and the color of the text to white.
5. Enter the information in cells A1 to E2 as shown in the figure below.
6. Click cell A2. On the Home tab, in the Cells group, click the down arrow in Insert and click Insert Sheet Rows.
2. Change the color of the cells to yellow and the color of the text to red.
3. Click cell A2 and press the SHIFT key and click cell E2. Five cells are now selected.
4. Change the color of the cells to blue and the color of the text to white.
5. Enter the information in cells A1 to E2 as shown in the figure below.
6. Click cell A2. On the Home tab, in the Cells group, click the down arrow in Insert and click Insert Sheet Rows.
The Insert Options button appears. Clicking the Insert Options button pops up three values:
A. Format Same As Above
B. Format Same As Below
C. Clear Formatting
A. Format Same As Above
When you click this option, the newly inserted row has the formatting details exactly as that of the row that is above it. This means, the inserted row has the yellow color background and red color font applied to the cells.
B. Format Same As Below
When you click this option, the newly inserted row has the formatting details exactly as that of the row that is below it. This means, the inserted row has the blue color background and white color font applied to the cells.
C. Clear Formatting
No formatting is applied when you choose this option.
0 comments:
Post a Comment