Quick Answer: How Do You Make Excel Remember Names?

How do you repeat names in Excel?

Click the [Page Layout] tab > In the “Page Setup” group, click [Print Titles].

Under the [Sheet] tab, in the “Rows to repeat at top” field, click the spreadsheet icon.

Click and select the row you wish to appear at the top of every page.

Press the [Enter] key, then click [OK]..

How do you AutoFill in Excel without dragging?

Quickly Fill Numbers in Cells without DraggingEnter 1 in cell A1.Go to Home –> Editing –> Fill –> Series.In the Series dialogue box, make the following selections: Series in: Columns. Type: Linear. Step Value: 1. Stop Value: 1000.Click OK.

How do you print titles in Excel?

Print row or column titles on every pageClick the sheet.On the Page Layout tab, in the Page Setup group, click Page Setup.Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat.Click OK.On the File menu, click Print.

How do I autofill dates in Excel?

Create a list of sequential datesSelect the cell that contains the first date. Drag the fill handle across the adjacent cells that you want to fill with sequential dates.Select the fill handle. at the lower-right corner of the cell, hold down, and drag to fill the rest of the series. Fill handles can be dragged up, down, or across a spreadsheet.

How do I turn on Fill Series in Excel?

Fill handle is the feature that allows you to select a series of cells with incremental values and drag the cell corner to complete the series.Click File.Click Options.Click the Advanced tab.Select the check-box Enable fill handle and cell drag-and-drop.Click OK.Jun 7, 2014

How do I AutoFill names in Excel?

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. Or, say you have information in Excel that isn’t formatted the way you need it to be, such as this list of names.

How do I create a custom AutoFill in Excel?

Click the cell with the first entry in the custom series and then drag the mouse or Touch pointer through the range until all the cells with entries are selected. … Select File→Options→Advanced (Alt+FTA) and then scroll down and click the Edit Custom Lists button located in the General section.More items…

How do I AutoFill in Excel using keyboard?

For auto-filling months or days, select Autofill option and then ENTER. Use Ctlr+Down/Right key to select the cells you want to fill and press Ctrl+D (to fill down) or Ctrl+R (to fill right).

Where is the fill handle in Excel?

To use the fill handle: Select the cell(s) containing the content you want to use. The fill handle will appear as a small square in the bottom-right corner of the selected cell(s). Click, hold, and drag the fill handle until all of the cells you want to fill are selected. Release the mouse to fill the selected cells.

How do I fix AutoFill in Excel?

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 create a custom list in Excel?

Create a custom listFor Excel 2010 and later, click File > Options > Advanced > General > Edit Custom Lists.For Excel 2007, click the Microsoft Office Button. … In the Custom Lists box, click NEW LIST, and then type the entries in the List entries box, beginning with the first entry. … When the list is complete, click Add.More items…

What are field names in Excel?

Each item of information in a database record, such as a telephone number or street number, is referred to as a field. In Excel, the individual cells of a worksheet serve as fields, since each cell can contain a single piece of information about an object.

How do I create a custom header in Excel?

Excel displays the Page Setup dialog box. On the Header/Footer tab, click Custom Header or Custom Footer. Click in the Left, Center, or Right section box, and then click any of the buttons to add the header or footer information that you want in that section.