Login
Copyright

Ch 6: Insert Data in Cells and Ranges in Excel

About This Chapter

These instructional videos will walk you step-by-step through the process of inserting data in cells and ranges in Excel. You'll learn how to add data to an individual cell and to a group of cells which may be adjacent or not.

Insert Data in Cells and Ranges in Excel: Chapter Summary

As you become accustomed to utilizing the various features and attributes that enable you to create Excel workbooks and worksheets, you are going to want to know how to insert data into specific cells and groups of cells, or 'ranges'. Knowing how to do so enables you to populate a cell or range, or modify it easily, whether you are working on a single worksheet or many. You will also learn how to add or delete specific cells quickly and simply.

Experienced Excel experts take you through our video lessons, which break up Excel skills and techniques into component parts that are easy to learn and master. With each video lesson you'll find an accompanying interactive online quiz that will help you measure how well you understand the concepts presented in the video.

Topics covered in this chapter include:

  • How to append multiple Excel worksheets
  • Using find and replace functions
  • Copying and pasting data
  • Using the AutoFill feature
  • Inserting and deleting cells

(Note: All demonstrations in this chapter will be using Microsoft Excel 2013. Certain features, tools or displays may be different in other versions.)

Excel is a trademark of the Microsoft Corporation, which is not affiliated with Study.com.

6 Lessons in Chapter 6: Insert Data in Cells and Ranges in Excel
How to Append Multiple Worksheets

1. How to Append Multiple Worksheets

When you have multiple worksheets or workbooks with similar data, you may want to merge them together in order to create one master. This lesson will guide you through the steps to appending multiple worksheets together.

How to Find and Replace Data in Excel

2. How to Find and Replace Data in Excel

If you need to find a specific piece of information in a spreadsheet full of data, the search feature is mighty powerful. This lesson will guide you through how to use the Find and Find & Replace commands.

How to Copy and Paste Data in Excel

3. How to Copy and Paste Data in Excel

If you like to save time and perform routine tasks more efficiently, the Copy and Paste commands in Excel can help. This lesson will look at the components of these commands and examples of how the commands are used.

Using the AutoFill Tool in Excel

4. Using the AutoFill Tool in Excel

If you want to make some of your common Excel tasks a bit easier and perform them with more efficiency, AutoFill is definitely a tool you should learn how to use. This lesson will guide you through the tool and how to take advantage of its features.

Cells in Excel: How to Insert and Delete Cells

5. Cells in Excel: How to Insert and Delete Cells

When working with an Excel worksheet, you may need to reorganize, remove or add data. You will need to understand the steps to insert cells or delete them. This lesson will explain the Insert and Delete commands.

Using the AND function in Excel

6. Using the AND function in Excel

Many commonly used functions in Excel are the simple-to-moderate mathematical functions. However, Excel also has text functions that significantly enhance the mathematical functions. In this lesson, we'll learn about the AND function.

Final Exam
Intro to Excel: Essential Training & Tutorials
This course currently has no final exam ready
Chapter Exam

Earning College Credit

Did you know… We have over 95 college courses that prepare you to earn credit by exam that is accepted by over 2,000 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Support