formating

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formating

Formating

resolvedResolved · Low Priority · Version 2007

Gabi has attended:
Excel Intermediate course

Formating

Is there a way to select an unchangeable font size and style for an entire worksheet so that regardless of where you cut & paste from text will always appear in your selected font size and style?

RE: Formating

Hello Gabi,

Thank you for your question regarding formatting.

Unfortunately there is no way to ensure data is always pasted in a specific font and/or size.

One of the quickest solutions though, is to highlight the entire sheet (CTRL + A) then select the desired font and size.

Hope that helps.


Kind regards

Cindy
Microsoft Office Trainer


 

Excel tip:

Paste a web address into the hyperlink address field

If you copy a web address the only way to paste into the address field of the hyperlink box is to use CTRL + V. Right click paste does not work.

View all Excel hints and tips


Server loaded in 0.08 secs.