Printer Friendly
The Free Library
14,487,363 articles and books
Member login
User name  
Password 
 
Join us Forgot password?

Change the case of text in word--but not in excel.


Q. Is there some fast and easy way to change the case of text in Word and Excel A full-featured spreadsheet for Windows and the Macintosh from Microsoft. It can link many spreadsheets for consolidation and provides a wide variety of business graphics and charts for creating presentation materials. ?

A. You can in Word, but although many users desperately wish they could do it in Excel, I'm sorry to say, they can't yet. I've seen some very complex macros written that are supposed to be effective, but none that I've tried works very well.

In Word, case changing is a snap. One way is to put the Change Case icon on your toolbar A row or column of on-screen buttons used to activate functions in the application. Many toolbars are customizable, letting you add and delete buttons as required. Toolbars may be fixed in position or may float, which means they can be dragged to a more convenient location in the . To do that, click on Tools, Customize, click on the Commands tab, go to Format and then scroll To continuously move forward, backward or sideways through the text and images on screen or within a window. Scrolling implies continuous and smooth movement, a line, character or pixel at a time, as if the data were on a paper scroll being rolled behind the screen. See auto scroll.  down to Change Case. If you keep moving down, you'll notice another Change Case icon: Next to it is an icon with three letter As.

They both can do the job, but they do it in slightly different ways. Drag either the first Change Case or the triple A icon up to your toolbar.

If you choose Change Case, highlight the target text and click on Change Case; the highlighted text will toggle To alternate back and forth between two states.

toggle - To change a bit from whatever state it is in to the other state; to change from 1 to 0 or from 0 to 1. This comes from "toggle switches", such as standard light switches, though the word "toggle" actually refers to
 among upper case, lower case, title case and sentence case. But if you select the triple As, this screen will pop up:

There still is one more way: After highlighting the target text, press Shift +F3; each time you press those buttons, it toggles the text among upper, lower and title case. It doesn't do sentence case unless the highlighted text contains a period or semicolon semicolon: see punctuation.


In programming, the semicolon (;) is often used to separate various elements of an expression. For example, in the C statement for (x=0; x<10; x++)
.
COPYRIGHT 2004 American Institute of CPA's
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 2004, Gale Group. All rights reserved. Gale Group is a Thomson Corporation Company.

 Reader Opinion

Title:

Comment:



 

Article Details
Printer friendly Cite/link Email Feedback
Title Annotation:Technology Q&A
Author:Zarowin, Stanley
Publication:Journal of Accountancy
Date:Nov 1, 2004
Words:239
Previous Article:Save your favorites when switching browrser.(Technology Q&A)
Next Article:Transfer excel formula from one worksheet to another.(Technology Q&A)



Related Articles
Computer technology: grabbing the early advantage.
Software To Scratch Palm's Itchy Niches.(Software Review)(Evaluation)
Show-and-tell in real time: link a spreadsheet to a PowerPoint slide for up-to-the-minute visuals.
Work smarter with Smart Tags: this Office XP feature acts as your very own personal robot. .
Technology Q&A: control Excel's underline function ... learn the nuances of AutoFill ... put worksheets in separate panes ... an easy way to...
Technology Q&A: sort Excel cells that contain text and numbers ... Give Excel cells a descriptive name ... Get Excel to produce the right number of...
Technology Q&A: many ways to sum a column in Excel ... how to flip the order of data in an Excel table ... get Word to print single-character...
Technology Q&A: nudge a graphic in word ... create an electronic dictionary ... make Excel stop talking ... create a shortcut to recently opened...
Technology Q&A.
Technology Q&A.

Terms of use | Copyright © 2009 Farlex, Inc. | Feedback | For webmasters | Submit articles