Menu Bar Archives - Excel-Help

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

Mar42023 by excelhelp13No Comments

Number Formats In Excel

Home Menu, Menu Bar

Definition:- The Number Format Is A Special Code To Control How Values Are Displayed In Excel. Number Formats Change The Way Numeric Values Are Displayed. But They Do Not Change Actual Values. General - General Option Is The Default Option Applied By Excel For Any Value Number Or Text Format 1. Number:- Number Option Is Used For General Display Of Numbers. The Decimal Number Decimal Can Be Specified. if Want To Display Negative Numbers In Different Formats. 2. Currency:- The Currency Option Can Be Used To Specify Any International Currency Symbol With Numbers. And Also To Specify The Decimal Number. 3. Accounting:- Accounting Option Similar To Currency Option. The Accounting Option Can Set The Currency Symbols And Decimals Together. 4. Date:- With D...

Mar42023 by excelhelp13No Comments

Dynamic Borders in Excel.

Home Menu, tips & Tricks

Excel has an inbuilt Feature to add borders automatically on your worksheet while you are entering value/data in a worksheet. Steps - 1. Select range or entire columns or entire rows or entire sheet. 2. Go to Home tab. 3. Click on Conditional Formatting. 4. Choose New Rule. 5. In the New Formatting Dialogue box, Click on “use a formula to determine Which cells to format” 6. Enter formula in the box- =A1<> “” Note - A1 is a first cell of selection 7. Click on Format 8. Go to Border tab. 9. Click on “outline” 10. Click OK 11. In the New Formatting Dialogue box, Click OK 12. See the Result in below Image. Entering the data automatically adds a border to that cell.

Mar42023 by excelhelp13No Comments

CEILING Function in Excel.

Menu Bar, View

The CEILING Function Rounds a Number Up to its Nearest Multiple of Significance. CEILING Function helps to round up the numbers as per the requirement. Syntax: =CEILING(Number,Significance) Arguments: Number: The value that you want to Round Up. Significance: The Multiple that you want to Round Up. See the Examples in blow Image.

Mar42023 by excelhelp13No Comments

Translate Text into a different Language in excel

Menu Bar, Review, tips & Tricks

Excel Translate is a function that converts text in one language to another language. Mostly English language is used to present the data. However, you can change the default English language content to your own language. Steps- Select cell and Go to Review Tab Click on Translate 3. On the right-hand side, you will see the dialog box. 4. In the Search for, You will see the text of the selected cell. Or type the word you want to convert. 5. Select From - To language in the dialog box. 6. Click on Start Searching button. 7. It will translate the in Hindi as it is the selected translate language for this example..You can choose your language as per requirement. 8. If you click on Insert, it will insert the converted text to the activ...

Mar32023 by excelhelp13No Comments

Create Dynamic Dropdown list with Indirect formula

Data, tips & Tricks

A Dynamic dropdown list or dependent dropdown list is very useful while working in Excel. Which makes our work easier and time get saved. Here we have an example of how to create a dynamic dropdown list or dependent dropdown. Example- We have names of some states and their cities. While working in Excel, you should create a dropdown list so that you do not have to type the name of the state or it's city repeatedly. If we select the state name in dropdown the list of cities of that state will appear automatically. We have the following data. In which dropdown list is to be created in column F3 to G6. Steps- To create a dropdown list of state names Select F3 to F6 In the Data tab, Click on Data Validation. In the dialog box that opens, select “Li...

Jun162022 by excelhelp13No Comments

Hide Several Numbers in a Cell.

tips & Tricks, View

EXAMPLE : Suppose you have a list of some mobile numbers in your worksheet. You don’t want that list to be easily accessible to anyone. So you can hide some digits of all those mobile numbers in excel. STEPS : Select Cell or Range.Right Click on it.Click on Format Cells… 4. Click on Number tab, 5. Click on Custom. 6. In the Type box, Type one of the following options as per your requirement. 7. Click OK 8. See the Result in below Image Unhide Several Numbers in a Cell. STEPS : Select Cell or Range.Right Click on it.Click on Format Cells…Click on Number tab.Click on Custom.Select General from the Drop-Down.Click OK 8. See the Result in below Image

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

Jun162022 by excelhelp13No Comments

How to show Gridlines in excel

Page Layout, tips & Tricks

What is Gridlines ? The horizontal and vertical gray lines that appear between the cells on the worksheet are called Gridlines. How to Show Gridlines : Method-1 Click on Page Layout tab Go to the Gridlines section in sheet options group. Check the view box. Method-2 Click on view tab Go to the show group. Check the Gridlines. Method-3 Click on File tab Click excel Options >> Advanced >> display options for this worksheet Check the show Gridlines