Microsoft Office Tutorials and References
In Depth Information
Fill a Range with the Same Data
Working with Ranges
Fill a Selected Range
1 Select the range you want
to fill.
2 Type the text, number, or
other data.
3 Press
B Excel fills the range with
the value you typed.
How do I fill a vertical or horizontal range without also copying the formatting of the
original cell?
Follow these steps:
1 Perform Steps to to fill the data. 4
A Excel displays the AutoFill Options smart tag (
2 Click the AutoFill Options
3 Click Fill Without
Formatting .
Excel removes the original
cell’s formatting from the
copied cells.
Search JabSto ::

Custom Search