Microsoft Office Tutorials and References
In Depth Information
Fill a Range with the Same Data
3
chapter
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