Thursday, November 7

Tag: excelhelo

Create drop down List in Excel.

Create drop down List in Excel.

Data, tips & Tricks
STEPS : Prepare the list for drop-down in Excel sheet.Select the cell or range where you want to create a drop-down.Go to View tab.Click on Data Validation.In the Data Validation dialogue box, . Choose “List” from Allow drop-down.Type or Select the range of source data in source box.Click OK Note- you can create a drop-down in same sheet or in other sheet and can pass the referecne according to the requirement. See the Result in Below Image. Remove/Delete Drop-Down in excel. Select Cell or Range, who has drop-down that you want to Delete.Go to view tab.Click on Data Validation.In the Data Validation dialogue box, Click on Clear All.Click OK. See the Result in Image below.
Alignment In Excel

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.
How To Use Borders In Excel

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.
How To Change Font In Excel

How To Change Font In Excel

Home Menu, Menu Bar
Definition:- The Font Face Is Used To Change The Font Type & Style Step1 - Select The Cell You Want To Format. On The Home Tab, Open The Font Drop-Down Menu. Step 2- Choose Fonts. When You Scroll The Mouse, Excel Live Preview Feature Displays Various Fonts In The Selected Cell. Once Select Please Click Ok. Font Size:-Font Size Option Can Make The Font Size Smaller Or Larger In Any Of The Selected Range. Step 1- Select The Cell Or Range That You Want Format And Click On Font Size Drop Down Box. Step 2- Choose The Font Size In Font Size Drop Down Box That You Want . Underline The Font:- Underline Command Is Use To Single Or Double Underline The Text Or A Number In A Cell. Bold Font:-The Bold Command Is Use To Make The Data Bold (Incre...