filling in all column with 9

[monkfunk]

lets say I have 1000 rows and I want to fill every cell in column b with the number 9, how can I do that?

thanks~

[VBA Noob]

Select the cells and while selected click in the formula bar and type 9 then press ctrl + enter

or

enter 9 in the first cell select the first cell down to the last then edit > fill > series

or use the fill handle to drag down

http://www.mvps.org/dmcritchie/excel/fillhand.htm

VBA Noob

[skatmandu2002]

In the first cell type '=9'

Then autofill down to the last row. To autofill, click on the cell, click and drag the little black box on the bottom right of the cell outline.

[sglife]

Please Login or Register  to view this content.