Is there any shortcut key (like Ctl C for copy) that we can use for Coloring
a cell.

I actually need to copy certain data from an excel sheet to another system.
Since this is a fairly large data, it becomes difficult for me to remember
the last copied data. Is there any thing I could do to color the cells that
have been copied?
THis way, I will kno that all the cells colored in a particular color are
the ones that have been copied already.

How about the format painter icon, the one that looks like a paintbrush?

--
__________________________________
HTH

Bob

"Fuzzy" wrote in message
...
Is there any shortcut key (like Ctl C for copy) that we can use for
Coloring
a cell.

I actually need to copy certain data from an excel sheet to another
system.
Since this is a fairly large data, it becomes difficult for me to remember
the last copied data. Is there any thing I could do to color the cells
that
have been copied?
THis way, I will kno that all the cells colored in a particular color are
the ones that have been copied already.

Nope Bob. That will not serve my purpose. Coz I would still need to continue
clicking on that icon. I am copying the data one by one. As in i copy Cell
A1, paste it into the system. Come back to the excel, Copy Cell A2, paste it
into the system.
So each time i do this, i would need to keep using the format paint brush.
I was just wondering if we have a short cut to color a cell. As in, i do
Ctrl "x" (for coloring, then i do Ctrl "C" and then paste this data.


"Bob Phillips" wrote:

How about the format painter icon, the one that looks like a paintbrush?

--
__________________________________
HTH

Bob

"Fuzzy" wrote in message
...
Is there any shortcut key (like Ctl C for copy) that we can use for
Coloring
a cell.

I actually need to copy certain data from an excel sheet to another
system.
Since this is a fairly large data, it becomes difficult for me to remember
the last copied data. Is there any thing I could do to color the cells
that
have been copied?
THis way, I will kno that all the cells colored in a particular color are
the ones that have been copied already.

Are the cells that you are copying different colours/formats, or all the
same? Are they contiguous?

--
__________________________________
HTH

Bob

"Fuzzy" wrote in message
...
Nope Bob. That will not serve my purpose. Coz I would still need to
continue
clicking on that icon. I am copying the data one by one. As in i copy Cell
A1, paste it into the system. Come back to the excel, Copy Cell A2, paste
it
into the system.
So each time i do this, i would need to keep using the format paint brush.
I was just wondering if we have a short cut to color a cell. As in, i do
Ctrl "x" (for coloring, then i do Ctrl "C" and then paste this data.


"Bob Phillips" wrote:

How about the format painter icon, the one that looks like a paintbrush?

--
__________________________________
HTH

Bob

"Fuzzy" wrote in message
...
Is there any shortcut key (like Ctl C for copy) that we can use for
Coloring
a cell.

I actually need to copy certain data from an excel sheet to another
system.
Since this is a fairly large data, it becomes difficult for me to
remember
the last copied data. Is there any thing I could do to color the cells
that
have been copied?
THis way, I will kno that all the cells colored in a particular color
are
the ones that have been copied already.

Can't you just click the Fill Color icon immediately before you copy
the cell?

Pete

On Jul 24, 9:32*am, Fuzzy wrote:
Nope Bob. That will not serve my purpose. Coz I would still need to continue
clicking on that icon. I am copying the data one by one. As in i copy Cell
A1, paste it into the system. Come back to the excel, Copy Cell A2, paste it
into the system.
So each time i do this, i would need to keep using the format paint brush..
I was just wondering if we have a short cut to color a cell. As in, i do
Ctrl "x" (for coloring, then i do Ctrl "C" and then paste this data.



"Bob Phillips" wrote:
How about the format painter icon, the one that looks like a paintbrush?

--
__________________________________
HTH

Bob

"Fuzzy" wrote in message
...
Is there any shortcut key (like Ctl C for copy) that we can use for
Coloring
a cell.

I actually need to copy certain data from an excel sheet to another
system.
Since this is a fairly large data, it becomes difficult for me to remember
the last copied data. Is there any thing I could do to color the cells
that
have been copied?
THis way, I will kno that all the cells colored in a particular color are
the ones that have been copied already.- Hide quoted text -

- Show quoted text -

Nope. I need to copy the Invoice Date, Customer's Name, the Contact Number,
the address, date of delivery, etc. So the formats are not the same. And they
are not contiguous!
I might have to copy row 1 first...then i need to copy row 10...depending on
the date of delivery.

"Bob Phillips" wrote:

Are the cells that you are copying different colours/formats, or all the
same? Are they contiguous?

--
__________________________________
HTH

Bob

"Fuzzy" wrote in message
...
Nope Bob. That will not serve my purpose. Coz I would still need to
continue
clicking on that icon. I am copying the data one by one. As in i copy Cell
A1, paste it into the system. Come back to the excel, Copy Cell A2, paste
it
into the system.
So each time i do this, i would need to keep using the format paint brush.
I was just wondering if we have a short cut to color a cell. As in, i do
Ctrl "x" (for coloring, then i do Ctrl "C" and then paste this data.


"Bob Phillips" wrote:

How about the format painter icon, the one that looks like a paintbrush?

--
__________________________________
HTH

Bob

"Fuzzy" wrote in message
...
Is there any shortcut key (like Ctl C for copy) that we can use for
Coloring
a cell.

I actually need to copy certain data from an excel sheet to another
system.
Since this is a fairly large data, it becomes difficult for me to
remember
the last copied data. Is there any thing I could do to color the cells
that
have been copied?
THis way, I will kno that all the cells colored in a particular color
are
the ones that have been copied already.

The idea is - not to use the mouse. f
or copying, i just use Ctrl C..... for color i wanted a similar short cut...
:)

"Pete_UK" wrote:

Can't you just click the Fill Color icon immediately before you copy
the cell?

Pete

On Jul 24, 9:32 am, Fuzzy wrote:
Nope Bob. That will not serve my purpose. Coz I would still need to continue
clicking on that icon. I am copying the data one by one. As in i copy Cell
A1, paste it into the system. Come back to the excel, Copy Cell A2, paste it
into the system.
So each time i do this, i would need to keep using the format paint brush..
I was just wondering if we have a short cut to color a cell. As in, i do
Ctrl "x" (for coloring, then i do Ctrl "C" and then paste this data.



"Bob Phillips" wrote:
How about the format painter icon, the one that looks like a paintbrush?

--
__________________________________
HTH

Bob

"Fuzzy" wrote in message
...
Is there any shortcut key (like Ctl C for copy) that we can use for
Coloring
a cell.

I actually need to copy certain data from an excel sheet to another
system.
Since this is a fairly large data, it becomes difficult for me to remember
the last copied data. Is there any thing I could do to color the cells
that
have been copied?
THis way, I will kno that all the cells colored in a particular color are
the ones that have been copied already.- Hide quoted text -

- Show quoted text -

Yes, but if you are not using the mouse for copying, then you can
leave the mouse pointer resting on the Fill icon and then you only
need to click the mouse button - similar to a keyboard in this respect
<g.

Pete

On Jul 24, 11:00*am, Fuzzy wrote:
The idea is - *not to use the mouse. f
or copying, i just use Ctrl C..... for color i wanted a similar short cut....
:)



"Pete_UK" wrote:
Can't you just click the Fill Color icon immediately before you copy
the cell?

Pete

On 24 Jul, 11:27, Pete_UK wrote:
Yes, but if you are not using the mouse for copying, then you can
leave the mouse pointer resting on the Fill icon and then you only
need to click the mouse button - similar to a keyboard in this respect
<g.

Pete

On Jul 24, 11:00*am, Fuzzy wrote:



The idea is - *not to use the mouse. f
or copying, i just use Ctrl C..... for color i wanted a similar short cut...
:)

"Pete_UK" wrote:
Can't you just click the Fill Color icon immediately before you copy
the cell?

Pete- Hide quoted text -

- Show quoted text -

Record a macro of filling the cell.
Then set whatever shortcut you want.

I used to do this, as long as theyre all the same colour its perfect.

Hope this helps.