Question

Excel’s Fill command lets you fill an adjacent group of cells with the same text or numbers, or with text or numbers that form a series. In its simplest form it’s like a faster version of copy and paste. For example, enter a name in cell A1, then highlight cells A1 through A5 and press Ctrl+D (the keyboard shortcut for Fill Down) and all the selected cells will be filled in with the name from A1. But it can do much more.

First let’s talk about the mechanics of using Fill, then we’ll get into what else it can do. There are several ways to access Fill:​

Answer 1

Answer:

Ctrl+R is the shortcut for Fill Right. Both require you to first highlight a range of cells, starting will the cell containing the text or numbers you want copied to the other cells.