Force format

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Hi -
I am using XL 2003 and would like to 'force' a sheet that I work on
frequently to apply formatting to text / numbers upon input. For example, I
often cut and paste data from one spreadsheet to the other, when pasting,
the formatting follows the data and must then be reformatted.
Is there a way that I can apply a format to a cell [example arial font,
sized 12] so when I paste in 'eurostyle font, size 7, it changes the font
automatically ?
Thanks!
 
Alan, the easiest way to accomplish this is to use the Paste Special command
and paste the data as values. Just right-click the destination cell and
select Paste Special --> Values --> OK. The data will take on the formatting
of the destination cell.

DDM
"DDM's Microsoft Office Tips and Tricks"
http://ddmara.tripod.com
 
Works great - thanks!

DDM said:
Alan, the easiest way to accomplish this is to use the Paste Special command
and paste the data as values. Just right-click the destination cell and
select Paste Special --> Values --> OK. The data will take on the formatting
of the destination cell.

DDM
"DDM's Microsoft Office Tips and Tricks"
http://ddmara.tripod.com

Alan said:
Hi -
I am using XL 2003 and would like to 'force' a sheet that I work on
frequently to apply formatting to text / numbers upon input. For
Click to expand...
example,
I
often cut and paste data from one spreadsheet to the other, when pasting,
the formatting follows the data and must then be reformatted.
Is there a way that I can apply a format to a cell [example arial font,
sized 12] so when I paste in 'eurostyle font, size 7, it changes the font
automatically ?
Thanks!
Click to expand...
Click to expand...
 
Hi Alan,

Try this

Create styles directly from cells in Microsoft Exce

Tip taken from chapter 5 in the book Mr Excel On Excel

Add the Style icon to the Formatting toolbar.

Select a toolbar.
Right-click, and in the shortcut menu select Customize.
Select the Commands tab. In the Categories box, select Format.
From the Commands box, select Style. Drag the command to th
Formatting toolbar, and drop it near the Font icon.
Create styles directly from cell
After you format a cell, you can quickly and easily save that forma
as a style by entering the name of the style in the Style box an
then pressing Enter.

Not
After you have added the Style icon to the toolbar, using the Alt+
shortcut lets you select the Style in the icon itself. It does no
open the Style dialog box

This was mailed to me from the exceltip.com mailing list!

Very helpful

M
 
Back
Top