Copy Cell Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Perhaps this is the wrong forum, however, someone will probably know.

In cell A1 on sheet2: =Sheet1!A1

This copies the contents correctly. Any ideas how to copy the cell
formating, specfically the borders, text colors, and shading.

I don't really need VBA code, just the simple Excel
properties/formulas/functions

Thanks in advance,

Christmas May
 
When Sheet1 cell A1 is selected, press Edit-Copy
Select sheet 2 cell a1
Press Edit-Paste-Special-Formats
 
Formulas can't return this kind of formatting.

Copy|paste (manually or through code) is one way.

Another (kind of ugly) way:
Select A1 on Sheet1
edit|Copy
goto sheet2, A1
Shift-Edit|Paste picture link

Leave the formula there (or point back to the original source in all your
subsequent formulas).
 

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

Copy the formatting of one cell to other cell 5
Excel VBA help: Text file formatting 19
format on change event 4
Conditional Formatting macro: simple, but doesn't work 6
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Copying Sheet1 to Sheet2 in a certain pattern 6
Excel VBA 1
Extracting a Part of a Formula as Text 5

Back
Top