TeachUcomp, Inc.

 MY CART
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • Accounting
      • Adobe
        • Acrobat
        • Lightroom Classic
        • Photoshop
        • Photoshop Elements
      • Crystal Reports
      • Employment Skills
        • Interview Skills
        • Resume Skills
      • For Lawyers
        • Excel for Lawyers
        • Outlook for Lawyers
        • QuickBooks for Lawyers
        • Word for Lawyers
      • HTML
      • JavaScript
      • Microsoft Office
        • Access
        • Excel
        • Microsoft Office Suite
        • OneNote
        • Outlook
        • Outlook on the Web
        • PowerPoint
        • Publisher
        • Word
      • Microsoft Project
      • Microsoft Teams
      • QuickBooks Online
      • QuickBooks Pro
      • Sage
        • Peachtree
        • Sage 50
      • SQL
      • Windows
    • Video Course Options
  • SUBSCRIPTIONS
  • MANUALS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements
    • Crystal Reports
    • For Lawyers
      • Excel for Lawyers
      • Outlook for Lawyers
      • QuickBooks for Lawyers
      • Word for Lawyers
    • HTML
    • JavaScript
    • Microsoft Office
      • Access
      • Excel
      • OneNote
      • Outlook
      • Outlook on the Web
      • PowerPoint
      • Publisher
      • Word
    • Microsoft Project
    • Microsoft Teams
    • QuickBooks Online
    • QuickBooks Pro
    • Sage
      • Peachtree
      • Sage 50
    • SQL
    • Windows
  • REFERENCE CARDS
    • Adobe
      • Acrobat DC
      • Lightroom Classic CC 2018
      • Photoshop 2021
      • Photoshop 2020
      • Photoshop CC 2018
      • Photoshop Elements 2023
      • Photoshop Elements 2022
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
      • Google Docs
      • Google Drive
      • Google Forms
      • Google Sheets
      • Google Slides
    • Mac OS
      • Mac OS Ventura-Mojave Keyboard Shortcuts
    • Microsoft Office
      • Microsoft Office 365
        • Access for Office 365
        • Excel for Office 365
        • Microsoft Office 365
        • Outlook for Office 365
        • PowerPoint for Office 365
        • Publisher for Office 365
        • Word for Office 365
      • Microsoft Office 2021
        • Access 2021
        • Excel 2021
        • Microsoft Office 2021
        • Outlook 2021
        • PowerPoint 2021
        • Publisher 2021
        • Word 2021
      • Microsoft Office 2019
        • Access 2019
        • Excel 2019
        • Microsoft Office 2019
        • Outlook 2019
        • PowerPoint 2019
        • Publisher 2019
        • Word 2019
      • Microsoft Office 2016
        • Access 2016
        • Excel 2016
        • Microsoft Office 2016
        • OneNote 2016
        • Outlook 2016
        • PowerPoint 2016
        • Publisher 2016
        • Word 2016
      • Microsoft Office 2013
        • Excel 2013
        • Microsoft Office 2013
        • OneNote 2013
        • Outlook 2013
        • PowerPoint 2013
        • Word 2013
      • Microsoft Office for iPad
        • Microsoft Office for iPad
    • Microsoft Teams
      • Microsoft Teams
    • QuickBooks Online
      • QuickBooks Online
    • QuickBooks Pro
      • QuickBooks Pro 2023
      • QuickBooks Pro 2022
      • QuickBooks Pro 2021
      • QuickBooks Pro 2020
      • QuickBooks Pro 2019
      • QuickBooks Pro 2018
      • QuickBooks Pro 2017
      • QuickBooks Pro 2016
      • QuickBooks Pro 2015
      • QuickBooks Pro 2014
    • Sage
      • Sage 50 2019
      • Sage 50 2018
    • SQL
      • SQL
    • Windows
      • Windows 11
      • Windows 11 and 10 Keyboard Shortcuts
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Ventura
      • Mac OS Monterey-Mojave
    • Microsoft Office
      • Word and Excel (Mac) 2022
      • Word and Excel (PC/Windows) 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop (PC/Windows) 2023
      • QuickBooks Desktop (PC/Windows) 2022-2015
    • Windows
      • Windows 11 and 10
  • SUPPORT
    • Company
      • About Us
      • Blog
      • Contact Us
      • Our History
      • Our Philosophy
        • Customer Service
        • Mission
      • Policies
      • Testimonials
    • Contact Us
    • FAQ
    • Help
    • Lost Password
    • Register a Product
  • LOGIN
    • Manage My Account
    • Member Login
    • My Courses
Shop Now

How to Create Tables in Microsoft Excel 2013

by Keeley Byrnes / Thursday, June 27 2013 / Published in Excel 2013, Latest, Microsoft, Office 2013

Excel can store information in tables. An Excel table is information stored in a table format and defined as being a table within Excel. When you store information in a table format, you place the different types of information that you want to collect in columns, which are called “fields” in database terminology. Each “field” contains a separate type of information. Examples could be: “First Name,” “Last Name,” “Title,” “Address,” “City,” “State,” and so forth. 

Tables can be a great way to organize and store information. In this post, we will discuss how to create a table in Microsoft Excel 2013 and then how to add records to the table.

 

 

 

Create the Table

1. Select the cell into which you want to type your first field name.

Slide1

2. Type the field name, and then press the “Tab” key on your keyboard to move to the cell to the right.

Slide2

3. Repeat step 2 until you have made your entire header row.

Slide3

4. Select the header row by clicking and dragging over the cells that contain the header row labels.

Slide4

5. Click the “Table” button in the “Tables” group on the “Insert” tab in the Ribbon.

Slide5

6. In the “Create Table” dialog box, check the “My table has headers” check box and click “OK”.

Slide6

 

 

Add Records to the Table

1. Select the first field cell in the next available empty row within the table.

Slide7

2. Type the information into the field.

Slide8

3. Press “Tab” on your keyboard to move to the cell to the right and enter the appropriate data for that field.

Slide9

 

4. Repeat steps 2 and 3 until the new record is fully entered. Then press the “Tab” key on your keyboard to create a new blank row for the next record.

Slide10

Tagged under: 2000, 2002, 2003, 2007, 2010, 2013, 97, book, cd, class, classes, course, courses, create, download, dvd, excel, excell, help, how, how-to, micro, microsoft, ms, office, online, soft, software, tables, teachucomp, training, tutorial, video, xp

About Keeley Byrnes

Keeley is our Director of Marketing and has been with TeachUcomp since 2010. Keeley manages all aspects of our Marketing Department, acts as liaison for our reseller and affiliate partners and also authors courses in software and taxation.

What you can read next

Void a Check in QuickBooks Desktop Pro - Instructions and Video Lesson: A picture of a user voiding a check in QuickBooks Desktop Pro.
Void a Check in QuickBooks Desktop Pro- Instructions and Video Lesson
Changes to OneDrive Storage Plans- News: A picture of the OneDrive home page (Source: Microsoft).
Changes to OneDrive Storage Plans- News
A picture of a user creating an aggregate function query in Access.
Aggregate Function Queries in Access – Instructions

 

Recent Posts

  • A picture that shows how to create moving elements in Photoshop Elements.

    Moving Elements in Photoshop Elements – Instructions

    Overview of How to Create Moving Elements in Ph...
  • Layer Types in Photoshop Elements: A picture of a user simplifying a Smart Object layer in Photoshop elements.

    Layer Types in Photoshop Elements- Instructions

    Overview of the Layer Types in Photoshop Elemen...
  • A picture of the training interface for the digital download or DVD versions of our Photoshop Elements training, titled “Mastering Photoshop Elements Made Easy™ v.2023.”

    Photoshop Elements Training

    Photoshop Elements Training for Photoshop Eleme...

Categories

Archives

  • GET SOCIAL

© 2001-2023 Copyright TeachUcomp, Inc. All rights reserved.

TOP
Sale! $49 All-Access 0 Days 6 Hours 54 Minutes 57 Seconds      $199 $49 Entire Library!
See Deal