Sage-Tips

How do you quickly fill a series in Excel?

The regular way of doing this is: Enter 1 in cell A1. Enter 2 in cell A2. Select both the cells and drag it down using the fill handle….Quickly Fill Numbers in Cells without Dragging

1. Enter 1 in cell A1.
2. Go to Home –> Editing –> Fill –> Series.
3. In the Series dialogue box, make the following selections:
4. Click OK.

How do you fill a series in a spreadsheet?

Use autofill to complete a series

1. On your computer, open a spreadsheet in Google Sheets.
2. In a column or row, enter text, numbers, or dates in at least two cells next to each other.
3. Highlight the cells. You’ll see a small blue box in the lower right corner.
4. Drag the blue box any number of cells down or across.

Why is Excel not filling series?

Re: Excel 2016 Series fill not properly working In case you need to get Excel AutoFill not working, you can switch it off by doing the following: Click on File in Excel 2010-2013 or on the Office button in version 2007. Go to Options -> Advanced and untick the checkbox Enable fill handle and cell drag-and-drop.

How do I fill a series in Excel without a mouse?

Simply do the following:

1. Select the cell with the formula and the adjacent cells you want to fill.
2. 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.

How do you AutoFill without dragging sheets?

Pro Tip: When you have data in the adjacent column (left or right), you can also simply double click on the fill handle icon (instead of clicking and dragging). Double-clicking would do the same thing and fill down the column until the last filled cell in the adjacent column.

How do you fill a series in Excel using the keyboard?

How do you fill multiple cells in Excel?

Insert the same data into multiple cells using Ctrl+Enter

1. Select all the blank cells in a column.
2. Press F2 to edit the last selected cell and type some data: it can be text, a number, or a formula (e.g. “_unknown_”)
3. Press Ctrl+Enter instead of Enter. All the selected cells will be filled with the data that you typed.

How do I fill a series in Excel for Mac?

Filling in a series in a range of Excel cells Click the cell that has the word January in it. Position the mouse cursor over the lower-right corner of the selected cell (the fill handle) so that it becomes the solid cross cursor. Drag the fill handle down or to the right and watch Excel do some magic.

How do you auto fill rows in Excel?

Fill data automatically in worksheet cells

1. Select one or more cells you want to use as a basis for filling additional cells. For a series like 1, 2, 3, 4, 5…, type 1 and 2 in the first two cells.
2. Drag the fill handle .
3. If needed, click Auto Fill Options. and choose the option you want.