Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2013, 07:19 AM
Ray1853 Ray1853 is offline Formatting autocorrect entries Windows Vista Formatting autocorrect entries Office 2010 64bit
Novice
Formatting autocorrect entries
 
Join Date: Feb 2013
Posts: 2
Ray1853 is on a distinguished road
Default Formatting autocorrect entries

Can you format autocorrect additions in Excel 2010?
Reply With Quote
  #2  
Old 02-22-2013, 02:44 AM
macropod's Avatar
macropod macropod is offline Formatting autocorrect entries Windows 7 64bit Formatting autocorrect entries Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

AFAIK, no. Autocorrect corrects content, not formatting. See: http://office.microsoft.com/en-us/ex...001034630.aspx
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-22-2013, 07:43 AM
Ray1853 Ray1853 is offline Formatting autocorrect entries Windows Vista Formatting autocorrect entries Office 2010 64bit
Novice
Formatting autocorrect entries
 
Join Date: Feb 2013
Posts: 2
Ray1853 is on a distinguished road
Default

Agreed. But I am using autocorrect to speed input. For example, I might add an entry "CS" for "consulting service"and thereafter whenever I type CS, Excel displays consulting service.

In Word, you can format the replacement text, for example adding italics to all or part of the text. To clarify my original question, I am wondering if anyone has found a way to do the same in Excel.
Reply With Quote
  #4  
Old 02-22-2013, 07:59 PM
macropod's Avatar
macropod macropod is offline Formatting autocorrect entries Windows 7 64bit Formatting autocorrect entries Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

That would probably require a macro to go through the worksheet, looking for specified cell contents (after the autocorrect has been applied), then formatting those strings as desired.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
autocorrect, formatting-issue



Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there any clever way to synchro AutoCorrect entries among different computers? New Daddy Word 4 02-25-2013 10:05 AM
How are you meant to print added AutoCorrect entries? anon93 Word 1 03-27-2012 11:11 PM
Autocorrect entries with astrix at the end dswapp Word 2 02-14-2011 09:34 AM
Using Word autocorrect and autotext entries in outlook dswapp Outlook 2 11-24-2010 10:18 AM
Moving AutoCorrect Entries from 2003 to 2007 jim-shrader Word 0 05-10-2008 11:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:10 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