Excel Text Tips - Tech Learning

Excel Text Tips

Tip: I love word wrapping, but a fine way to format your text in Excel is to: Choose alignment Orientation And vertically change the direction of text. This is useful in a document where you are trying to have several headings across the page, as in a grade book, attendance sheet, etc. but using standard
Author:
Publish date:

Tip:
I love word wrapping, but a fine way to format your text in Excel is to:

Choose alignment
Orientation
And vertically change the direction of text.

This is useful in a document where you are trying to have several headings across the page, as in a grade book, attendance sheet, etc. but using standard horizontal text makes the columns too wide and/or takes up too much room on the page.

Another "gem" in Excel...

If, when you try to enter something into a cell and Excel insists on turning that into a formula, try this. First type an ' (apostrophe) and then what you’ve been trying to enter. What appears in the cell is what you wanted, not the formula.

Submitted by: Patricia Bailey
Lavizzo School in Chicago
pawtricia@yahoo.com
pabailey@cps.k12.il.us

Featured

Related

Excel Shortcuts

Tip: Inserting Time and Date Setting up worksheets to use with your teachers? There are shortcuts in Excel or Access that can have the time or dates automatically show up. To show the current date, click Control (CTRL) and ;(semicolon) To show the current time, click CTRL and Shift and ; To have both

Image placeholder title

The Pros and Cons of Texting and IM by Kelley Loftis

Text messaging and instant messaging have become so widely used by teens that teachers have noticed a drastic change in students’ writing habits. Students are integrating the abbreviations that are used in texting or instant messaging into their school work.

Useful Excel Tips

Tip: Freeze Panes When you scroll far enough down in a spreadsheet you will eventually lose sight of the header row(s). To show your header row (column titles) or any number of other rows at the top of the screen regardless of how far you scroll down: Highlight the row UNDER the last row you want showing by

Writing Hyperlinked Online Text

Tip: Hyperlinked Online Text is what you see on a site like Wikipedia, as below. Writing such text is a skill, but not widely discussed. Here are a few thoughts. The best blogs lead the reader to rich information by using hyperlinks to strengthen what is written in the article. Hyperlinks lead to more

Images in Text Box

Tip: When you add images to Word, they are inputted as in line with text. You can always change the way text wraps around the images with the image formatting tools, but there is another way to add an image that is easier to manipulate. Around the world Go to View to Toolbars to Drawing. Click on the

Wrapping Text Around Images

Tip: By default, the picture will be in line with the text at the point at which your cursor was positioned when you inserted the picture. You can wrap the picture, then click and drag to move it anyplace in the document. Click at the end of the last line of text. Go to Insert menu to Picture to Clip Art. Type

Text Readers

Tip: Here are four “talking machines” that will read selected text aloud – a boon when working with many different types of students. The first three are Windows-based and the fourth is for Mac. Windows: 1) ReadPlease The download is a little confusing because the Free and Pro versions

New Views for Excel

Tip:When you are showing how to use Excel, you can change the views so your teachers can see just what you want to show them. Changing page breaks in a worksheet: Go to the View menu to Page Break Preview. Drag the page breaks to where you want them. Click OK and go to View to Normal view. Viewing Formulas Press