Hiii - Please help

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.

Bob
Thu Jul 24 03:25:27 CDT 2008

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

--
__________________________________
HTH

Bob

"Fuzzy" <Fuzzy@discussions.microsoft.com> wrote in message
news:EF19044D-8F3B-4119-8155-809A0607BFD1@microsoft.com...
> 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.

Fuzzy
Thu Jul 24 03:32:00 CDT 2008

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" <Fuzzy@discussions.microsoft.com> wrote in message
> news:EF19044D-8F3B-4119-8155-809A0607BFD1@microsoft.com...
> > 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.
>
>
>

Bob
Thu Jul 24 04:09:20 CDT 2008

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

--
__________________________________
HTH

Bob

"Fuzzy" <Fuzzy@discussions.microsoft.com> wrote in message
news:C61D89E7-726F-4116-8CF9-633AA5BAB3E0@microsoft.com...
> 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" <Fuzzy@discussions.microsoft.com> wrote in message
>> news:EF19044D-8F3B-4119-8155-809A0607BFD1@microsoft.com...
>> > 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.
>>
>>
>>

Pete_UK
Thu Jul 24 04:16:20 CDT 2008

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

Pete

On Jul 24, 9:32=A0am, Fuzzy <Fu...@discussions.microsoft.com> wrote:
> Nope Bob. That will not serve my purpose. Coz I would still need to conti=
nue
> clicking on that icon. I am copying the data one by one. As in i copy Cel=
l
> 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" <Fu...@discussions.microsoft.com> wrote in message
> >news:EF19044D-8F3B-4119-8155-809A0607BFD1@microsoft.com...
> > > 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 rem=
ember
> > > the last copied data. Is there any thing I could do to color the cell=
s
> > > 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 -

Fuzzy
Thu Jul 24 04:23:00 CDT 2008

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" <Fuzzy@discussions.microsoft.com> wrote in message
> news:C61D89E7-726F-4116-8CF9-633AA5BAB3E0@microsoft.com...
> > 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" <Fuzzy@discussions.microsoft.com> wrote in message
> >> news:EF19044D-8F3B-4119-8155-809A0607BFD1@microsoft.com...
> >> > 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.
> >>
> >>
> >>
>
>
>

Fuzzy
Thu Jul 24 05:00:00 CDT 2008

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 <Fu...@discussions.microsoft.com> 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" <Fu...@discussions.microsoft.com> wrote in message
> > >news:EF19044D-8F3B-4119-8155-809A0607BFD1@microsoft.com...
> > > > 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 -
>
>

Pete_UK
Thu Jul 24 05:27:53 CDT 2008

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=A0am, Fuzzy <Fu...@discussions.microsoft.com> wrote:
> The idea is - =A0not 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

NPell
Thu Jul 24 08:25:53 CDT 2008

On 24 Jul, 11:27, Pete_UK <pashu...@auditel.net> 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=A0am, Fuzzy <Fu...@discussions.microsoft.com> wrote:
>
>
>
> > The idea is - =A0not to use the mouse. f
> > or copying, i just use Ctrl C..... for color i wanted a similar short c=
ut...
> > :)
>
> > "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.