DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact

Set (fill) Cells of a Range to One or Several Values

Select one or multiple ranges, set the cells in the selected area to one or several user inputted values.
  1. Select one or several ranges. Use Ctrl+Select to select multiple ranges.

    Set (fill) range to values
    Practice file - fill-range-demo.xls (16k)

  2. Invoke 'DigDB->Selected Area->Set Cells to->Values...'

    Set (fill) range to values

    Set (fill) range to values

  3. Enter one or multiple values. Click 'Add >>' to enter more values. The values will rotate in the cells evenly.

    Set (fill) range to values

  4. Result - all cells in selection will be overwritten by the value(s) you entered.

    Set (fill) range to values

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact | Excel Resume Examples ( wehtwrjw )

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.