ms excel home tab

Complete information about MS EXCEL HOME Tab – FinestStudy

MS EXCEL HOME Tab – Whether it is a small company or a big company or any business, there is always a need for one thing in them that is to organize data, organizing data is very important for every business and we have a spreadsheet program to organize data. 

And whenever it comes to spreadsheet programs, there is definitely the name of MS Excel in it, MS Excel is used in almost every company, so we should know how to use it, so we are starting a series of blog to teach MS Excel. 

In which we will share its options well and this is the first blog of this series, in this we will give you information about the first MS excel home tab,

From the Home tab of MS Excel, we can do the formatting of the data we have entered in Excel, such as we can change the font of the text, or change its color, etc. By the way, we are able to access the Home tab as soon as we create a new document in MS Excel, otherwise you can do the same by using Alt + H shortcut.

What is MS EXCEL HOME TAB?

Home tab is the first tab of MS Excel, in this tab we get to see many options to format our text or data, like with the help of this tab we can copy, cut, paste our text. Well, we can also do this with the help of shortcuts,

Apart from this, we can change the font of our text, change its color and so on, we get to see many options related to text formatting in it.

Uses Of EXCEL HOME TAB

As we mentioned above, with the help of MS Excel, we can do formatting of our text or data, such as enlarging the size of the text or changing the font and or aligning our content,

With the help of this, we can make our entered data attractive and with this we can design our data in such a way that the reader can understand it well, this is its main job.

MS EXCEL HOME TAB SECTIONS

We get to see 7 sections in the Home Tab Sections of MS Excel –:

  • Clipboard
  • Font
  • Alignment
  • Number
  • Styles
  • Cells
  • Editing

So let us now know the options of these sections in detail, the options of the initial sections in MS Excel Home tab are also seen in MS Word Home Tab, so if you know MS Word then you have to understand them. It will be easy

Clipboard

The first section we get to see in MS Excel Home Tab is clipboard, in this we get to see 4 options, with the help of these options we can work with basic like cut, copy, paste,

Apart from this, we get the option of a format painter, with the help of which we can copy the formatting done on any text and apply it elsewhere.

Copy

To understand these options, you must first understand clipboard, clipboard is a kind of temporary memory, in which you keep data, like if you copy any text, then a copy of that text is stored in your clipboard. 

Cut

In Copy, the copy of text or any other type of data comes to the clipboard, but in this option, that text or data goes directly to the clipboard, that means from where you have cut the data, that data will not be there and only clipboard, But it will come.

Paste

With the help of this option, you can paste the data of the clipboard where you need it, that is, along with the clipboard, the data will also come where you have pasted.

Format Painter

If you have done formatting on any text, that is, you have applied any affects in it, such as changed its font, changed the size, etc., then you can copy that formatting and paste it on any other text.

Font

Beyond this, we get to see the Font section, in this we get to see 10 options, which are very easy to use, with the help of which we can change the font of our text, increase or decrease their size.

With this, we can make them bold, italic, we get to see many other options in the same way.

Font

In this you first get to see the fonts, this option does not have any name like that, it is just a little long bar, in which the name of the font of your document is written which is usually Calibri, as soon as you click on that By clicking on the bar, you will get to see many fonts, which you can choose according to your own.

Font Size

There is a small bar just next to the font, in which a number is written, by clicking on this option you can change the size of the font.

Increase Font Size

Next to the font size, we get to see an “A”, which is accompanied by a mark which is on the top side, with the help of this option you can increase the size of the font.

Decrease Font Size

Along with Increase Font Size, we get to see this option, with the help of which we can reduce the font size.

Bold

With the help of this option, your selected text becomes slightly thick and black, as we have written this (Finest Study).

Italic

With the help of this option, your selected text becomes slightly crooked, as we have written this (Finest Study).

Underline

With the help of this option, your selected text gets underline, as we have written this (Finest Study).

Bottom Border

With the help of this option, which are cells in MS Excel, that is, you can create a border in the boxes that we get, although its name is bottom border but you can also make border left, right, up.

Fill Color

With the help of this option, whatever cell you have selected, you can fill color in that cell.

Font Color

With the help of this option, you can change the color of the font in your document.

Alignment

After Font, we get to see the Alignment section, in this we get to see 11 options, with the help of these options we can align the data entered in any cell, that is, the text in that cell will be in the right, left. will be in or will be in between

Or somewhere else, we can do all this with the help of this option, apart from this we also get to see more options in it.

Top Align

With the help of this option, the text you have written in the cell, you can move that text upwards in the cell.

Middle Align

With the help of this option, you can center the text in the cell, that is, neither more up nor down.

Bottom Align

With the help of this option, you can place the text at the bottom of the cell.

Align Text Left

With the help of this option, you can move the text to the left side of the cell, initially you only get this option on.

Center

With the help of this option, you can middle the text in the cell, that is, neither more left nor more right.

Align Text Right

With the help of this option, you can move the text to the right side of the cell.

Orientation

With the help of this option, you can rotate the text in the cell, as you rotate your images, along with this you can also make it vertical.

Decrease Indent

With the help of this option, you can reduce the margin of the cell’s boarder and the text written in the cell, if we tell you directly, then by using this option, the text in the cell will start coming towards the left. Will go

Increase Indent

With the help of this option, you can increase the margin of the cell’s boarder and the text written in the cell, if we tell you directly, then by using this option, the text in the cell will start going to the right. .

Wrap Text

If you have written a long text in a cell and now you want this text to be visible to you and it does not hide any other cell, then you can use this option, this option increases the height of the cell. .

Number

Beyond this we get to see the Number section, in this we get to see 6 options, as it is named, you must have understood that it would provide options related to numbers,

In this we get options to write numbers like number, currency, percentage etc. ,

Number Font

This option is like a bar, in which General is usually written, with this you can decide that if you have written a value in the cell, then how will it look, currency, percentage or date or even other Options are available in it.

Accounting Number Font

The sign of this option is like dollar, from the above option we can decide whether the number we have written is currency or something else, but with this option you can decide what will be the currency, it will be dollar or Then euro or it will be any other currency.

Percent Style

With the help of this option, you can write the number in percentage.

Comma Style

With the help of this option, decimal comes in the value as if you wrote 50 and used this option on it, then the value will be 50.00, when we have to do this in many values, then this option comes in handy.

Increase Decimal

With the help of this option, you can increase the number after the decimal of the number, so that you can see a number more accurately.

Decrease Decimal

With the help of this option, you can subtract the number after decimal, if you use these options, then you will understand this very well.

Styles

Next to this we get to see the styles section, in this we get to see 3 options, with the help of these options we can do the formatting of our cells, in this we get to see different options for formatting.

Conditional Formatting

With the help of this option, you can highlight cells, in this you get to see many options, such as you can decide a number that if the number in a cell is greater than that number, then what about the cell? color will be

And if that number is small then what will be the color, similarly you get to see more conditions, which you can use.

Format as Table

With the help of this option, you can select many cells and apply any table style on them, so that you can bring those cells in the form of a table.

Cell Styles

In this option, you get some pre-made styles for cells, which you can use on your cell to make it look attractive.

Cells

Beyond this we get to see the cells section, in this we get to see 3 options, with the help of these options you can add or delete cells, columns, rows in your document, apart from this you can You can format them too.

Insert

With the help of this option, you can insert a new cell, column, row or a new sheet in your excel sheet.

Delete

With the help of this option, you can delete any cell, row, column or sheet.

Format

With the help of this option, you can change the height of a row or the width of a column and you can organize your sheet and with this you can protect or hide cells.

Editing

Beyond this, we get to see the Editing section, in which we get to see 5 options, in which we get to see many different types of features, in this we also get to see some basic formulas, you can use it. You can read about all the options below.

AutoSum

In this option, you get to see basic formulas like sum, average, which you can select and use on the cells and it gives you the results automatically.

Clear

With the help of this option, you can clear the formatting of a cell, or you can clear the data inside it, or you can clear both of them together.

Sort & Filter

With the help of this option, you can organize the data that the data will be in descending order or in increasing order and with this you can also organize text data like first text starting from A and then further to Z. Or you can do the opposite.

Conclusion (MS EXCEL HOME Tab) 

So in today’s blog, we gave you information about the MS excel Home tab, we tried our best to make you understand about each of its options in the simplest language possible,

If you liked this effort of MS EXCEL HOME Tab, then you must share this blog, if you have found any deficiency in the blog and or you want to give any suggestion to us, then you must tell us by writing in the comments, we will definitely reply to it. .

FAQ (MS EXCEL HOME Tab)

How many tabs are there in MS Excel?

In MS Excel we get to see 7 tabs -: Home, Insert, Page Layout, References, Mailings, Review and View.

How many sections do we see in MS Excel Home Tab?

In MS Excel Home Tab, we get to see 7 sections -: Clipboard, Font, Alignment, Number, Styles, Cells and Editing.

Leave a Comment

Your email address will not be published.