Question

Write about filling a range of cells in Ms Excel.

Answer 1

Fill formulas into adjacent cells

You can use the Fill command to fill a formula into an adjacent range of cells. Simply do the following:

Select the cell with the formula and the adjacent cells you want to fill.

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.

Answer 2

Range:

A range is basically a collection of two or more cells which is again the intersection of rows and columns in MS Excel. There are two methods through which we can fill a range of cells:

Autofill:

• Autofill is the most important feature of MS Excel. When you insert any two values in the Excel, it automatically fills the rest of the cells in a similar manner upon dragging it. We can see the + symbol showing at the right side of the cell. When we drag it to the bottom, we can see Excel automatically fills the values.

By pressing Ctrl+D:

• We have to enter one data and will drag to the bottom with the help of the mouse and will release the mouse button. Then press Ctrl+D button and then we can see cells are automatically filled.

Learn more about Range

What is a Range ? Explain it.

https://brainly.in/question/6940234

What we meant by range name.. in computer.. ?

https://brainly.in/question/5431942