DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Ctrl+Alt+A
|
|
|
Ctrl+V
|
|
|
Ctrl+Alt+V
|
|
|
Ctrl+Shift+P
|
Detailed explanation-1: -To do this, copy the cell, go to the destination cell and use the keyboard shortcut ALT + E + S. It will open the Paste Special dialog box.
Detailed explanation-2: -After you’ve copied the data, press Ctrl+Alt+V, or Alt+E+S to open the Paste Special dialog box. Tip: You can also select Home > Paste > Paste Special.
Detailed explanation-3: -Word 2013-2021 Select the text you want to copy and press Ctrl+C. Place your cursor where you want to paste the copied text and press Ctrl+V.
Detailed explanation-4: -To paste the content using the shortcut key, hold the Control (Ctrl) key, then press “V”. That’s it!
Detailed explanation-5: -Click the first cell in the area where you want to paste what you copied. On the Home tab, under Edit, click Paste, and then click Paste Special. Paste all cell contents and formatting, including linked data.