Question

Write down the steps for the use of Custom Lists.

Answer 1

• Enter the Starting Data: Type the first item of your predefined custom list (such as a specific month, weekday, or accounting category) into any blank worksheet cell.
• Activate the Fill Handle: Position your mouse cursor over the bottom-right corner of that active cell until the pointer transforms into a small, solid black plus sign (+) known as the AutoFill handle.
• Drag to Populate: Click and hold the left mouse button, then drag the handle downward through a column or across a row to select the target data range.
• Release to Complete: Release the mouse button. The software will instantly read your custom list from its internal database and automatically populate the remaining items in sequence across the highlighted cells.