FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Shift+Spacebar to select the row. Alt+I+R to add a new row above.

Detailed explanation-2: -To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones. Right-click the selection, and then select Insert Rows.

Detailed explanation-3: -Luckily, there is an easy keyboard shortcut for this: Ctrl+Shift+Plus. Simply click a row number to select a row, hold down the Ctrl and Shift keys, and press plus (+). Excel will then add a row above the selected row.

Detailed explanation-4: -If you want to center your cell contents horizontally, just press Ctrl+E. If you want to center your cell contents vertically, just press Ctrl+E. It’s that easy. So the next time you’re working in Excel and you need to center your cell contents, save yourself some time and use the Ctrl+E shortcut.