• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Filling a Range

If you need to fill a range with a particular value or formula, Excel gives you two methods:

  • Select the range you want to fill, type the value or formula, and press Ctrl+Enter. Excel fills the entire range with whatever you entered in the formula bar.

  • Enter the initial value or formula, select the range you want to fill (including the initial cell), and choose Edit, Fill. Then choose the appropriate command from the submenu that appears. For example, if you're filling a range down from the initial cell, choose the Down command. If you've selected multiple sheets, use Edit, Fill, Across Worksheets to fill the range in each worksheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint