View:
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…]
