View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Hiii - Please help

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.