Microsoft Office Tutorials and References
In Depth Information
Using Auto Fill with Text
Figure 2–33. The Copy Cells option
The Fill Formatting option only copies the formatting associated with the original cells
you’ve copied. Thus if the values 1 and 3 had exhibited a yellow background (we’ll see
how to do that in Chapter 5: "Formatting Your Data") selecting Fill Formatting will result in
this:
Figure 2–34. Fill Formatting—here, the values aren’t filling down the range; only the formatting in the source
cells carries over to the selected cells.
The last option, Fill Without Formatting, executes the fill, but doesn’t copy the formatting
along with it:
 
Search JabSto ::




Custom Search