In case it does not appear, one can format the newly inserted row in either of the following ways: Note: The paintbrush icon may not appear each time a new row is inserted. Based on this selection, the newly inserted row (row 6) is formatted. One can select any of the preceding styles.
Clear formatting: This removes the formatting of row 6. Format same as below: This applies the formatting of the immediately following row (row 7) to row 6. Format same as above: This applies the formatting of the immediately preceding row (row 5) to row 6. The formatting styles displayed are explained as follows: Thereafter, click the drop-down arrow, as shown in the succeeding image. To format the new row 6, hover the mouse over the paintbrush icon. Moreover, a paintbrush icon appears immediately below the newly inserted row (row 6). With the insertion of the new row 6, the entries of the initial row 6 are shifted downwards to row 7. This new row is shown in the following image. A blank row 6 is inserted with both the preceding shortcuts (entered in step 2). Note 2: The shortcut “Ctrl+Shift+plus sign (+)” works on devices which do not have a separate numeric keypad. For this shortcut to work, press the “Ctrl” key from the regular keyboard and the plus sign (+) from the number pad. 
Note 1: The shortcut “Ctrl+plus sign (+)” works only on those devices which have a numeric keypad (number pad) to the right of a regular keyboard. In the succeeding image, we have applied the former shortcut.
Once the entire row is selected, press the keys “Ctrl+plus sign (+)” or “Ctrl+Shift+plus sign (+).” The keys of each shortcut must be pressed together. The entire row 6 is selected, as shown in the following image. Press the shortcut keys “Shift+spacebar” together. The steps to insert a new excel row (row 6) are listed as follows:
0 kommentar(er)
