ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Font Size (https://www.excelbanter.com/excel-discussion-misc-queries/199387-font-size.html)

George

Font Size
 
I have an Excel spread sheet and have changed all the font sizes to 7, when I
enter a new email address in one of the cells, the font size automaticaly
changes to 10. How can i stop this from happening?

Mike H

Font Size
 
try,

Format|Style
Select Hyperlink
Modify to suit your requirements

Mike

"George" wrote:

I have an Excel spread sheet and have changed all the font sizes to 7, when I
enter a new email address in one of the cells, the font size automaticaly
changes to 10. How can i stop this from happening?


Bob Umlas, Excel MVP

Font Size
 
Tools/Autocorrect options/middle tab (Autoformat as you type), deselect first
checkbox
OR
FIRST type an apostrophe (') then the email address.
HTH

"George" wrote:

I have an Excel spread sheet and have changed all the font sizes to 7, when I
enter a new email address in one of the cells, the font size automaticaly
changes to 10. How can i stop this from happening?



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com