About This Chapter
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.
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.
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.
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.
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.
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.
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.
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.
Other chapters within the Intro to Excel: Essential Training & Tutorials course
- Creating Worksheets & Workbooks in Excel
- Formatting Worksheets & Workbooks in Excel
- Customizing Options & Views in Excel
- Configure to Print & Save in Excel
- Format Cells & Ranges in Excel
- Filter and Sort a Table in Excel
- Order & Group Cells & Ranges in Excel
- Create a Table in Excel
- Modify a Table in Excel
- Use Cell Ranges & References for Formulas & Functions in Excel
- Summarize Data with Functions in Excel
- Functions with Conditional Logic in Excel
- Format & Modify Text with Functions in Excel
- Create a Chart in Excel