excelhelp13, Author at Excel-Help

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

Mar42023 by excelhelp13No Comments

Formula On Text In Excel

FORMULAS, More Functions

By default If there is text with numbers in excel cell, then that numbers are also counted as text format. So that no formulas can be used in this type of data. But to achieve it this can be possible with the use of custom number format. Example : See the image below. we have data in column B and column C that contains numbers and text both in a cell. Now we want to multiply column B with column C. But the formula doesn't work because the data in column B and column C also have text with numbers. An error occurs. This problem can be solved by using custom number format. The data in column B and column C will need to be converted from text format to number format. Follow the Steps Below. Note:- Follow the steps below before data entry. Select cells B4:B7 or col...

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

Mar42023 by excelhelp13No Comments

STDEV (Standard deviation) Function in excel

FORMULAS, More Functions

STDEV (Standard deviation) Function returns a number that tells you how far numbers are from their mean (average). Syntax=STDEV (number1, [number2], …)Argumentsnumber1 - First number or reference in the sample.number2 - [optional] Second number or reference. For example, suppose you have a group of 10 students, and you are recording their result in percentage. In this data, the average result is 65 %, and the standard deviation is 4 %. It means that most of the student's result is within 4 % of the average result (which would be 62-69 %).

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

How to Permanently delete hidden Rows and Columns in Excel.

More Functions, tips & Tricks

Sometimes when working on Excel data, users hide unwanted multiple rows and columns. Which they do not want to be visible. And then deleting those multiple hidden rows and columns inside the data after the work is done is a time consuming task. Excel has an inbuilt function to find and delete hidden rows and columns at once. Steps - 1.Go to "File" Tab 2. Click On "info" 3. Click on "check for issues" 4. Click on "inspect document" 5. In the Document Inspector dialogue box, Click on “Inspect” 6. It will show hidden rows and columns in the option of “Hidden rows and columns”. 7. Click on “Remove All” button in it. 8. Close the dialog box.

Mar42023 by excelhelp13No Comments

Delete hidden Worksheets Permanently in Excel.

More Functions, tips & Tricks

Sometimes when working on Excel workbook that contains many hidden worksheets which are not useful. Unhiding hidden sheets and deleting one by one is time consuming task. Excel has an inbuilt function to find and delete hidden sheets at once. Note- Deleted Sheets can't be restored. And Can't be undo. Steps- Go to "File" Tab. Click on "Info" Click on "Check for issues" Choose "Inspect document" 5. In the Document Inspector dialogue box, Click on “Inspect” 6. It will show number of Hidden sheets in the option of “Hidden Sheets”. 7. Click on “Remove All” button in it. 8. Close the dialog box.

Mar42023 by excelhelp13No Comments

Delete hidden Data Permanently in Excel.

More Functions, tips & Tricks

Sometimes when working on Excel Data there might be a situation when many cells contains hidden data, information, etc. which are not useful. Unhiding them and deleting one by one is time consuming task. Excel has an inbuilt function to find and delete hidden data at once. Note- Deleted data can't be restored. And Can't be undo. Steps - Go to File Tab. Click on "Info" Click on "Check for issues" Click on inspect document. 5. In the Document Inspector dialogue box, Click on “Inspect” 6. It will show Hidden data in the option of “document properties and personal information”. 7. Click on “Remove All” button in it. 8. Close the dialog box.

Mar42023 by excelhelp13No Comments

Combine data From Multiple cells into a single cell.

Text, tips & Tricks

You can combine two or more cells data in a single cell. To combine data From Multiple cells into a single cell, follow the steps below. Type = Select First cell you want to combine. Type & Type double inverted comma with space in between. " " Type & Select Second cell you want to combine. See the examples in the image below.

Mar42023 by excelhelp13No Comments

DATEDIF Function in Excel

Date And Time, FORMULAS, tips & Tricks

The DATEDIF function is useful for finding the difference between two date values in years, months or days. Syntax: =DATEDIF (start date,end date,unit) Arguments- Start date - The date from which you want to find the difference. End date - The date until which you want to find the difference. Unit - The time unit to use (years, months, or days). UnitResult"y"Difference in complete years"m"Difference in complete months"d"Difference in days"md"Difference in days, ignoring months and years"ym"Difference in months, ignoring years"yd"Difference in days, ignoring years Examples: