Insert Menu Archives

Mar42023 by excelhelp13No Comments

Dynamic datasheet in Excel

STEPS : Select data with header (In which the formula is placed) Press Ctrl+T Check on My table has headers Click OK If you uncheck My table has headers it will set the heading with column 1 , column 2 , column 3, column 4, column 5, column 6. Your data is now converted to a table. you can choose table style from the Design tab. Now when you add any new information into this data, the formula you have applied will be automatically applied in new information.

Mar42023 by excelhelp13No Comments

Hyperlink in Excel

Insert Menu

Hyperlinks are very useful for quickly retrieving information from a file / website related to a current file while working in Excel. You can also generate link to specific elements like photos, charts etc. you can copy or edit the link. you can also delete the link easily. Create link to a new File. This Option is use to link a new file with your current file. STEPS : Select Cell ( where you want to create a link.) Go to Insert tab Click Hyperlink (Ctrl+K) Click Creat new Document In the Name of new Document box, type a name of the new file In the when to edit – select (1) Edit the new document letter or (2) edit the new document now In the Text to Display box, type the text that you want to represent your link 8. Click on Scre...

Jun162022 by excelhelp13No Comments

WordArt in Excel

Insert Menu, tips & Tricks

WordArt is a quick way to give text or heading a special effects. WordArt is useful for making headings stylish and attractive and for highlighting certain words. How to insert WordArt in excel ? STEPS : 1. Open Worksheet /Database, where you want to insert decorative text. 2. Insert tab >> in the Text group >> click WordArt. 3. Click any WordArt style. 4. A Textbox will appear in your sheet. You can rotate or move the textbox wherever you want. 5. Type the Text as per your requirement in the Text box. 6. Click anywhere in the sheet or press “esc” key to exit. If you have excel version above 2013 then plese check the below image to find WordArt Location. Insert >> Text >> WordArt How to make changes or e...

Jun92022 by excelhelp13No Comments

Insert multiple Columns in one Click in Excel.

Insert Menu, tips & Tricks

Usually Insert Column command insert only one column at one time. But you can insert multiple columns in one click in Excel. Follow the below mentioned steps. STEPS : Select the same number of columns as you want to insert. For example, if you want to insert 2 blank columns, select 2 columns.Right click on it.Click on insert. 4. Blank columns will be inserted above the selected columns. Note- if there is data in the selected columns, it’s ok. Because that data will not be deleted.

Dec302020 by excelhelp13No Comments

Header And Footer Bottom Set In Excel

Insert Menu, Menu Bar, Page Layout

Header And Footer Introduction: You have choice to add headers or footers at the top or bottom of a printed worksheet in Excel. You can create your own header and footer, or you can use many built-in headers and footers available in excel. As example, you can create a footer that has page numbers, no of pages ,date, sheet name, Time, Picture path of your file etc.. Note:- Headers and footers are displayed only in Page Layout view, Print Preview, and on printed pages. 1. How To Insert Header And Footer In Excel: Click The Worksheet Where You Want To Add Or Change Headers Or Footers.Click On The Insert Tab > In The Text Group > Click Header & Footer.Type Your Custom Text In The Header Or Footer Text Box If You Want To Add Or Edit An Existing Header Or Footer, Click On ...

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