Why You Should Spend More Time Thinking About Inserting And Deleting Rows And Columns

Introduction

By the end of this lesson, you should be able to:

Insert rows and columns
Delete rows and columns

Inserting columns

In Excel, you can insert a column anywhere you need it. Excel moves the existing columns to make room for the new one.

To insert a column:

Click anywhere in the column where you want to insert a new column.
Choose InsertColumns from the menu bar.
A new column is inserted to the left of the existing column.

Click anywhere in the column where you want to insert a new column.
Right-click and choose Insert from the shortcut menu. The Insert dialog box opens.
Click Entire Column in the Insertdialog box.
A new column is inserted to the left of the existing column.

To insert multiple columns:

Select more than one column.
Choose a method (menu or shortcut menu) to insert a new column.
The number of columns you originally selected are inserted into the spreadsheet.

Observe how the existing column C is moved to column D to make room for a new column (and new content).

Need to insert column into worksheet

Inserting rows

You can insert a row in a spreadsheet anywhere you need it. Excel moves the existing rows down to make room for the new one.

To insert a row:

Click anywhere in the row belowwhere you want to insert the new row.
Choose InsertRows from the menu bar.
A new row is inserted above the cell(s) you originally selected.

Click in the row below where you want to insert the new row. A cell in the row will be selected.
Right-click and choose Insert from the shortcut menu. The Insert dialog box opens.
Choose Entire Row, then click OK.
A new row is inserted above the cell(s) you originally selected.

To quickly insert a row or column, select the row or column heading. Right-click to open the shortcut menu and add a new row.

In the image below, see how the existing row 16 is moved to row 18 after a new row is inserted.

Need to insert rows

Deleting columns and rows

Deleting columns and rows is much like inserting columns and rows.

To delete columns and rows:

Select one or more columns or rows.
To clear the content but leave the emptied row in place, press Delete on your keyboard.

To delete the contents and remove the row or column, choose EditDelete from the menu bar.

Comments

The Ultimate Glossary of Terms About Typography In Graphic Design

What is typography? Typography is everywhere we look. It's in the books we read, on the websites we visit, even in everyday life—on street signs, bumper stickers, and product packaging. But what exactly is typography? Simply put, typography is the style or appearance of text . It can also refer to the art of working with text—something you probably do all the time if you create documents or other projects for work, school, or yourself. Common types of fonts Typography can be an intimidating subject, but it doesn't have to be. You only need to know a little to make a big difference in the stuff you do every day. So let's get started. First, some common types of fonts and what you need to know about them. Serif fonts Serif fonts have little strokes called serifs attached to the main part of the letter. Because of their classic look, they're a good choice for more traditional projects . They're also common in print publications, like magazines an...

The Advanced Guide to Colours In Graphic Design

The power of color Color plays a vital role in design and everyday life . It can draw your eye to an image. Sometimes it can trigger an emotional response. It can even communicate something important without using words at all. So how do we know which colors look good together and which ones don't? The answer is simple: Color theory . Artists and designers have followed color theory for centuries, but anyone can learn more about it. It can help you feel confident in many different situations, whether it's choosing colors for a design or putting together the perfect outfit . With a little insight, you'll be looking at color in a whole new way. Color basics Let's start at the beginning with a refresher on the basics. Remember learning about primary and secondary colors in school? Then you already have some knowledge of color theory. Secondary colors are created by combining two primary colors...

The Ultimate Cheat Sheet On Making Basic Adjustments In Image Editting

Introduction Image editing is all about adjusting your images to make them look better. We're going to talk about some of the most basic image adjustments , along with some common problems to watch out for when making these changes. The adjustments we'll cover in this lesson include: Cropping : If you want to remove parts of an image, you can crop it. You can think of cropping as using a pair of scissors to cut out the parts you no longer want. Resizing : If you want to make an image smaller or larger, you can resize it. However, keep in mind that making an image larger than its original size generally does not look good. Rotating : If you want to change the orientation of an image, you can rotate it to the left or right. Optional : If you'd like to follow along, you can download some or all of our example images . Just click any of the images below to open a full-sized version. Then right-click the full-si...

Tutorials Home

Search This Blog