Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
bob777
 
Posts: n/a
Default Keeping cell formatting


cell A1 is red font 8, cell B1 is blue font 16.

I wish to copy cell A1 to cell B1, and retain the blue font 16. Can
this be done without macros, please.

thank you. Bob777


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=484262

  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default Keeping cell formatting

Paste special and select values

--

Regards,

Peo Sjoblom

"bob777" wrote in
message ...

cell A1 is red font 8, cell B1 is blue font 16.

I wish to copy cell A1 to cell B1, and retain the blue font 16. Can
this be done without macros, please.

thank you. Bob777


--
bob777
------------------------------------------------------------------------
bob777's Profile:

http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=484262



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
Conditional formatting a full row triggered by a single cell reference... neilcarden Excel Worksheet Functions 1 August 17th 05 02:59 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
cell formatting problems jazzsax505 New Users to Excel 2 May 29th 05 10:30 PM
Protect Cell Formatting Bill Schnur Excel Worksheet Functions 1 March 23rd 05 02:53 AM
Formatting dates in the future Compass Rose Excel Worksheet Functions 3 January 17th 05 10:39 PM


All times are GMT +1. The time now is 04:22 PM.

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

About Us

"It's about Microsoft Excel"