Spreadsheets: Add/ Delete Rows & Cells

100 %
0 %
Information about Spreadsheets: Add/ Delete Rows & Cells
Education

Published on November 3, 2008

Author: MoreThanMaths

Source: slideshare.net

Description

Step by step guide to adding cells/rows/columns to a spreadsheet and deleting them.

All screenshots and instructions are based on Microsoft Excel, because that's what we use with at my school.

Learn how to: Add new rows and columns to a spreadsheet Remove rows and columns from a spreadsheet Add some cells to a spreadsheet

Add new rows and columns to a spreadsheet

Remove rows and columns from a spreadsheet

Add some cells to a spreadsheet

Adding a New Row First I’ll show you how to add a new row to a spreadsheet This is very useful if you want to add an extra row to the middle of a table that you’ve already made

First I’ll show you how to add a new row to a spreadsheet

This is very useful if you want to add an extra row to the middle of a table that you’ve already made

Adding a New Row: 1. Select a row by clicking on the number heading

Adding a New Row: 2. Go to the menu and choose Insert, then Row. You can also do this by right clicking your mouse and choosing Insert.

Adding a New Row: That’s it - an extra row will appear.

Adding a New Column Now I’ll show you how to add a new column to a spreadsheet This is also useful if you want to add something to a table It is very similar to adding an extra row – can you work out what we will do differently?

Now I’ll show you how to add a new column to a spreadsheet

This is also useful if you want to add something to a table

It is very similar to adding an extra row – can you work out what we will do differently?

Adding a New Column: 1. Select a column by clicking on the letter heading

Adding a New Column: 2. Go to the menu and choose Insert, then Column. You can also do this by right clicking your mouse and choosing Insert.

Adding a New Column: That’s it - an extra column will appear.

Deleting a Row or Column Sometimes you want to get rid of a whole row or column from your spreadsheet This section will show you how to do this

Sometimes you want to get rid of a whole row or column from your spreadsheet

This section will show you how to do this

Deleting a Row or Column: 1. Select the row or column that you want to delete by clicking on the heading

Deleting a Row or Column: 2. Go to the menu and choose Edit, then Delete. You can also do this by right clicking your mouse and choosing Delete.

Deleting a Row or Column: That’s it – the row or column will disappear.

Adding just a few cells Sometimes you might need to add just a few extra cells If you have several tables on one sheet this is a good way of adding a line of cells to one table, without messing up all the others.

Sometimes you might need to add just a few extra cells

If you have several tables on one sheet this is a good way of adding a line of cells to one table, without messing up all the others.

Adding just a few cells: 1. Select where you would like to add the cells

Adding just a few cells: 2. Go to the menu and choose Insert, then Cells. You can also do this by right clicking your mouse and choosing Insert.

Adding just a few cells: Now you will see this dialogue box. Choose the correct option. This will depend on where you want to put the new cells. That’s it!

Summary: To add a row, first select a row, then choose Insert -> Row To delete a column, first select the column, then choose Edit -> Delete To add a few cells, first select some cells, then choose Insert -> Cells

To add a row, first select a row, then choose Insert -> Row

To delete a column, first select the column, then choose Edit -> Delete

To add a few cells, first select some cells, then choose Insert -> Cells

Add a comment

Related presentations

Related pages

Insert or delete cells, rows, and columns - Excel

You can add columns, rows, or cells to an Excel 2007 worksheet or delete them. ... Insert or delete cells, rows, ... Delete cells, rows, ...
Read more

Add and delete rows or columns - Docs editors Help

To add a row or column to a spreadsheet, ... Add and delete rows or columns. ... rows, and columns. Add and delete rows or columns;
Read more

Add or remove table rows and columns in an Excel table - Excel

Add or remove table rows and columns in an Excel table. ... you can easily add table rows and columns. ... see Insert or delete cells, rows, ...
Read more

Google Sheets: Modifying Columns, Rows, and Cells

Google Sheets—previously known as Google Spreadsheets—is a free ... delete certain rows or ... this will add 20 new rows to your spreadsheet, ...
Read more

Add and Delete Rows and Columns in Excel Using Shortcut Keys

How to quickly add and delete rows and ... Add Rows; Delete ... To Delete Three Rows from a Worksheet. Click on a cell in a row at the bottom ...
Read more

Remove Blank Rows - Google Sheets add-on

Delete or hide them with 1 click ... Remove Blank Rows (141) offered ... Choose between "All rows must be blank" or "Only rows within the range" (ignores ...
Read more

Google Sheets: Spreadsheet basics - Google Docs

Instead of creating multiple spreadsheets, you can add sheets to ... and edit Google Docs, ... If you select multiple cells, you can delete multiple rows ...
Read more

Excel COM Add-in in C# delete columns/rows re-calcuate all ...

Excel COM Add-in in C# delete columns/rows re ... deletes columns/rows, ... opening the spreadsheet then deleting rows below the cell ...
Read more

How to: Delete text from a cell in a spreadsheet document ...

... a specific cell in a spreadsheet ... // deletes the text from the cell at the specified ... } IEnumerable cells = rows ...
Read more