Modifying Columns, Rows, and Cells – Lesson 3

Course Progress
Keep your course progress by saving.

Please log in to save progress.

In this lesson, we are going to learn how to modify the layout of your Excel worksheet by adjusting columns and rows. You’ll learn how to change column width and row height manually by dragging, or by entering specific measurements using the Format menu. We’ll also explore AutoFit options that automatically adjust sizes to fit your content.

You’ll also learn how to insert and delete rows and columns to organize your data better. The lesson explains how to use the Insert and Delete commands properly and highlights the Insert Options button, which lets you control the formatting of inserted elements. It’s important to select entire rows or columns when adding or removing them to ensure consistent formatting and structure.

Finally, we’ll cover how to manage cell content visibility using Wrap Text and Merge & Center. Wrapping text helps display long content over multiple lines within a cell, while merging combines several cells into one and centers the text. These tools help make your worksheet cleaner and more readable.

Modifying Columns, Rows, and Cells
Start Lesson 3
Complete all topics and questions to move to the next lesson.