Is there a way to do the following:

Fill a column with a text "Sales" for all rows until the last row of the
data set without having to drag the first cell all the way down?

Fill a column with a seriers "1, 2, 3" for all rows until the last row of
the data set without having to drag the first cell all the way down?
--
--coastal