Managing Data in Excel 2013

Sorted by:  

How to Add a Comment to a Cell in Excel 2013

You can add text comments to particular cells in an Excel 2013 worksheet. Comments act kind of like electronic pop-up versions of sticky notes. For example, you can add a comment to yourself to verify [more…]

How to Freeze Panes in Excel 2013

Panes are great for viewing different parts of the same worksheet that normally can’t be seen together in Excel 2013. You can also use panes to freeze headings in the top rows and first columns so that [more…]

How to Edit Comments in a Worksheet in Excel 2013

To edit the contents of a comment in Excel 2013, select it by clicking the Next or Previous command button in the Comments group of the Review tab and then click the Edit Comment button or right-click [more…]

How to Name a Cell or Cell Range in Excel 2013

By assigning descriptive names to cells and cell ranges in Excel 2013, you can go a long way toward keeping on top of the location of important information in a worksheet. Rather than try to associate [more…]

How to Find Records with the Data Form in Excel 2013

In a large data list, trying to find a particular record by moving from record to record in Excel 2013 — or even moving ten records at a time with the scroll bar — can take all day. Rather than waste time [more…]

How to Sort Data Lists on a Single Field in Excel 2013

Every data list you put together in Excel 2013 will have some kind of preferred order for maintaining the records. You can sort on a single or multiple fields. Depending on the list, you may want to see [more…]

How to Query Access Database Tables to Import External Data in Excel 2013

Excel 2013 makes it easy to import data into a worksheet from other database tables created with stand-alone database management systems (such as Microsoft Access), a process known as making an [more…]

How to Perform Web Queries to Import External Data in Excel 2013

To make a web page query in Excel 2013, you click the From web command button on the Data tab of the Ribbon or press Alt+AFW. Excel then opens the New web Query dialog box containing the Home page for [more…]

How to Move Through Records in the Data Form in Excel 2013

Excel 2013 allows you to move through the records you have created in the data form. You can use the scroll bar to the right of the list of field names or various keystrokes to move through the records [more…]

How to Sort Data Lists on Multiple Fields in Excel 2013

You need to use multiple fields in sorting in Excel 2013 when the first field you use contains duplicate values and you want a say in how the records with duplicates are arranged. [more…]

How to Eliminate Records with Excel 2013’s Eliminate Duplicates Feature

You can use Excel’s Eliminate Duplicates feature to quickly find and remove duplicate records from a list (or rows from a table). This is a great feature especially when you’re dealing with a really large [more…]

Sign Up for RSS Feeds

Computers & Software