excel vba Archives - Excel-Help

Dec102020 by excelhelp13No Comments

How To Use Find And Replace In Excel

FIND : Click CTRL + F One Find And Replace Dialog Box Will PopupSelect Database Or Range Or Directly Type The Text Or Number To Find Out OR Follow The Below Step For Another Method.Click The Home TabGo To The Editing Group Command Tab.Click On Find & Select ButtonA Dropdown Menu Will Appear. Click On Find. Steps :- In The Dialog Box Input The Text Or Number In “Find What” To Find The Data Within The Worksheet Or Database For And Then - Click “Find Next” MULTIPLE SEARCH : If You Want To Find Out How Many Times A Particular Word Or Phrase Has Been Used Or Found In Your Database Or Worksheet , Click “Find All” In The Dialog Box Will Populate The Match Row Where The Query Data Is Available. FIND & REPLACE : Select Database Or RangeClick The Home Tab...

Dec102020 by excelhelp13No Comments

How To Insert Shapes In Excel

Insert Menu, Menu Bar

DEFINITION:- You Can Add Shapes, Such As Boxes, Circles, Arrows Etc.. To Your Worksheet As Shown In Image Below. Steps:- On The Insert Tab, Click Shapes.Click The Shape You Want To Insert And Then Click Anywhere In The Workspace In The Worksheet And Then Drag The Shape To The Exact Place .There Are Lots Of Shapes Available In Excel And It Also Useful To Assign A Sub Procedure (Macro) By Creating A Beautify Button Type Object.

Dec102020 by excelhelp13No Comments

How To Insert Online Picture In Excel

Insert Menu, Menu Bar

DEFINITION:- Online Picture Option Is Use To Download An Images Or Pictures Into Your Excel Worksheet From Other Sources. Steps:- Insert Tab > Click On The Online Pictures. (Its In The Illustrations Group.)In The Online Picture Dialog Box, Locate The Picture That You Want.Click On Insert • Bing Image Search - Bing (Default) To Use The Bing Search Engine To Locate Images On The Web Of A Particular Type That You Want To Add To Your Worksheet• One Drive Personal- One Drive To Locate Saved Images On Your Sky Drive To Add To Your Excel Worksheet Online Pictures Dialog Box Displays A Scrollable List Of Thumbnails Of The Photos Or Line Art That You Can Insert Into Your Current Worksheet.

Dec102020 by excelhelp13No Comments

ScreenShot In Excel

Insert Menu, Menu Bar

Definition:- Using The Screenshot Option You Can Quickly And Easily Add A Screenshot To Your Worksheet To Enhance Readability Or Capture Information Without Leaving The Program That You Are Working In. This Feature Is Available In Excel Above Version Of 2007. Steps:- Insert Tab > Screenshot.Choose Window Thumbnail In Available Windows Or Use Screen Clipping.Format And Crop Your Screenshot In Excel.You Can Also Take The Quick Snap Shot Of Other Open Application And Quick Add To Your Worksheets.

Dec102020 by excelhelp13No Comments

How To Insert Picture In Excel

Insert Menu, Menu Bar

Steps: Go To Insert Tab > Click On The Pictures. (Its In The Illustrations Group.)In The Insert Picture Dialog Box, Locate The Picture That You Want.Click On The Insert Button. Re-Size The Picture/Image.Place The Picture In The Cell.

Dec102020 by excelhelp13No Comments

SmartArt In Excel

Insert Menu, Menu Bar

Definition:- The Smart Art Graphics Option Is Used To Make The Information Look More Visually Good. Using These Tools From Excel, You Will Be Able To Create Great Smart Arts That Can Be Used For A Variety Of Purpose. Lets Learn How To Insert Smart Art Into A Worksheet And Customize It After Inserting It. Steps:- Insert Tab > In The Illustrations Group > Click Smart Art.In The Smart Art Graphic Dialog Box, Click The Type And Layout That You Want. 3. Enter Your Text By Doing One Of The Following: Click [Text] In The Text Pane, And Then Type Your Text.Copy Text From Another Location Or Program, Click [Text] In The Text Pane, And Then Paste Your Text. 4. Change The Colors Of An Entire Smart Art Graphic You Can Apply Color Variations That Are Derived Fr...

Dec102020 by excelhelp13No Comments

Insert Table In Excel

Insert Menu, Menu Bar

DEFINITION:- Create Table Using The Insert Table Option, This Convert Excel Data Into A Table Data. By Converting Your Normal Data To Excel Table Data You Can Have A Huge Benefit, When You Are Working With Range Functions Like V-Lookup - H-Lookup - Index - Match Etc. 1. CREATE TABLE Select The Cells Range That Contain The Data.Click Insert Tab > Table Group > Table.“Create Table” Dialog Box Will Get Open.If You Have Column Headings, Please Tick On The Check Box “My Table Has Headers”.Verify That Range Is Correct > Click Ok 2. Change The Table Design Style Click On A Table To Activate The “Table Tools” Tab.Click On “Design” Tab > Table Style.Choose A Style Or Color Option That Appeals To You. (Live Previews Can Be Viewed By Hover The Cursor Over Different Tabl...

Dec92020 by excelhelp13No Comments

Delete Cell-Column-Rows And Sheet In Excel

Home Menu, Menu Bar

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

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

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...