MS Excel - Home Tab

-

 Home Tab -

Home Tab is used for text formatting in Microsoft Excel. Through Home Tab, we can represent the text in a better way by Bold, Italic, Underline, Copy, Paste and Edit. We can access Home Tab with the help of Shortcut key (Alt + H). Through Home Tab, we can do Filter, Sorting, Format, Delete and Conditional Formatting data.

Home Tab is mainly divided into 7 parts. With its help, we can do the work of text formatting.
  1. Clipboard Group
  2. Font Group
  3. Alignment Group
  4. Number Group
  5. Style Group
  6. Cell Group
  7. Editing Group

1. Clipboard Group

Copy (Ctrl+C)

This option is used to make more than one copy of the data in Microsoft Excel. To copy, first we have to select that text picture or object, after selecting it, go to the Clipboard group of the Home tab and select the copy option. Do it. In this way, you can create more than one copy of your data, its short cut key is Ctrl+C.

Paste (Ctrl+V)

The best option is used to bring the copied data, after copying, going to the place where we need another copy, we will click on the paste option by going to the Clipboard group of Home Tab. Its short cut key is Ctrl+V.

Cut (Ctrl+X)

This option is used to move the selected text picture or object from one place to another in Microsoft Excel. To cut the data, first of all we have to select that text, picture or object. After selecting, go to the Clipboard group of the Home tab and click on the cut option. Its shortcut key is Ctrl+X.

Paste Special

This option is used to paste the copied data in other formats in Microsoft Excel. Paste special option is used, through this we can paste the copied data as an image as well.

Formate Painter

It is used to copy the format done in another text in Microsoft Excel, first select the text whose format is to be copied, after selecting it, select the Format Painter option, after that it will copy the format of the text. Select what you want to copy above. This is how our Format Painter option can be used.

2. Font Group

Bold (Ctrl+B)

This option is used to make the selected text bold in Microsoft Excel. Its shortcut key is Control Plus B. To make any text bold, first select it, then go to the Home tab and select B in the Phone group. Its shortcut key is Ctrl+B.

Italic (I)

This option is used to italicize the selected letter. To italicize any text letter, first select that text letter. Its shortcut key is Ctrl+I.

Underline (U)

This feature is used to underline the selected characters. Its shortcut key is Ctrl+U.

Font Type

This option is used to change the font type in Microsoft Excel like Times New Roman, Kriti Dev 010 etc.

Font Size

This option is used to increase the phone size in Microsoft Excel, through this we can increase the phone size up to a maximum of 72 digits.

Font Size Increment

Using this option, we can increase the phone size as per our wish, in this we can increase the concise more than 72.

Font Size Decrement

Through this option we can reduce the size of the letters.

Font Color

Through the option, we can change the color of the phone, such as the already black letter is black, we can make it red, green, blue, yellow, etc. as per our wish.

Fill Color

Through this option, we are used to color fill the background of the selected text in Microsoft Excel.

Border

Through this option, we can give border to any cell or group of cells (Cell range). Can color the backgroud of the selected text.

3. Alignment

Left Alignment

This option is used in Microsoft Excel to align the text typed in the cell to the left. Its shortcut key is Ctrl+L.

Center Alignment

This option is used to center the text alignment typed in a cell in Microsoft Excel. Its shortcut key is Ctrl+E.

Right Alignment

This option is used to align the text typed in the cell to the right side in Microsoft Excel. Its shortcut key is Ctrl+R.

Top Alignment

This option is used to set the characters typed in the cell to the top position of the cell.

Middle Alignment

This option is used to set the characters typed in the cell to the middle position of the cell.

Bottom Alignment

This option is used to set the characters typed in the cell to the bottom position of the cell.

Wrap Text

Through this option, we can display the text typed in the cell in more than one line if the length is more. For this we will use this option by selecting that cell.

Merge Cells

This option is used to merge one or more people, which we call merge, for this we first select all those people who have to be merged, after selecting all together, this option Clicking on it will merge all the cells.

Text Direction

Through this option, we can change the direction of the text inside the cell which is typed in excel. We can change the direction of our test according to our need, 90 degree, 160 degree, any degree.

Increase Indent (Ctrl+Alt+Tab)

The range of indent can be increased using this option.

Decrease Indent (Ctrl+Alt+Tab)

The range of indent can be reduced by using this option

4. Number Group

Number Format

With the help of this option, we can change the Number Format. First of all, select the Cell, after that in the Number group, according to your wish, you will select any one option from the given format. Like - Date, Time, Number, Accounting Number, Text etc.

Decrease Decimal

With the help of this option, we are done to reduce the Decimal Number.

Increase Decimal

With the help of this option, we are done to reduce the Decimal Number. 

5. Styles

Conditional Formatting

With the help of this option, we can format the data given in the cell or cell range on the basis of condition.

Seclect Data

↓

Conditional Formatting

↓

Highlight Cells Rules

↓

Greater Than

Format as Table

This option is used to give table format to the cell range. To apply it, first of all select the data which is to be given Table format, then click on Format as Table option from Home Tab's style group.

Cell Styles

This option is used to change the style of the cell. To apply this, first select the cell whose cell style is to be changed, then click on the cell style from the style group of Home Tab.

6. Cells

Insert - It is used to insert new Cell, Row, Column or Sheet.

Delete - It is used to delete Cell, Row, Column or Sheet.

Format - It is used to format the cell.

 

7. Editing

Auto Sum

This is an important option by which we can add the given numbers, for this first of all we select the data and click on Auto Sum option, as soon as we click, the result of the data will appear in front of us in the form of Sum.

Fill

This option is used to autofill any pattern in Microsoft Excel like select both by writing 2, 4 and track down after selecting, this automatically prints your serial as far as you track. Will be done.

Clear All

This option is used in Microsoft Excel to delete the data of entry under work book. To delete, first select all the data and click on Clear All so that you will get all deleted.

Find & Select

This option is used to search any text or data, its shortcut keys are Ctrl+F.

Location: FF-116, First Floor Gopal Vihar Shopping Complex, P N B Colony, Jabalpur, Madhya Pradesh 482002, India

Comments

Post a Comment

Popular posts from this blog

Courses After 12th Science

-
  Courses After 12th Science List of Best Courses after 12th Science with PCM Did you pursue the subject combination of Physics, Chemistry, and Mathematics in Class 12? If yes, then the following courses are the best options for you. BTech/Bachelor of Engineering Bachelor of Architecture (BArch) Bachelor of Computer Application (BCA) Integrated BE/MBA BSc Aviation Sciences BSc Physics BSc Chemistry BSc Maths BSc Computer Science BSc Information Technology BSc General BSc Electronics BSc Statistics BSc (Hons) Statistics BSc (Hons) Industrial Chemistry BSc Hotel Management BSc Electronics and Communication BSc Nautical Science Diploma in Computer Science Diploma in Nautical Science BSc Multimedia BSc Fire Safety and Hazard Management BSc Photography BSc Airlines and Tourism BSc Applied Chemistry BSc Finance BSc Software Engineering Bachelor of Engineering BSc Avionics BSc Accountancy BSc in Actuarial Science List of ...
Read more

MS Office Versions List

-
 MS Office Versions List Release date Title Components October 1, 1990 The Microsoft Office for Windows Word 1.1, Excel 2.0, PowerPoint 2.0 March 4, 1991 Office 1.5 Word 1.1, Excel 3.0, PowerPoint 2.0 July 8, 1991 Office 1.6 Word 1.1, Excel 3.0, PowerPoint 2.0, Mail 2.1 Early 1992 Office 2.5 Word 2.0a, Excel 4.0, PowerPoint 2.0e, Mail 2.1 August 30, 1992 Office 3.0 Word 2.0c, Excel 4.0, PowerPoint 3.0, Mail 3.0 January 17, 1994 Office 4.0 Word 6.0, Excel 4.0, PowerPoint 3.0, Mail 3.1 June 2, 1994 Office 4.3 Word 6.0, Excel 5.0, PowerPoint 4.0, Mail 3.2, Access 2.0 July 3, 1994 Office for NT 4.2 Word 6.0, Excel 5.0, PowerPoint 4.0, Office Manager August 24, 1995 Office 95 (7.0) ...
Read more

Computer - Network Topologies

-
Image
  Computer Network Topologies A Network Topology is the arrangement with which computer systems or network devices are connected to each other. Topologies may define both physical and logical aspect of the network. Both logical and physical topologies could be same or different in a same network. Point-to-Point Point-to-point networks contains exactly two hosts such as computer, switches or routers, servers connected back to back using a single piece of cable. Often, the receiving end of one host is connected to sending end of the other and vice-versa. If the hosts are connected point-to-point logically, then may have multiple intermediate devices. But the end hosts are unaware of underlying network and see each other as if they are connected directly. Bus Topology In case of Bus topology, all devices share single communication line or cable. Bus topology may have problem while multiple hosts sending data at the same time. Therefore, Bus topology either uses CSMA/CD tec...
Read more