Hiii - Please help

  • Thread starter Thread starter Fuzzy
  • Start date Start date
F

Fuzzy

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.
 
Are the cells that you are copying different colours/formats, or all the
same? Are they contiguous?
 
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.
 
The idea is - not to use the mouse. f
or copying, i just use Ctrl C..... for color i wanted a similar short cut...
:)
 
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
 
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




- Show quoted text -
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Run select query from VBA code where criteria comes from a multi select ListBox 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Carrying over background color to another worksheet 4
Conditionally format a cell using a list of data defined in a rang 2
Excel Move or Copy Stopped Working? 0
Cursor color 2
Changing Color of the Cell under Certain Conditions 8

Back
Top