Simple Formatting

PrinceNeptune

Board Regular
Joined
Jan 30, 2006
Messages
209
Hi All,

I'm wondering if in Excel 2003 if there is a way to use the Format Painter that allows you to keep clicking the items you want to format. I have goofed around with different keystrokes, but have not been able to find a method for this.

Thanks for the help.
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Mike Blackman

Well-known Member
Joined
Jun 8, 2007
Messages
2,494
Hi,

Copy a cell that has the desired format; then whilst holding the control button select all the ranges that you need to copy the format to - Right Click - PasteSpecial - Formats
 

PrinceNeptune

Board Regular
Joined
Jan 30, 2006
Messages
209
Perfect. I never would have used copy thinking that it would take the value stored in the cell as well.

Thanks for the help.
 

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Actually, you CAN use the Format Paintbrush. When you select it, simply use a DoubleClick instead of a single click. It will now remain active until you re-click it.
lenze
 

Watch MrExcel Video

Forum statistics

Threads
1,127,485
Messages
5,625,042
Members
416,067
Latest member
newb08

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top