Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
James C
 
Posts: n/a
Default Copying format to a new cell, w/o overwriting destination cell contents


Is there a way to copy the formatting of an existing cell to a new cell,
w/o overwriting destination cell contents?


--
James C
------------------------------------------------------------------------
James C's Profile: http://www.excelforum.com/member.php...o&userid=12114
View this thread: http://www.excelforum.com/showthread...hreadid=477253

  #2   Report Post  
bill k
 
Posts: n/a
Default Copying format to a new cell, w/o overwriting destination cell contents


the long way
copy ...paste special ....formats

the short way
click onto the cell
click onto copy painter
click onto the new cell

when you double click onto the format painter you can
copy the format onto several individual cells

copy painter is the yellow paint brush in the menu bar with
the copy, paste, and scissors icons.


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=477253

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying the function contained within a cell to anouther cell. DMB Excel Worksheet Functions 2 September 1st 05 05:49 PM
Why does my format keep changing in the cell? Denise Excel Discussion (Misc queries) 0 August 30th 05 04:23 PM
Conversion of Cell Contents into a Functional Worksheet name ? GMJT Excel Worksheet Functions 1 August 21st 05 04:59 PM
format cell from data input to output form Brad Stevenson Excel Worksheet Functions 2 May 19th 05 06:04 PM
Conditional Format based on contents of cell. dave m Excel Worksheet Functions 13 April 29th 05 01:12 PM


All times are GMT +1. The time now is 05:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"