Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Format fonts (ie, initial cap) in Excel like you can in Word.
Why is the formatting of fonts in Excel limited compared to Word? I have a
document that has "descriptions" and we want to initial cap the verbiage. The only way that I know to do it is to go in and either delete and re-type the letter or use the Insert feature. It would be nice to be able to click an entire column, click Format, Font, Change Case, Initial Cap like you can in Word. Talk about saving keystrokes!!!! Thank you. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
|
|||
|
|||
One work-around is to use a helper column with the formula
=PROPER(A1) where the offending text is in A1. Once the conversion is done, you can Copy/Paste Special the helper column to values and delete the original column. hth ScottO "gojackets1979" wrote in message ... | Why is the formatting of fonts in Excel limited compared to Word? I have a | document that has "descriptions" and we want to initial cap the verbiage. | The only way that I know to do it is to go in and either delete and re-type | the letter or use the Insert feature. It would be nice to be able to click | an entire column, click Format, Font, Change Case, Initial Cap like you can | in Word. Talk about saving keystrokes!!!! Thank you. | | ---------------- | This post is a suggestion for Microsoft, and Microsoft responds to the | suggestions with the most votes. To vote for this suggestion, click the "I | Agree" button in the message pane. If you do not see the button, follow this | link to open the suggestion in the Microsoft Web-based Newsreader and then | click "I Agree" in the message pane. | | http://www.microsoft.com/office/comm....mspx?mid=73d8 26aa-2f00-4f67-a3e0-c91c384b9ff7&dg=microsoft.public.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, It wont print in landscape format | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
How do I convert Excel 2003 to Excel 98 format? | New Users to Excel | |||
How do I embed fonts in excel? | Setting up and Configuration of Excel |