esxcel formula Archives

Mar42023 by excelhelp13No Comments

Number Formats In Excel

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

Dec82020 by excelhelp13No Comments

How To Use Format Painter In Excel

Home Menu, Menu Bar

Definition:- The Format Painter Is Used To Copy The Formatting Applied To A Cell Or Group Of Cells To Another Cell Or Range Section Of The Excel Sheet. This Is A Quick And Easy Way To Apply Formatting From Existing Data Formatting To Other Cell Data Format. For Example:- We Have Data In First Range A5 To A9. Which Contains Two Formats- Bold And Italic, And We Have Data In Second Range In B5 To B9 Which Has No Formats. Now We Want To Put The Same Formats Of The First Range To The Second Range. Please Follow The Step Shown Bellow. Step 1- Select The Range A5 To A9 And Then Click On Format Painter Button On Home Tab As Shown In Image Below. For The Higher Version Its Available As Icon In Same Home Tab. Step 2- Use The Brush To Paint Over B5 To B9 And We Got The Desire Res...

Dec82020 by excelhelp13No Comments

Paste Special In Excel

Home Menu, Menu Bar

Definition:- With The Help Of Paste Special One Can Paste A Specific Aspect Of The Copied Data. By Giving The Paste Special Command It Will Open A Dialog Box Which Has Many Options By Using Those You Can Make Your Work Easier. Let Us Consider Using Options Like Those Given In Paste Special. Steps- Select The Data That You Want To Copy From One Cell Or Range To Another Cell Or Range And Then Right Click On The Mouse And Select Paste Special Command Option Or You Can Directly Select It From Home Tab Menus As Shown in Images. 1. All- It Allows To Paste All The Data Copied From One Cell Or Range Into The Selected Cell. 2. Formulas- It Allows To Copy And Paste Only Formulas Applied In The Copied Cell To The Selected Cell. 3. VALUES- Paste Only The Value Appl...

Dec82020 by excelhelp13No Comments

How To Use Copy Command In Excel

Home Menu, Menu Bar

Definition:- The Copy Command Help You To Reuse Any Data More Than Once To Avoid The Hard Work Of Rewriting Them. It Is Necessary To Use The Paste Command To Use The Copied To Get Rewrite. Step 1- Select The Data That You Want To Copy From Any Cell Or Range And Then Click On The Copy Button On Home Tab As Shown In Image. Shortcut = Ctrl + C Step 2- - Select The Cell In Which You Want The Paste The Copied Data And Then Click On The Paste Option On Home Tab As Shown In Image. Shortcut = CTRL + V

Dec82020 by excelhelp13No Comments

How To Use Cut Command In Excel

Home Menu, Menu Bar

Definition:- The Cut Command is used to move any type of data from one place to another. It is necessary to use the paste command to move the cut data to another location (Cells or Range). Step 1- Select the Data that you want to move from one cell or range to another and then Click On the Cut Command Option on the Home tab as shown in image. Shortcut = CTRL + X Step 2- Select the cell in which you want selected cut data to appear and then Click on the Paste command Option on home tab as shown in image. Shortcut = CTRL + V