Home Menu

Dec92020 by excelhelp13No Comments

Delete Cell-Column-Rows And Sheet In Excel

DEFINITION:- The Selected Cells, Rows, Columns Or Sheet Can Be Removed By Delete Option. The Delete Option Has Four Drop-Down Menus. You Can Choose Option From The Drop-Down Menu To Delete The Particular Object. Let's Learn All Option In Detail. 1. Delete cells Delete A Cell In The Worksheet Using This Option.Step 1 – Click On Home Tab > Delete >Delete Cells. Select The Option Which You Want In Your Work. 2. Delete Sheet Row Delete A Row In The Worksheet Using This Option.Step 1 – Select Cell Or Row And Click On Home Tab > Delete > Delete Sheet Row. Step 2- After Click On Delete Sheet Row, The Entire Row Containing The Selected...

Dec82020 by excelhelp13No Comments

Insert Cells Rows Sheet In Excel

Home Menu, Menu Bar

DEFINITION:- With Insert Command You Can Add A New Column, Row, Cells And Sheet In The Workbook With Using Insert Options. Step:- Click On The Insert In The Home Tab One Dialog Box Will Appear And In That Dialog Box It Will Display The Following Option As Shown in Images. Lets Learn About All The Options Of Insert. 1. Insert cells With Insert You Can Insert A Cell In The Worksheet.Step 1 – Click On Home Tab > Insert > Insert Cells. 2. Insert Row With Insert You Can Insert A Row In The Worksheet.Step 1 – Click On Home Tab > Insert > Insert Row. 3. Insert Column With Insert You Can Insert A Column In The Worksheet.Step 1 – Click On Home Tab > Insert > Insert Column 4. Insert Sheet&nb...

Dec82020 by excelhelp13No Comments

Decrease Or Increase Decimal In Excel

Home Menu, Menu Bar

Definition Decrease Decimal:- Decrease Decimal Button Can Decrease The Amount Of Decimal Places .Unnecessary Decimal Places In A Cell Or Database Can Be Removed With The Decrease Decimal Option. Step 1- Select The Data You Want To Format And Click On The Decrease Decimal Button. Step 2:- Every Time You Click On Decrease Decimal Button It Decreased The Amount Of Decimal Places. Definition Increase Decimal:- Increase Decimal Button Can Increase The Amount Of Decimal Places . Step 1- Select The Data You Want To Format And Click On The Increase Decimal Button Step 2- Every Time You Click On Increase Decimal Button, Increased The Amount Of Decimal Places.

Dec82020 by excelhelp13No Comments

Merge And Center In Excel

Home Menu, Menu Bar

DEFINITION:- Merge And Center Command Is Used To Combine Multiple Cells Into A Single Cell. Step 1- Select The Cells Which We Want To Merge Together Into One Cell. Step 2- Click On Merge And Center And Check The Result In Below Image.

Dec82020 by excelhelp13No Comments

Wrap Text In Excel

Home Menu, Menu Bar

DEFINITION:-Wrap Text Is A Great Feature That Been Used To Adjust The Overline Text Into The Cell. Wrap Text Adjust The Text With A Break Line In A Cell. Please Follow The Step Shown Below And Example In Images. Step 1 – Select The Cell And Click On Wrap Text Button. Step 2- After Click on Wrap Text button, Please Check The Result Bellow.

Dec82020 by excelhelp13No Comments

Increase And Decrease Indent In Excel

Home Menu, Menu Bar

Definition Increase Indent:- With The Increase Indent Command, You Can Add The Space Between The Border And The Data In A Cell. Every Time You Click On The Increase Indent Button, Excel Add A Little Space Between The Border And The Data In The Cell. Step 1- Select The Cell That Contains The Text. And Click On The Increase Indent Button. Step 2 - Every Time You Ever Click On The Increase Indent Button, Excel Add A Little Space Between The Border And The Data In The Cell. Definition Decrease Indent:- With The Decrease Indent Command, You Can Remove The Space Between The Border And The Data In A Cell. Every Time You Click On The Decrease Indent Button, Excel Removes A Little Space Between The Border And The Data In The Cell. Step 1- Select The Cell...

Dec82020 by excelhelp13No Comments

Orientation In Excel

Home Menu, Menu Bar

Definition:- The Orientation Command Can Adjust The Text Vertical And Diagonally By Rotating The Cells Text Clockwise And Counter-Clockwise 90 Degrees. Step 1- Select The Cell You Want To Format And Click On Orientation Button. Step 2 – Select The Option In The Orientation Options As Per Your Requirement And Get The Result. For Example:- Please Check The Image Below.

Dec82020 by excelhelp13No Comments

Alignment In Excel

Home Menu, Menu Bar

Definition:- How The Text Or Number Is Set In The Cell Or How You Want It To Be Set Such As Up, Down, Left, Right Or Middle. This Can Be Done With The Alignment Tool. Alignment Consists Of Two Methods. (1) Horizontal Which Means To The Left, Center Or Right. (2) Vertical Which Means Up, Middle Or Down. Horizontal Alignment Left − Aligns The Cell Contents To The Left Side Of The Cell. Center − Centers The Cell Contents In The Cell. Right − Aligns The Cell Contents To The Right Side Of The Cell. 2.Vertical Alignment − • Top Aligns:- The Cell Contents To The Top Of The Cell.• Center Align:- Centers The Cell Contents Vertically In The Cell.• Bottom Aligns:- The Cell Contents To The Bottom Of The Cell.

Dec82020 by excelhelp13No Comments

How To Fill Color In Excel

Home Menu, Menu Bar

Definition:- Fill Color Is Used To Add A Color To A Background In A Cell / Database.. Step 1- Select The Cell Or Database Range And Then Click On The Fill Color Icon. Step 2- Select The Color You Want To Highlight In The Background Of Your Cell Or Database.

Dec82020 by excelhelp13No Comments

How To Use Borders In Excel

Home Menu, Menu Bar

Definition:- The Border Option Is A Built-In Tool That Provides Border Styles To Border One Or More Cells On A Spreadsheet. You Can Also Use The Borders Tool To Create Your Own Custom Border. Step1 - Select The Cell Or Range That You Want Format And Click On Borders Drop Down Box. Step 2- Choose The Border Style In Borders Drop Down Box That You Want . You Can Also Use The Borders To Draw Borders Tool To Create Your Own Custom Borders.