I have tried the way it says to extend my formating down the column but it is
not working.  Here is what I am doing 1. click cell with formatting I want to
apply. 2. click format painter button. 3.click and drag mouse to select cells
i want to appy the formatting. 4. release mouse button.. It says the
formatting is applie to the data in the selected cells. No, it isn't. I go to
an empty cell in the worksheet and add data to be used and the formatting is
not there.
What am I doing wrong. These instructions are from the Microsoft Excel book.