Excel Instruction - Text Entry in Excel 1 Rev1-1

Excel Instruction - Text Entry in Excel 1 Rev1-1 - Excel...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Excel Instruction Text Entry in Excel 1 Topics covered This instruction explains how to use Sub/Super script and special characters needed for constructing a Chemistry Lab Report. Special Note Techniques explained here are applicable to other MS Office program, such as Word® and PowerPoint®. Subscript and Superscript Entering a chemical formula/equation requires more than just typing directly on a cell, but some treatment after all in order to show chemical formulas/equations in an accurate format and a professional manner on your report. For instance, instead of HCO3-, your report should indicate bicarbonate ion as HCO3-. 1. Click the cell where you want your chemical formula to be shown, and enter a “raw” chemical formula on the cell. 2. In the “Formula Bar”, highlight a part you need to apply a change using your mouse (You can also highlight/edit directly on the cell, but we recommend editing in a formula bar, because of known bugs in early version of Excel). 3. Right click the highlighted area. Make sure the area is still highlighted after the right-click (You could be right clicking outside of the highlighted area ⇒ No change will apply!). Select “Format Cell” option from the list. Copyright © 2003 Tatsuya Maehigashi Text Entry in Excel 1 Excel Instruction 4. “Format Cells window” appears. Under “Effect”, check “Subscript” (or “Superscript” for the +/- charge). Click “OK” 5. Hit Enter-key on your keyboard after all changes are applied Copyright © 2003 Tatsuya Maehigashi Text Entry in Excel 1 Excel Instruction Special Characters and Symbols (Windows) Special characters and Symbols are needed in order to indicate chemical equations, units, and math formulas correctly. Examples are →, Δ, °C …etc. Special Characters can be inserted in various ways depending on the version of MS Office on your Windows® computer. *If you are using Mac, skip this section and go to next section* Office Version Instruction Remark Office XP or later From Insert at the top of your spreadsheet, choose Symbol. Then, you can select from a list of special characters / symbols. Try using Keystroke, also. See Examples below. All Office products You can bring up "Character Map" from Start on your Windows ⇒ Accessories ⇒ System Tool ⇒ Character Map. Change the "Font" to "Symbol" to bring up the list of special characters. If you don’t see character map, you may need your Windows CD to install the program. Some may find the use of “Keystroke” for special characters very useful and convenient (I certainly do!). See the following example for the use of “Keystroke”. This feature can be used on all versions. *Note: Keystroke for special characters most likely won’t work if you use a laptop computer (without 10-key pad) if it requires numerical input. Example: “Temp. Reading (°C)” 1. Click the cell you wish your object to be shown. Start typing your object Copyright © 2003 Tatsuya Maehigashi Text Entry in Excel 1 Excel Instruction 2. To insert “degree (°)”, type 0176 while you press and hold “Alt” key on your keyboard. The special character “degree (°)” appears once you release "Alt” key. ← Alt + 0176 Example: “ΔH” 1. Click the cell you wish your object to be shown. Type DH. 2. Highlight “D” only using your mouse in the “Formula Bar” 3. From the “Font” in the toolbox, select “Symbol”. Copyright © 2003 Tatsuya Maehigashi Text Entry in Excel 1 Excel Instruction 4. Hit “Enter Key” on your keyboard. “D” is converted to “Δ” You can find “Keystroke” from “Character Map” (“Start” ⇒ “Accessories” ⇒ “System Tools” ⇒ “Character Map”. As you can see from both examples above, your special character may need “Alt + ****” or just a change in font type. For your convenience, here is the list of keystrokes for most common special characters / symbols needed for this course. Special Character Keystroke Degree (°) Right Arrow (→) Left Arrow (←) Double arrow (↔) Lambda (λ) Delta (Δ) Alt + 0176 Alt + 0174 Alt + 0172 Alt + 0171 l (small L) D (Capital D) Remark Font needs to be changed to "Symbol" Font needs to be changed to "Symbol" Font needs to be changed to "Symbol" Font needs to be changed to "Symbol" Font needs to be changed to "Symbol" Special Characters and Symbols (for Macintosh Users) Various ways to call special characters and symbols in Macintosh® are summarized below. Please be advised that calling such feature on Mac also Copyright © 2003 Tatsuya Maehigashi Text Entry in Excel 1 Excel Instruction depends on which Operation System (eg. OS 9 or OS X… etc) you have on your machine, as well as possibly depending on how your OS/Office® is setup. Method Instruction Remark From Excel/Word From Insert at the top of your spreadsheet, choose Symbol. You can choose from a list of special characters / symbols. This feature may not be available on your Excel. Character Palette can be called from Input Menu (See Remark) -orChoose Edit → Special Characters Input Menu is a flag-icon located in the top-right corner of your screen. If you don't see one, open System Preferences (from Apple menu) → International. Click Input menu, then check next to Character Palette and Show input menu in menu Bar. Keyboard Viewer (Mac OS X) Keyboard Viewer can be called from Input Menu (See Remark) → Show Keyboard Viewer. Input Menu is a flag-icon located in the top-right corner of your screen. If you don't see one, open System Preferences (from Apple menu) → International (from View menu). Click Input Menu, then check next to Keyboard Viewer and Show input menu in menu bar. Key Caps (Mac OS 9) Key Caps is located in Apple Menu. Character Palette (Mac OS X10.4) Copyright © 2003 Tatsuya Maehigashi ...
View Full Document

This note was uploaded on 06/19/2009 for the course CHEM 1312 taught by Professor Bottomley during the Spring '07 term at Georgia Institute of Technology.

Ask a homework question - tutors are online