Computer Help A to Z Easy Tips
Computer Help Made Simple
Home Mobile Computing John & Renie Computer Terms DLLs & Drivers Links
Computer Threats Computer Basics Hardware Software Easy Tips Tech Talk


Using Fill in Excel
by John Anthony


Excel allows you to automatically fill the same text or formula in as many cells as you want with just a few simple steps.

For example, copy the number 10 in the first 100 rows of a column in a spreadsheet:


For Excel 2010
  1. Begin by entering 10 in the cell at row 1, column A.

  2. Put your mouse pointer over the lower right corner of this cell, hold down the left mouse button and drag it down the column to row 100.

  3. Release the button and 10 is copied into all cells down to and including cell 100.

For Excel 2000
  1. Begin by entering 10 in the cell at row 1, column A.

  2. Put your mouse pointer over the cell, hold down the left mouse button and drag it down the column to row 100. Release the button and all 100 cells in column A are selected.

  3. Click Edit on the menu bar and select 'Fill' from the drop-down menu.

  4. Select 'Down' from the list that appears and 10 is copied into each selected row of column A.
rule

Contact Information

Computer Help A to Z
88 Windmere Drive
Angier, NC 27501

ComputerHelpAtoZ@embarqmail.com

Copyright 2000-2015

Home Mobile Computing John & Renie Computer Terms DLLs & Drivers Links
Computer Threats Computer Basics Hardware Software Easy Tips Tech Talk