Insert Table In Excel
DEFINITION:- Create Table Using The Insert Table Option, This Convert Excel Data Into A Table Data. By Converting Your Normal Data To Excel Table Data You Can Have A Huge Benefit, When You Are Working With Range Functions Like V-Lookup - H-Lookup - Index - Match Etc.
1. CREATE TABLE
Select The Cells Range That Contain The Data.Click Insert Tab > Table Group > Table.“Create Table” Dialog Box Will Get Open.If You Have Column Headings, Please Tick On The Check Box “My Table Has Headers”.Verify That Range Is Correct > Click Ok
2. Change The Table Design Style
Click On A Table To Activate The “Table Tools” Tab.Click On “Design” Tab > Table Style.Choose A Style Or Color Option That Appeals To You. (Live Previews Can Be Viewed By Hover The Cursor Over Different Table...