Home > Microsoft Excel > Subscript excel mac - how do you decide

Subscript excel mac - how do you decide

How do you type a subscript on a Mac?

You can also use keyboard shortcuts to quickly apply superscript or subscript to selected text. For superscript, press Control-Shift-Command-Plus Sign (+). For subscript, press Control-Command-Minus Sign (-).

So let's look at different ways you can make text superscript or subscript. Whats that? Well, if you didn't know it's superscript when text is above the baseline. You usually use it in math seven squares you would have the 2 up there.

Is subscript when it's down. This is sometimes used in math as well. It is often used for equations and for other reasons.

So this is superscript and this is subscript you enter this on a Mac. There are different possibilities. Here I'm at TextEdit and I'm going to show you one of the easiest ways to do it, but it also takes a lot of steps and can be a little frustrating.I want to say something like seven squared.

I would enter 7 and then 2. The two should be superscript. The square part.

Now I'm using rich text formatting here in TextEdit. So it is not a pure text document. This is Rich Text.

So I can stylize the text. When I go to Format, Font, I can go to Baseline and there is a choice for Superscript and Subscript. So I can choose Superscript.

But I'm not done yet because it's just raises the 2 above the baseline. But it doesn't really look good because the two are still the same size as the seven. Usually superscript and subscript are smaller.

So I'm going to select this and resize it. If I change it too much from what you think it might be halfway through, then it doesn't look good. So maybe something about 75% looks pretty good there.

The same for subscript. If I wanted to do this subscript instead, instead of going to Font, Baseline, and Superscript, I would do subscript and put it at the bottom, set things superscript or subscript that way, it's bold too. So whether it's subscript or superscript or not, it looks a little better.

Then you might want to adjust the font size and play with the font size a little. Sometimes you just want to get it so that the number is up there. So you h There are many different options, many different steps.

There are other ways of doing this as well. One way to do this is to use special characters. There are special characters for numbers that are superscript and subscript.

So I enter 7 but I will get a special character the same way I would get any special character or emoji. I'm going to run Ctrl, Command, and Spacebar to bring up the character picker. I'll use the search box to search for superscript.

You can see there are a number of numbers here and a couple of other things. A little tick and n. Something like that.

So let's use the 2 here and you can see that there is a 2 there. This is special character. This is not the normal 2 you type on the keyboard.

It is perfectly aligned with the top, so this is a really great option, but you will see that you have a limited number of characters. If you can so if you create a formula and you have to spell a word or something or put likeC or W or some other variable as a superscript then it won't work, but you can use this to e.g. square a number, note that i Of course once I use this, find them there in my list of commonly used ones above above so it's a bit easier to type in.

There's also a subscript so I can use the subscript 2 and you can see the 2 appear below becomes. This is also a separate sign. These are two different characters and they are different from the number 2 you would normally enter another way to do it with the caret symbol.

The caret looks like this ^. On an American keyboard, it's Shift 6. The caret doesn't look good.

library url onedrive

This is what seven looks like 7 ^ 2. It doesn't look like it, but it's a lot more functional. It's more functional because it's used in programs that do math.

That could be something as simple as Spotlight. So I'm going to run Command Space to bring up Spotlight. If I do 7 ^ 2 it assumes I mean to the power of two and get the correct answer.

You enter something into a program that expects a math formula, it could be the graphics app or some other math app. Using the caret symbol will give you this superscript when trying to do math. This is used so often that it is seen in documents everywhere online.

This may not look so pretty, but you will see it a lot. Just search for math formulas online and you will find tons of websites that actually only list seven squared. So when you see it all the time, of course, it doesn't look that bad.

It's also great because if you're working in a text-only environment, say you're entering a simple text document, or some sort of system where you don't have all of those special characters, then it's always going to work that way. You will always be able to get it and most of the people who are into math will understand that the 2 is now superscript. It's now high 2.

But I also wanted to show you that you can get superscripts. Moving on to a full-fledged word processor, Pages, you can now do the same things in Pages. You can choose 2.

You can choose the format, font, baseline and superscript. You can also use these special characters. But you also have the option to insert an equation.

This brings up a small equation editor that uses two of the standard formats for entering equations. So you're entering a special type of code here to actually get a result. So when I put in a number like 7, you can see it here, and in the preview below, it shows the number 7.

If I want o, type to the power of 2 I can put the caret in there and 2 and it understands and translates that to 7 and then to the superscript 2. In fact, you can actually do more characters with it. Because what if I wanted to do 7? the power of 23.

Well, at first it looks like it's not working. I type in a three and the three is down. But when you put curly braces around something, it groups them together.

Then you can see I get 7 to the 23rd power. So I can put characters here too, letters. So I can put 7 abc up there and then I get these characters together that I couldn't do that easily with special characters If you wanted to be subscript you can use the underscore instead of the caret and a subscript will be inserted.

So you can do something more complex, paste and paste it. This is not a text. This is a special little item here I can see I select it and it engages.

It's almost like a little picture. The great thing is that I can copy and paste the t into apps that don't have the InsertEquation feature. So I can go back to TextEdit here and paste that in.

It is not a text. I cannot select individual characters. It's like a picture, but it works.

unhide personal workbook

I can go, shall we say, in Mail, where there is no inserting an equation there either. But I can put that in a mail message and it puts a little picture in there. So you can create complex math formulas with superscripts and subscripts in other apps, as long as you start with a place like Pages where you can type in those special equations.

How do you do subscript in Excel on Mac?

While your mouse is over the selected text, right-click and then select 'Format Cells' from the popup menu. When the Format Cells window appears, select the Font tab. Check the Subscript checkbox. Now when you return to the spreadsheet, you should see the subscript value.

How do you do subscript in Excel?

Select characters in a cell or cell range that you'd like to format. On the Home tab, in the Font group, click the Font Settings dialog box launcher. Press CTRL+1. Under Effects, check the Superscript or Subscript box, and click OK.

This is the data set we used to create the following chart. The first column is the property ID, the second is a state, the third is the current location, and the fourth column is the area of ​​the property and this is the average summer temperature. So suppose these are all of the places I have real estate ... or 'they' have real estate in ...

What I did here is I made a chart that compares the area to the city where I have the plot in ... and the second is the average temperature of all these cities.

So let's try adding a chart title first and see how we can add subscript or superscript there. First, let's click on this option for chart elements ... you are going to add a new chart element which is the chart title.

You can see that a chart title has appeared here ... so let's ... edit the title.

Let's see how we can implement superscript and subscript. In this case ... where in a normal cell in Excel there was an m2 when you right click ... you have the option to select 'Format Cells' and then there was no easy access to superscript or subscript.

However, if it's a graph, you don't have such an option. If you right click you won't get this option to format cells here. The only way to implement superscripts or subscripts is to either use shortcuts or just copy the values.

Let's look at all three options. The first option we'll go through is to use a quick shortcut, but it only works for superscript 1 2 3 and degree. So let's look at doing this superscript.

Select the 2 or you can just delete it ... then hit the alt key and type 0 1 7 8 then release the alt key.

If you see, m² has now arrived in the diagram title. So this was a possibility. Let's look at the second way ... you can delete that superscript ... let's choose superscript².

Run Ctrl C to copy this value ...

Come back to the chart title; Choose where you want to paste it ... and then run aCTRL V.

See ... here you could also copy and paste the values ​​directly.

I've put all the possible values ​​here on this Excel sheet so you can copy and paste them straight from here into your chart ... and you get access to all of those values ​​Now it's back to the actual source I copied these values ​​from . .

So let's look at this ... this is the actual source I copied it from ... so what you can do is ... let's say for example ... you want the superscript '4' copy ... just select that, hit ctrl c, go back to your diagram and run ctrl v.

See, you can put in the superscript. You can bookmark this link and use it whenever you want. So we looked at option 1, option 2 and the third option is ... using the keyboard shortcuts.

In case of abbreviations you have to enter 2 ... if you want to make it one square meter and then what you do is ALT + HFNP for superscript and if you see here ... this has become one square meter would like this to be do a subscript ... the same thing ...

Alt + HFNB to make it an index. Another possibility ... is CTRL + 1 & ALT + P and it will be a meter square.

Next, let's look at how to implement superscript or subscript in the axis title. You go to 'Chart Items' & 'Plus' and then select 'Axis Title' so you can see a vertical and a horizontal axis label ... so for horizontal ... we'll just go ahead and enter as the location and the vertical as the range as and In-bracket, square meters.

It's exactly like we did for the chart title. In this case, I'm only going through one join method ... but you can use all three methods.

Select the '2' and press the Alt H F N Pfür superscript key. OK? and it is superscripted. The third and final place where you may need to add a superscript or subscript is in the chart legend.

The legend is not editable directly, so you could edit the values ​​in the 'Axis Title', you could edit the values ​​in the 'Chart Title', but you cannot edit them directly in the legend ...

The legend is the same as the column heading. The column heading should contain the exact value that you want to appear in the legend. Well ... you changed this to meters squared ... well if you see it got in here as we put it in the column header.

That is ... if you need to make that '2' a subscript, you have to do it in the column header itself.

Let's look at two ways it wouldn't work ... right ... so if you select 2 and right click, format cells and make it superscript ... okay ... it looks good here, but actually when you get to the chart ... it hasn't changed.

So that didn't work and the reason it didn't work is ... when you see the actual value in the cell ... you see here ... the actual value ... it is still shown as' 2 'displayed ... right? The diagram label assumes the * value * in the cell, so ... even though it looks superscript here ... in the label ... it still comes as m2.

Also, if you had seen the shortcuts right before ... it replicates the same steps ... right click and 'Format Cells' and choose 'Superscript' or 'Subscript'.

So that would mean that even the shortcut method wouldn't work here ... let's see if the copy / paste works ... so if you copy the value and paste it here ... yeah ... so that would Copy and paste work here because when you see the value it is actually now showing as superscript.

If you go to the diagram, yes ... the label reflects correctly.

This was an option you have ... where you can just copy these values ​​right into the column heading.

The second option is to use these shortcuts. So again, if you want to square one meter, what you're doing is ... do ALT + 0 1 7 8 and then release the Alt key.

It gets squared and when you see the value contains the actual superscript and the label contains the superscript. Now let's quickly replicate this into a second diagram where you want to see how we can implement Grade. So let's first bring in all the components that we need, i.e. the 'axis title', 'diagram title' and 'legend'.

Let me edit it quickly ...

Ok, 'axis title'. I need to add a degree there ... we'll do that ...

touchpad moving erratically

Ok ... so let's start with that degree.

To enter the degree, there is only one way to do it ... and that is ... click where you want the degree symbol to appear ... press the Alt key and enter 0176 and release the Alt key.

When you see the degree sign has come. Looks good! Next is the average summer temperature ... you want to bring degrees Fahrenheit in this case too.

The same ... you have to click here ... press ALT + 0 1 7 6, release the alt key ... degrees has occurred ... and when you see degrees, it also shows Fahrenheit in the legend .

Okay so great! I think we've covered everything you need to be superscript or subscript anywhere on your chart ...

How to use superscript and subscript in Excel?

Format text or numbers as superscript or subscript 1 Format text values as superscript or subscript. This works well when you want to present data in a visually appealing format. ... 2 Add superscript and subscript to your Quick Access Toolbar. ... 3 Apply superscript or subscript to a numeric value. ...

Is there a way to use subscript on Mac?

There is a quicker way of implementing the subscript or superscript format on Mac OS and that is to use keyboard shortcuts or keystrokes. The only downside is that it is only present in the Pages app; this feature is not available in TextEdit.

Is there a shortcut to go into subscript mode?

The shortcut for going into the Subscript mode is the combination of the Command, Control and – key. Given as Command+Control+- Once you press these keys at the same time you will be shifted to either a superscript or subscript mode and any text you type will be above or below the baseline.

When to use a subscript in a text?

A Subscript is a text that you have formatted to be below the baseline. It could be either a small letter or number and is written after a particular letter or word denoting a formula or it could be a number. It “hangs” below the letter or number which is known as its base.

Other Questions In This Category

Skype picture folder - action-oriented solutions

Why does my Skype say Cannot connect? If you see a 'Sorry we couldn't connect to Skype', 'Skype can't connect' or 'Unable to receive notifications' message when you try to use Skype, the most likely cause is a poor internet connection, or no internet connection. To fix this issue, try the following: Make sure your mobile device is not offline.

Skype is laggy - how to achieve

Why is Skype not downloading files? And since it's caused by issues like your software being out of date, a conversation being too old, or your partner's Skype account being inactive, users are advised to take the mentioned steps. In summary, download, and backup, your Skype files regularly.

Skype activity log - simple answers to questions

What does the arrow in Skype mean? Out Of Office