Free Microsoft Excel 2013 Quick Reference

Shortcut to format painter

Is ther a keyboard shortcut to the format painter and if not what is the code
line i should use to create my own shortcut plaese


Post your answer or comment

comments powered by Disqus
I need help to assign shortcut key for format painter

Hello,

Can you please help me, my question is what is the keyboard shortcut of format painter in excel2003

regards
rahul

I would like to add the Format Painter command to the right click short cut menu. Has anyone done this or know how?

Mike

I have cells in Excel with text in two different colors (ie.
blk_txt/blu_txt). I can't get format painter or copy & paste spacial to copy
this format to another cell. It just copies the text in blk_txt only. Is
there a way around this or is by default the way Excel works.

I use graphs quite extensively in Excel and often need to change colors of
alot of bars in a bar graph. Using the format painter will make this go alot
quicker

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting


Hello ,
I'm trying to solve 2 of my excel problems :
>
1. a function or macro that allows to determine which font and/or
background colour were assigned due to the conditional formatting of a
cell.
2. a way to include a hyperlink or a shortcut to a directory that runs
explorer to open that directory
>
any idea's in this usergroup ?

Peter

I have cells in Excel with text in two different colors (ie.
blk_txt/blu_txt). I can't get format painter or copy & paste spacial to copy
this format to another cell. It just copies the text in blk_txt only. Is
there a way around this or is by default the way Excel works.


Hello ,
I'm trying to solve 2 of my excel problems :
>
1. a function or macro that allows to determine which font and/or
background colour were assigned due to the conditional formatting of a
cell.
2. a way to include a hyperlink or a shortcut to a directory that runs
explorer to open that directory
>
any idea's in this usergroup ?

Peter

I am trying to create a macro that when I press Ctrl+m, it would be as if I
am pressing the format painter icon. I tried recording a macro and each
time I press ctrl+m, it copies the cell, but not the format. Could someone
tell me how to create the macro to copy the format only of a cell?

Thanks Again as I am a newbie when it comes to macros/vba

JD

I am trying to create a cell that will assess another cell and, depending on what value is in the cell, a point value will be given. I actually need the "Points" cell to assess more than one cell and that is where I am running into a problem.

In other words, the "Points" cell is A8. If A1 is between 90% and 100% then 10 points should be added to A8. If A1 is between 80% and 89% then 8 points will be added to A8 and so forth. I also need cell A8 to populate with the same scale for other cells. So if it is 95% in A1, 86% in A3 and 91% in A5 then A8 should have 28 points. I will also need to use the format painter to drag this formula through 30 rows on several different sheets in the same workbook.

Thanks for any help you can give me.

I use graphs quite extensively in Excel and often need to change colors of
alot of bars in a bar graph. Using the format painter will make this go alot
quicker

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

I've been working on a particular spreadsheet and I've just noticed that
double clicking the format painter will only format one cell. It won't
retain the format to be put into the next selected cell which it should when
its double clicked. The same goes for copy and paste. Normally once you've
copied something you can paste it into a number of cells individually, one
after the other, but after the first paste selection, the paste option is no
longer available.

I can't see any settings under options to fix this. What has happened, and
how do I fix it? (I'm using Excel 2003 SP1 - is there a SP2?)

Thanks,
Ken G.

Is there a keyboard shortcut to format cells in order to centre the contents?

Hello,

Does anyone have a speedy way to alter the formats of several data series (but not all) in a chart?

I'd like the chart equivalent of the "Format Painter", but it always goes gray when a chart is selected.

Many thanks
Ben

The format painter icon keeps appearing when I add or delete columns and rows
- it keeps blocking me from seeing what is in the cell and is a general
nuisance. I do not need the format painter, but I cant seem to find a way to
deactivate it, permanently if possible. Anyone have any ideas?

I took a peek at the 'What's New' tutorial when I started using Excel 2003
last year and remember that there was a keyboard shortcut to insert a bullet.
It involved using the 'a' key but can't remember the rest. I'm getting tired
of manually formatting the bloody thing and hope someone knows the shortcut.

When working on repetitive tasks I would like to have the Format Painter Icon
on my menu when I right click on a cell. How can I place it there?

Hi! I had a question using the format painter in the new Excel 2007 for
conditional formatting. In my "old" version of Excel, if I had a conditional
format in cell F5, I could format paint that conditional formatting from F6
through F200, and the relative reference that I used in F5 would update in
F6, F7, F8, etc.

Now, however, when I do that same function, all of the conditional
formatting for F6 through F200 uses the relative reference of F6. The only
way I've found to do this is to double-click the format painter, and
individually click F6, and then F7, and then F8, etc.

I'm pretty good at clicking, but this is too much - even for me! please help?

Why doesn't the Format Painter work for Excel chart titles? When I highlight
a chart title or axis title, the Format Painter remains grayed out. Without
this utility, I don't know how to copy one chart title to another chart title
without losing all the text formatting, which is extensive in my case (math
symbols etc.) Thanks for any suggestions!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

When I wish to format several cells the same I double click the format
painter and I am able to format each cell without reclicking the button. I
have just upgraded to Excel 2003 and now I can only do that on a worksheet
that hasn't any VBA code attached. Is this a bug? I know other people on Mr
Excel are having the same problem and no one seems to have an answer. Thanks
for any response or help you may give me.

The shortcut to enter the current time in an Excel workbook should include
seconds. Currently, if you hit CTRL+: (SHIFT the current time is
displayed in the appropriate cell as 1:14 PM b default. Formatting the time
to read h:mm:ss, it is displayed with the seconds as :00

Demo: Copy formatting in a single click with Format Painter

</img>
Use the Format Painter to copy formatting from one item to another in Office 2003.

Hi everyone,

I would be grateful if someone could help me with a problem related to format painting conditional formatting to other cells in Excel 2007.

The problem comes from continually having to use Excel 2007 at home to work on spreadsheets for work which are 2003 versions. The compatibility conflicts invariably come from overlapping conditional formatting, and part of the problem is having only just discovered what seems to be (maybe its something I don't understand) a bug in 2007?

In Excel 2003, if you painted a format from one cell to another, it completely replaced whatever format was there, including the conditional formatting.

In 2007, if you paint a format onto a cell, it doesn't replace the conditional formatting, but merely adds to the conditional formatting which was already there .... even if it's the exact same conditional formatting! As an example, if I paint a format from A1 to B1 that says if the cell says "Yes" colour it red, and I paste the format into that cell 8 times, in the 'Manage Conditional Formatting' there will be eight copies of the exact same conditional formatting saying if the cell says "Yes" colour it red.

To use the paint metaphor, when I paint a door, I like to take the all the paint off back to the bare wood, not continually paint on top of the old paint

Just wondered if there was any option to change the way format painter works in 2007 so it works the same as it does in 2003?

Thank you everyone/anyone for any help you can offer.

I am using Excel 2007 SP2. When I try to copy a formula using Ctrl+C / Copy button and paste using Ctrl+V or paste button, only the copied value is pasted.

If I copy using Ctrl+C in C1 and then select cells C2-C3 and try to paste using Ctrl+V, I get a message that the data on the clipboard is not the same size and shape as the selected area, do you want to paste the data anyway?

I also tried to cut any cell value but instead of cut it is copying the value.

Format painter is not also working.

I've tried rebooting, repair, re installation of Excel, all to no avail. Please suggest a solution...


No luck finding an answer? You could always try Google.