Use the Fill Handle pp. 4042

  • The Auto Fill Options button appears when you use the fill handle to copy formulas. Clicking this button displays a menu of options you can use immediately after filling cells.

Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.