• 6 hours
  • Easy

Free online content available in this course.

course.header.alt.is_video

course.header.alt.is_certifying

Got it!

Last updated on 9/1/22

Manipulate Rows and Columns

Manipulate rows and columns
Manipulate rows and columns

In this second part of the course, we’re going to get into the nitty-gritty! Keep your Excel document open so you can follow along. ;)

Now that you understand how cells work, let’s have a look at how to handle whole rows and columns.

Let’s take a look at the most common actions.

Insert and Delete Rows and Columns

To create a new column or row, you need to select the column or row that comes after it, then open the context menu and choose Insert.

For example, let’s say you want to insert a new column between “First Name” (column B) and “Last Name” (column C). You'd like this column to be named “Middle Name.”

Select column C (as this is the column you want to shift over to insert a column to the left) by clicking on the column heading, which is the letter C in this case.

Then right-click to open the context menu:

Select column C and right-click
Select column C and right-click

In this context menu, you just need to select the action you want to perform. In this case, Insert.

You now have an empty column that will be inserted to the left of the “Last Name” column.

Hide Rows and Columns

You’re going to use exactly the same method for this:

  • Select the row (or column) that you want to hide by clicking on its header (the letter for a column or the number for a row).

  • Open the context menu.

  • Select Hide.

For example, in our file, maybe we don’t want the “Date of Birth” and “Seniority” columns to be visible, but you don’t want to delete them. In this case, you would select their respective columns, D and E, and choose “Hide” in the context menu.

The result will look like this:

Select columns D and E and right click
Select columns D and E and right click
Columns D and E have been hidden
Columns D and E have been hidden

You can see that columns D and E (Date of Birth and Seniority) are no longer visible. But they haven't been deleted, it just skips from column C to F.

And if you want to make the hidden columns visible again:

  • Select columns C to F (i.e., include the columns either side of the hidden columns).

  • Open the context menu.

  • Select Unhide.

Columns D and E will then reappear.

Adjust Row and Column Sizes

You’ve probably noticed that when you enter data into a cell, some information overflows into the next cell.

For example, in our file, Sandra’s seniority is quite long:

The seniority is too long and spills over into the next column
The seniority is too long and spills over into the next column

You can see that the seniority (cell E5) has overflowed because the column is too narrow. If you don’t make any changes, when you fill in cell F5, you won’t see the last part of the seniority:

The seniority isn't fully visible
The seniority isn't fully visible

If you want to avoid this, you can very easily change the size of the column. Or, more precisely, adjust it to fit the data that’s inside it.

To do this, double-click on the separator marker between this column and the one next to it (in this case, the separator between E and F). The size of column E has automatically adjusted to fit the contents. This is also known as AutoFit.

The width of the column has been automatically adjusted to fit what’s inside it
The width of the column has been automatically adjusted to fit what’s inside it

You can also change the width of the column by clicking and dragging the column separator to adjust it however you’d like.

Group Rows and Columns

You might have a ton of columns that make your workbook hard to read, but you still need to retain the information inside them. One way to handle this is to group these columns together.

To group the columns, select the ones you’d like to group together, then in the Data tab, click on the Group icon .

This is what you’ll see:

Columns E, F and G have been grouped.
Columns E, F and G have been grouped

To hide grouped columns:

  • Either click on the minus (-) sign to hide the columns (which you can then unhide using the plus (+) sign).

  • Or, click on the 1 (and 2 to unhide). 

It will then look like this:

The grouped columns have been hidden
The grouped columns have been hidden

Columns E, F and G are hidden (but not deleted) and you see a plus (+) sign above the rows to indicate that the columns are grouped.

If you don't need to group the columns anymore and you don’t want the (+) and (-) signs above the columns, you’d need to ungroup the columns.

To ungroup the columns, select the columns that are grouped together, then in the Data tab, click on the Ungroup icon .

Watch the Video Tutorial!

Watch a step-by-step recap of everything described in this chapter in the tutorial below:

Let’s Recap!

  • To insert a column, select the column heading to the right of where you want to insert it, then in the context menu, click on Insert.

  • To hide a column, select the column heading, then in the context menu, click on Hide.

  • To unhide a column, select the column headings either side of the hidden column, then in the context menu, click on Unhide.

  • To adjust the column width, double-click on the separator mark on the column heading.

  • To group columns, select the columns you’re interested in, then in the Data tab, click on the Group icon.

Now that you know how to handle rows and columns, let’s look at another feature in Excel: tabs.

Example of certificate of achievement
Example of certificate of achievement