Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Painter
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Painter
It is all in the wrist. Your problem is the second click;
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 apply the formatting. 4. release mouse button Just combine 2 & 3 - click and drag. The Format Painter icon should be visible in the worksheet area as you drag. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Fay" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Painter Question | Excel Discussion (Misc queries) | |||
how can I use the format painter?? | New Users to Excel | |||
shortcut for format painter | New Users to Excel | |||
Can I use format painter (or F4) in a chart? | Charts and Charting in Excel | |||
Shortcut to format painter | Excel Discussion (Misc queries) |