DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Active cell
|
|
Autocell
|
|
Auto sum
|
|
Auto Fill
|
Detailed explanation-1: -Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature.
Detailed explanation-2: -Fill formulas into adjacent cells Click Home > Fill, and choose either Down, Right, Up, or Left. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.
Detailed explanation-3: -A simple explanation is that Autofill is Excel’s ability to help fill cells in column or rows with the data of formulas from other cells. Cells can be filled up, down, left or right with common data types including dates (days, months, quarters or years) series of numbers.