Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-11-2014, 11:33 AM
JenK JenK is offline Setting formatting for field with email hyperlink Windows Vista Setting formatting for field with email hyperlink Office 2007
Novice
Setting formatting for field with email hyperlink
 
Join Date: Feb 2014
Posts: 3
JenK is on a distinguished road
Default Setting formatting for field with email hyperlink


I maintain a membership roster using Excel 2007. The roster includes a column for each member's email address, and I've formatted this column so the text appears in plain text. However, every time I add or update an email address, that cell's formatting automatically inserts a hyperlink with a tiny font, forcing me to remove the hyperlink and change the font to the one set for the rest of the worksheet.

I've tried everything I can think to format this column so the format of these cells never changes when I add/update an email address.

There's probably a simple way but I cannot find it. How can I do this?

Thank you!
Reply With Quote
  #2  
Old 02-12-2014, 09:06 PM
DBlomgren DBlomgren is offline Setting formatting for field with email hyperlink Windows 8 Setting formatting for field with email hyperlink Office 2013
Advanced Beginner
 
Join Date: Feb 2014
Location: New York, USA
Posts: 82
DBlomgren is on a distinguished road
Default

Hi, Jenk,
According to this page, there's an easy way and a hard way. I would go with the easy way - type a hyphen at the beginning of every email address. Now, if you have hundreds of addresses already entered (or even just 20), the easiest way to change all of them that I know of is to change the first one, tab down to the next address and type Ctrl-Y, which means "do what I just did to the last field." So one hand presses the down arrow and the other hand stretches to do Ctrl-Y. It's quite fast and easy, especially if you ever played a keyboard.
Reply With Quote
  #3  
Old 02-13-2014, 10:38 PM
JenK JenK is offline Setting formatting for field with email hyperlink Windows Vista Setting formatting for field with email hyperlink Office 2007
Novice
Setting formatting for field with email hyperlink
 
Join Date: Feb 2014
Posts: 3
JenK is on a distinguished road
Default

Hi, thank you for your reply. All of the fields in the email column already have the formatting I want - it's only in a new row or when I update the email address in an existing row that the email address defaults to a hyperlink in a tiny font.

I solved this by creating a macro! The macro includes all the steps I use to re-format the email address (remove hyperlink, change font style, change font size, change to Bold). Now it's just one quick 'n easy step: Ctrl+Shift+M.

My headache is gone! It works!

Jen
Reply With Quote
Reply

Tags
hyperlink text format

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting formatting for field with email hyperlink Hyperlink clicking setting? Thomas G Fields III Outlook 4 10-30-2012 07:36 AM
Copy formatting setting between images on the slide pogonoforysci1 PowerPoint 11 08-10-2012 03:54 AM
Setting up multiple free email accounts in Outlook Jennifer Murphy Outlook 0 05-27-2012 07:36 AM
Setting formatting for field with email hyperlink Setting up Cpanel email in Outlook 2010 jll4w25 Outlook 1 02-13-2012 11:12 AM
Setting an Assignment Field from VBA CGM3 Project 1 10-05-2010 05:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft