Platform Banner

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
4611 views

Available in Microsoft365

Description

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.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

Vu 2907 fois

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 introductory Excel tutorials combine simplicity and efficiency!

ALL COURSES