Excel - Insert columns and rows Tutorial

In this video, you will learn how to insert columns and rows in Microsoft Excel.
The video covers the steps to add columns and rows to a table, adjust column widths, enter data, format cells, and perform actions like copying, cutting, pasting, and moving columns or rows.
This tutorial will help you become proficient in managing and organizing data in Excel.

4:16
4411 views

Available in Microsoft365

Objectifs :

This video aims to teach users how to effectively expand and format a worksheet in Excel, including adding columns and rows, adjusting widths, formatting data, and utilizing formulas for better data management.

Chapitres :

Expanding the Worksheet
As your project grows and changes, you can expand your worksheet by adding more columns to the table. To do this, click in the column next to the table and start typing, then press Enter. Additionally, you can add a column for 'Contact' by pressing Tab to move to the right instead of Enter. You can also add columns for 'Bid Deadline' and 'Actual Cost'.
Adjusting Column Widths
To ensure all headings are visible, adjust the column widths by double-clicking the boundary between the columns. This will automatically resize the columns to fit the content.
Adding Rows to the Table
To add more rows, simply drag the little green handle located in the lower right corner of the table and type your data. This allows for easy expansion of the table.
Entering and Formatting Data
Once new columns are added, you can enter data as it becomes available. For the 'Bid' column, select it and format it as currency. To calculate totals, click on the Total row, select the arrow next to the cell, and choose 'SUM'.
Creating a Title for the Worksheet
To give your worksheet a title, you can name it 'Store Expansion'. Format the title text using the mini toolbar to increase the size and change the color. Alternatively, use the ribbon to apply a cell style for a quicker formatting option.
Editing Cells
If you need to change a cell's content, double-click the cell to edit or use the formula bar. This allows you to modify specific parts of the cell without retyping everything.
Inserting and Deleting Columns and Rows
To add a column in the middle of the table, click a table header, go to the Home tab, and use the Insert option. To delete a column, select the header, click Delete, and choose 'Delete table columns'. The same process applies to rows.
Copying, Cutting, and Pasting Data
Copying, cutting, and pasting data in Excel works similarly to other programs. Select the data, go to the clipboard group on the Home tab, and click the command. Then, click where you want to paste the data and select 'Paste'.
Moving Columns and Rows
To move a column or row, first select the table header. Position the mouse over the bottom border of the header until a four-headed cursor appears. Click and drag to the desired location, then release the mouse button. This method is also applicable for moving rows.
Utilizing Formulas
To enhance the functionality of your worksheet, you can use formulas to perform calculations on your data. This will help in making your worksheet more useful and efficient.

FAQ :

How do I add a new column in my spreadsheet?

To add a new column, click in the column next to the table and start typing, then press Enter. Alternatively, you can select a table header, go to the Home tab, and use the Insert option.

What is the purpose of the SUM function?

The SUM function is used to add together a range of numbers in a spreadsheet. It helps in calculating totals quickly and efficiently.

How can I format a cell as currency?

To format a cell as currency, select the cell, then go to the Home tab and choose the currency format from the Number formatting options.

Can I change the width of a column automatically?

Yes, you can change the width of a column automatically by double-clicking the right border of the column header.

What is the difference between copying and cutting data?

Copying data creates a duplicate of the selected data in the clipboard, while cutting data removes it from the original location and places it in the clipboard for pasting elsewhere.

How do I delete a column in my spreadsheet?

To delete a column, select the column header, then right-click and choose Delete, or go to the Home tab and select Delete table columns.

What is the formula bar used for?

The formula bar is used to view and edit the contents of the currently selected cell, including entering formulas and functions.

How can I move a column or row in my spreadsheet?

To move a column or row, select the header, then click and drag it to the desired location. Release the mouse button to drop it in place.

Quelques cas d'usages :

Project Management

In project management, expanding a worksheet to include additional columns for contact information, bid deadlines, and actual costs can help track project progress and budget effectively.

Financial Reporting

Using the SUM function to calculate totals in financial reports allows for quick analysis of expenses and revenues, improving decision-making processes.

Data Analysis

Data analysts can utilize formatting options to enhance the readability of their spreadsheets, making it easier to present findings to stakeholders.

Inventory Management

In inventory management, adding columns for product details and costs can streamline tracking and help in making informed purchasing decisions.

Sales Tracking

Sales teams can use spreadsheets to track sales data, applying formulas to calculate totals and analyze performance over time, which can lead to improved sales strategies.

Glossaire :

worksheet

A worksheet is a single page in a spreadsheet program where data is organized in rows and columns. It is used for calculations, data analysis, and record-keeping.

column

A column is a vertical set of cells in a table or spreadsheet. Each column typically contains data of a specific type, such as names, dates, or numbers.

row

A row is a horizontal set of cells in a table or spreadsheet. Each row usually represents a single record or entry.

cell

A cell is the intersection of a row and a column in a spreadsheet. It is the basic unit where data is entered and stored.

formatting

Formatting refers to changing the appearance of text or numbers in a spreadsheet, such as font size, color, and style, to enhance readability and presentation.

SUM

SUM is a function in spreadsheet software that adds together a range of numbers. It is commonly used to calculate totals.

cell style

Cell style is a predefined set of formatting options that can be applied to a cell or range of cells to quickly change their appearance.

clipboard

The clipboard is a temporary storage area in a computer's memory where data is held when it is copied or cut, allowing it to be pasted elsewhere.

formula bar

The formula bar is a user interface element in spreadsheet software that displays the contents of the currently selected cell and allows users to enter or edit formulas.

drag and drop

Drag and drop is a common user interface action where a user selects an item, drags it to a new location, and releases it to move or copy the item.

00:00:07

Let's start by adding more columns to the table.

00:00:10

Click in the column next to the table and start typing, then press Enter.

00:00:16

Let's also add a column for Contact.

00:00:19

This time, instead of pressing Enter, press Tab to move to the right.

00:00:24

Then we can add Bid, Deadline and Actual cost columns.

00:00:31

Now let's change the column widths so that we can see all the headings.

00:00:35

This time, just double click to adjust the widths automatically.

00:00:42

What about adding more rows?

00:00:44

No problem! Here's another way to expand a table.

00:00:47

Just drag this little green handle in the lower right,

00:00:53

then type your data.

00:00:59

Now let's enter some data in the new columns.

00:01:01

We don't have everything yet, but we can enter what we do have.

00:01:06

Next, select the Bid column,

00:01:11

and format it as currency.

00:01:14

Then click the Total row,

00:01:16

click the arrow next to the cell, and select SUM.

00:01:25

How about a title? We'll call this worksheet Store Expansion.

00:01:30

Now we can format the text to look more like a title,

00:01:32

by using the mini toolbar to make it bold,

00:01:35

and increase the size, and change the color.

00:01:39

A faster way though, is to go to the ribbon and use

00:01:42

a cell style, because you can apply a number of formatting options with one click.

00:01:49

When you see one you like, click it.

00:01:52

Here are some things you should know when you want to update your data;

00:01:56

to change a cell completely, click it, and retype the data.

00:02:02

If you don't want to retype everything, double click the cell,

00:02:06

and then click to move the cursor to the parts you want to change.

00:02:11

You can also click in the formula bar to change the cell.

00:02:17

You saw how to add a column or row to the outside of the table.

00:02:21

But what if you want to add one to the middle?

00:02:23

Click a table header, then go to the Home tab

00:02:27

and click the arrow under Insert;

00:02:30

we can insert a row or column to the entire worksheet.

00:02:33

However, we only want to add a column in our table

00:02:36

to the left of our selection.

00:02:40

To delete the column: select the header,

00:02:42

then click Delete, and Delete table columns.

00:02:47

You can do the same thing with rows.

00:02:49

Select a cell in the row,

00:02:52

Insert a table row,

00:02:56

or Delete a table row.

00:03:01

What about copying, cutting and pasting?

00:03:03

Well it works the same in Excel as it does in other programs;

00:03:06

select the data you want to copy or cut,

00:03:10

go to the clipboard group on the Home tab, and click the command.

00:03:15

Then click where you want to paste the data, and click Paste.

00:03:23

Here's one less thing you might want to do: move a column or row.

00:03:26

It's a little tricky because you have to position

00:03:28

the cursor just right for it to work.

00:03:31

First select just the table header.

00:03:34

Now move the mouse slowly over the bottom border of the header,

00:03:37

until you see a four headed cursor.

00:03:40

Then click and drag it to the left.

00:03:44

You should see a thick I-beam cursor;

00:03:47

drag the cursor to the point where you want to move the column,

00:03:50

and then release the mouse button.

00:03:53

Of course, you can do the same thing with rows:

00:03:56

click when you see the arrow to select the table row;

00:03:59

move the mouse over a border until you see a four headed arrow,

00:04:03

and then drag the I-beam to the point where you want to move the row.

00:04:09

Up next, we'll make our worksheet even more useful by

00:04:12

putting our numbers to work for us with formulas.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

2795 Views

Video Training Microsoft Excel - Discovery level

Discover and familiarize yourself with Excel: from creating and using your tables to enhancing your visuals and collaboration. Our introduct...

ALL COURSES