DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Fill handle
|
|
|
PgDn Key
|
|
|
Function key F4
|
|
|
None of the above
|
Detailed explanation-1: -Luckily, there’s a shortcut: Simply double-click the fill handle, and it will instantly copy the cell content down. Watch the video below to see this shortcut in action.
Detailed explanation-2: -Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges. You can also select the first cell or range of cells, and then press SHIFT+F8 to add another nonadjacent cell or range to the selection. To stop adding cells or ranges to the selection, press SHIFT+F8 again.
Detailed explanation-3: -Fill Handle is a feature in Excel that enables you to auto-complete a list in a row/column by simply dragging it using your mouse. A basic understanding of fill handle in Excel could save you some time and make you more productive.