excel course Archives - Page 2 of 2

Dec82020 by excelhelp13No Comments

How To Use Borders In Excel

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.

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

Dec22020 by excelhelp13No Comments

Compare Time Using If Formula

Logical, Statistical

First Select Any Of The Cell For Output Result. Apply The Formula '=IF(TIME(11,17,30)=D2,"Yes","No") Make Sure That Time After 12:00 Hr Is 13:00 As By Default The Time Value Is In 24 Hrs Format. If You Change The Format To 12 Hrs Then It Fine to Have 01;00 Hrs. But Its Vary With Time Formats. As A Result You Can Choose The Output With If Formula. That's It: :)

Dec22020 by excelhelp13No Comments

Split Or Extract The Data Having More Than One Line In Single Cell

FORMULAS

To Extract Or Split These Type Of Data Please Follow The Step Shown Below.First Select The Cell Having That Kind Of Data.Copy The Cell.Now Open The Note Pad.Remove Double Quote From Start Point And From End Point.Now Copy All Data From Notepad Ctrl + A.Now Go To Excel And Select The Same Range Or Cells Or Whole Column Where You Want The Data To Get Populate.Now Right Click And Paste As Text And You Will Have All Those Data In Separate Cells.Now If Needed Copy Those Data And Transpose T o Column From Rows.That's It :)