A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I preserve font/size when sending text to a different cell



 
 
Thread Tools Display Modes
  #1  
Old May 27th, 2010, 11:40 PM posted to microsoft.public.excel.worksheet.functions
Robert
external usenet poster
 
Posts: 717
Default How do I preserve font/size when sending text to a different cell

I am making a template for a restaurant menu and have the complete menu
listed on the page. The menu I am creating is on the same page and would
allow me to select only items a customer may want on a "personalized menu".
So, I have set up formulas to insert the items I check off on the complete
menu to be automatically inserted on the personalized(or limited) menu.
There are different fonts and sizes to the text I am inserting. Is there a
way to keep these so that what is inserted is exactly the same font and size
as on the complete menu?
  #2  
Old May 28th, 2010, 02:18 AM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default How do I preserve font/size when sending text to a different cell

Formulas return values only.

Formatting must be done separately.

Conditional Formatting may do the trick for you.


Gord Dibben MS Excel MVP


On Thu, 27 May 2010 15:40:01 -0700, Robert
wrote:

I am making a template for a restaurant menu and have the complete menu
listed on the page. The menu I am creating is on the same page and would
allow me to select only items a customer may want on a "personalized menu".
So, I have set up formulas to insert the items I check off on the complete
menu to be automatically inserted on the personalized(or limited) menu.
There are different fonts and sizes to the text I am inserting. Is there a
way to keep these so that what is inserted is exactly the same font and size
as on the complete menu?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:20 PM.


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