zyla.blogg.se

Key shortcuts for excel 2016
Key shortcuts for excel 2016







key shortcuts for excel 2016

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.

    key shortcuts for excel 2016

    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:









    Key shortcuts for excel 2016