Home > In Excel > Excel Subscripts?

Excel Subscripts?


So please, please, please--review the ideas on Excel UserVoice, vote up the ones you like, and consider posting your own suggestions.36.6k Views · View UpvotesRelated QuestionsMore Answers BelowIs there a keyboard Mostrar más Cargando... More or fewer cells than the active selection Hold down SHIFT while you click the last cell that you want to include in the new selection. Finder The Doctors Live Healthy Health Videos Better Sleep Style Luxury Auto Beauty Dining Fashion Home & Design Home Elegance Lust List Travel Window Shopping Food & Cooking Alison Cook Restaurant

There is no subscript button for you to quickly format text as subscript in Excel 2007/2010 as you can easily format a letter as subscript in Word with the subscript button. If you need to apply subscript or superscript formatting, you won't find these options on the ribbon. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the Excel really isn’t designed to be a word processor.

Excel Subscript Shortcut

When the Format Cells window appears, select the Font tab. George Doyle/Stockbyte/Getty Images Related Articles [Excel Graphs] | How to Get Subscript in Excel Graphs [Sub Letter] | How Do You Type a Sub Letter in Excel? [Exponents] | How to You can also select the first cell or range of cells, and then press SHIFT+F8 to add another nonadjacent cell or range to the selection. Click the box next to "Subscript" under the Font tab, and then click "OK." The selected cells or text displays as subscript characters.

If you'd like to apply strikethrough to just part of a cell. asked 3 years ago viewed 3862 times active 3 years ago Blog What Programming Languages Are Used Most on Weekends? Then, select the text you'd like to format, and access the format cells dialog box. Superscript In Excel Formula Macros don't work so well if you are trying to only turn certain characters in a text string inside a cell into super or subscript.

Cells to the last used cell on the worksheet (lower-right corner) Select the first cell, and then press CTRL+SHIFT+END to extend the selection of cells to the last used cell on Subscript In Excel Mac With it, you can also apply some command formatting styles to the superscript or subscript characters, such as the Bold, Italic, Upper/Lower Case, Font size, and Color. Related 0Complex excel formula help needed?2Excel array formulas to find smallest date with multiple criteria1MS Excel 2007 If Then Formula Troubles1Excel formula/VBA to detect a property of a group of rows3Flatten As before, carefully select the text you'd like to format.

You can work around this limitation by converting your data to text before adding the subscripts. 1. Superscript In Excel Mac Idioma: Español Ubicación del contenido: España Modo restringido: No Historial Ayuda Cargando... Cargando... They really are paying attention to the ideas being voted up, and you can count on many of them making it into Excel 2016 or future versions.

Subscript In Excel Mac

Under Effects, select the Superscript or Subscript check box. All rights reserved. Excel Subscript Shortcut Bonus! Subscript In Excel Graph Right-click the selection and choose "Format Cells" to open the Cell Formatting dialog box. 5.

Cola de reproducción Cola __count__/__total__ Using Superscript and Subscript in Excel pigpenhub SuscribirseSuscritoCancelar1111 Cargando... Instead they're located on the font tab of the Format Cells dialog box, in the Effects group. If a feature request gets 20 votes, it will be looked at. Why aren't electric forms of heating used in internal combustion engines What is this pattern for (self = this) Can I make a card that places a +1/+1 counter on an Excel Subscript Shortcut Mac

Click the box next to "Subscript" under the Font tab, and then click "OK." The selected cells or text displays as subscript characters. Adding subscripts to Excel is usually a simple matter of a font setting, but you may run into limitations when adding subscripts to cells containing numbers or formulas. Reproducción automática Si la reproducción automática está habilitada, se reproducirá automáticamente un vídeo a continuación. Box 4260 Houston, Texas 77210–4260 © Copyright 2017 Hearst Newspapers, LLC Try Microsoft Edge, a fast and secure browser that's designed for Windows 10 Get started Sign in Search Microsoft Search

Add comment Name (required) E-mail (required, but will not display) Notify me of follow-up comments Refresh Send Cancel ExtendOffice Follow Us: Hot Products Office Tab Kutools for Excel Kutools for Word Superscript In Excel 2013 The first or last cell in a row or column Select a cell in the row or column, and then press CTRL+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP All cells on a worksheet Click the Select All button.

Combine and Consolidate Multiple Sheets and Workbooks.

The first option is to double click a cell, or select the cell and press F2 to enter edit mode. Create a Checkbox Only one major and minor Can a reproductive system that allows interspecies breeding be made believable? Finder The Doctors Live Healthy Health Videos Better Sleep Style Luxury Auto Beauty Dining Fashion Home & Design Home Elegance Lust List Travel Window Shopping Food & Cooking Alison Cook Restaurant Superscript In Excel 2010 Note: If the worksheet contains data, CTRL+A selects the current region.

It may vary slightly or significantly with other versions or products. share|improve this answer answered Oct 9 '13 at 12:02 benshepherd 1,120516 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign What is the keyboard shortcut?Excel gives the delete option for any CTRL+XY shortcut. Ted Pettit, The World's Laziest Excel Power UserWritten 78w agoThere isn't a single hot key combo, you have to do multiple hot keys to get what you want:Superscript: Ctrl+Shift+F, Alt+e Subscript:

References (2) Free Training Tutorial: Using Superscript and Subscript in Excel - A Tutorial VideoExtendOffice: How to Format Text as Subscript in Excel 2007/2010? Tip: To cancel a selection of cells, click any cell on the worksheet. Switch to another language: Catalan | Basque | Galician | View all Cerrar Sí, quiero conservarla. Learn pavithra's Excel 1.373 visualizaciones 1:28 How to Do a VLOOKUP in Excel - Video Tutorial - Duración: 6:16.

pomfretvids 2.327 visualizaciones 2:37 Excel Magic Trick 391: Custom Number Format to Insert Symbol Automatically - Duración: 1:55.