Definition:- Fill Color Is Used To Add A Color To A Background In A Cell / Database..
Step 1- Select The Cell Or Database Range And Then Click On The Fill Color Icon.
Step 2- Select The Color You Want To Highlight In The Background Of Your Cell Or Database.
Definition:- The Border Option Is A Built-In Tool That Provides Border Styles To Border One Or More Cells On A Spreadsheet. You Can Also Use The Borders Tool To Create Your Own Custom Border.
Step1 - Select The Cell Or Range That You Want Format And Click On Borders Drop Down Box.
Step 2- Choose The Border Style In Borders Drop Down Box That You Want .
You Can Also Use The Borders To Draw Borders Tool To Create Your Own Custom Borders.
Definition:- The Font Face Is Used To Change The Font Type & Style
Step1 - Select The Cell You Want To Format. On The Home Tab, Open The Font Drop-Down Menu.
Step 2- Choose Fonts. When You Scroll The Mouse, Excel Live Preview Feature Displays Various Fonts In The Selected Cell. Once Select Please Click Ok.
Font Size:-Font Size Option Can Make The Font Size Smaller Or Larger In Any Of The Selected Range.
Step 1- Select The Cell Or Range That You Want Format And Click On Font Size Drop Down Box.
Step 2- Choose The Font Size In Font Size Drop Down Box That You Want .
Underline The Font:- Underline Command Is Use To Single Or Double Underline The Text Or A Number In A Cell.
Bold Font:-The Bold Command Is Use To Make The Data Bold (Incre...
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...
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...
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
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
Open Excel FileClick Alt + F11 Or Click On Developer Tab And Go Visual Basic Application.One Dialog Screen Will Get Open.Click Insert And Add Module.Create Sub Procedure With Any Name.Make Sure The Procedure Name Start With String And Without Space.Write The Code In Between Sub And Sub End.Click Run Button Or Insert A Form Button In Excel Sheet.Any Sub Procedure / Macro Can Be Assign To A Button.Then Goto Visual Basic Editor Prepare Sub Procedure.Sub Unhide_Rows_On_IF_Condition() End SubIn That Procedure Whatever Event You Want To Get Fire You Will Have To Right The Code According To It.In This Example We Will Unhide The Rows With For Loop Against If Condition.If You Want To Re Hide It Use This Code ActiveSheet.Range("F"& i ).Rows.Hidden=TrueNote: Please Use Range & Sheets Name ...
Open Excel FileClick Alt + F11 Or Click On Developer Tab And Go Visual Basic Application.One Dialog Screen Will Get Open.Click Insert And Add Module.Create Sub Procedure With Any Name.Make Sure The Procedure Name Start With String And Without Space.Write The Code In Between Sub And Sub End.Click Run Button Or Insert A Form Button In Excel Sheet.Any Sub Procedure / Macro Can Be Assign To A Button.Then Goto Visual Basic Editor And Select Thisworkbook And Then Change The Event To Workbook From The Dropdown As Shown In Image.One Sub Procedure Will Automatically Get PreparedPrivate Sub Workbook_Open() End SubIn That Procedure Whatever Event You Want To Get Fire You Will Have To Right The Code According To It.In This Example We Will Delete Hide And Unhide The Rows.That’s It :)Please Check The...
INTRODUCTION: Input Box Is A Part Of Excel Application.
Open Excel File Click Alt + F11 Or Click On Developer Tab And Go Visual Basic Application.One Dialog Screen Will Get OpenClick Insert And Add ModuleCreate Sub Procedure With Any NameMake Sure The Procedure Name Start With String And Without Space.Write The Code In Between Sub And Sub End Click Run Button Or Insert A Form Button In Excel SheetAny Sub Procedure / Macro Can Be Assign To A Button Like This Example To Fire The Event On Clicking The Button.Example Inputbox ("This Is My First Code")That's It :)Please Check The Images And Video For More Info.
