Entering & Editing Data in Excel 2013

Sorted by:  

How to Drag and Drop in Excel 2013

The first editing technique you need to learn in Excel 2013 is drag and drop. Drag and drop is primarily a technique for moving cell entries around a worksheet, you can adapt it to copy a cell selection [more…]

How to Add Records to Data Lists via the Data Form in Excel 2013

Excel 2013 allows you to add records to data lists by using the data form. The first time you click the custom Form button you added to the Quick Access toolbar, Excel analyzes the row of field names and [more…]

How to Edit Records in the Data Form in Excel 2013

After the database is under way and you’re caught up with entering records in Excel 2013, you can start using the data form to edit and perform routine maintenance on the database. For example, you can [more…]

How to Add Data to Data Lists Using the Excel 2013 Form Button

Instead of entering the records of a data list directly in the table, you can use Excel 2013’s data form to make the entries. The only problem is that the command to display the form in a worksheet with [more…]

Excel 2013 Data-Entry Etiquette

To begin to work on a new Excel 2013 spreadsheet, you simply start entering information in the first sheet of the Book1 workbook window. Here are a few simple guidelines [more…]

How to Use Flash Fill in Excel 2013

Excel 2013’s great new Flash Fill feature gives you the ability to take a part of the data entered into one column of a worksheet table and enter just that data in a new table column using only a few keystrokes [more…]

Limit Data Entry with Data Validation in Excel 2013

The Data Validation feature in Excel 2013 can be a real timesaver when you’re doing repetitive data entry, and can also go a long way in preventing incorrect entries in your spreadsheets. When you use [more…]

The Excel 2013 Document Recovery Feature

Excel 2013 offers a document recovery feature that can help you in the event of a computer crash because of a power failure or some sort of operating system freeze or shutdown. The AutoRecover feature [more…]

Eliminate Errors with Text to Speech in Excel 2013

Excel’s Text to Speech feature can help you flag and then correct some errors that otherwise you would have to check and verify by comparing cell to cell. Usually, you do this by checking the columns and [more…]

How to Customize Excel 2013 AutoCorrect

Excel 2013 has an AutoCorrect feature that automatically fixes common typos that you make in the text entries as soon as you complete them. In addition to the errors already recognized by AutoCorrect, [more…]

How to Create Custom AutoFill Lists in Excel 2013

Just as you can use AutoFill in Excel 2013 to fill out a series with increments different from one unit, you can also get it to fill out custom lists of your own design. For example, suppose that you often [more…]

How to Save Custom Views of an Excel 2013 Worksheet

In the course of creating and editing a worksheet in Excel 2013, you may find that you need to modify the worksheet display many times as you work with the document. Excel’s Custom Views feature enables [more…]

How to Select Ranges in Excel 2013

Range names in Excel 2013 are written with the upper-left cell address, a colon, and the lower-right cell address, as in the example A1:F3. Here A1:F3 means the range that begins in the upper-left corner [more…]

How to Enter Cell Content in Excel 2013

You will need to learn some spreadsheet basics in order to work in Excel 2013. When it’s time to actually do something, try entering some text and numbers into cells. [more…]

How to Edit Cell Content in Excel 2013

You can edit the content of a cell in an Excel 2013 worksheet either in the cell itself or in the Formula bar. If you need to edit the content in a cell, you can [more…]

How to Copy and Move Data In Excel 2013

When you’re creating a spreadsheet in Excel 2013, it’s common not to get everything in the right cells on your first try. Fortunately, moving content between cells is easy. [more…]

How to Use AutoFill in Excel 2013

When you have a lot of data to enter into your Excel 2013 spreadsheet, and that data consists of some type of repeatable pattern or sequence, you can save time by using AutoFill. [more…]

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com