Skip to main content
Aliexpress WW
Aliexpress WW

The Advanced Guide to Entering And Editing Data In Excel 2000


Entering data

You can enter three types of data in a worksheet: text, numbers, and formulas. Text is any entry that is not a number or formula. Numbers are values that are used when making calculations. Formulas are calculations.

To enter data into a cell:

  • Click the cell.
  • Begin typing the data.
  • An insertion point appears, and the text you are entering appears in the active cell and in the Formula bar.
Formula Bar
  • The Formula bar buttons—Cancel and Enter—appear.
  • Clicking the Enter button Enter button ends the entry and turns off the Formula bar buttons.
Enter Text

To delete data:

  • Click the cell.
AND
  • Click the Cancel button Cancel Button to delete an entry and turn off the Formula bar buttons.
OR
  • Cancel an entry by pressing the Escape key.
OR
  • Right-click and choose Clear Contents from the shortcut menu.
OR
  • Select data and press Delete or Enter.
Important pointExcel’s AutoComplete feature keeps track of text entered in a column and can complete other entries in the same column. For example, if you typed GCFLearnFree.org in cell A1 and enter G in A2, Excel automatically fills the cell with GCFLearnFree.org. If GCF Global Learning is the text you want to enter, press Enter or Tab to move to the next cell. If it’s not what you want, just keep typing until you overwrite the AutoComplete feature.

Editing data

You may find that you need to edit or change data you enter into a cell. You can do this two ways.

To use the quick and easy method:

  • Click the cell and type the new entry; the old entry is replaced.
If the original entry is long and only requires a minor adjustment (in spelling, for example), edit the entry.

To edit:

  • Click the cell and edit the entry in the Formula bar.
OR
  • Double-click the cell. This opens the cell for direct editing.
  • Press Enter or click the Enter buttonon the Formula bar Enter Button to complete the entry.
Enter Text

Selecting multiple cells

In Excel, the cell that is currently selected is the active cell. A group of cells is called a range.

To select a range of cells:

  • Move to the first cell in the range.
  • The mouse pointer becomes a large cross. Large Cross
  • Hold down the left mouse button and drag to the last cell you want to select.
  • Release the mouse button.
  • The cells you selected are shaded.

To select all cells in a column or row:

  • Click the Column or Row heading.

To select multiple columns or rows:

  • Click one heading and drag to select the others.
Column Selected
Row Selected

To select the entire worksheet:

  • Click the gray rectangle in the upper-left corner to select entire worksheet.
Select All Button
Important pointIf the cells and columns you want to select are not directly next to each other, select one of the ranges you want to select and hold down the Control key while selecting other ranges. For example, you may want to select column A and column C, but not column B.

Challenge!

Practice selecting a range of cells using one of the methods taught in this lesson:
  • Click a cell and drag to select a number of cells.
  • Click a column or row heading.
  • To select an entire worksheet, click the gray rectangle in the upper-left corner.
Labels:

Comments

Post a Comment

Popular posts from this blog

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...
Post a Comment
Read more

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...
Post a Comment
Read more

Layout And Composition In Graphic Design: It's Not as Difficult as You Think

What is composition? In many ways, layout and composition are the  building blocks  of design. They give your work structure and make it easier to navigate, from the margins on the sides to the content in between. Why is composition so important? In short, it's the  way your content is arranged . It doesn't matter if you're working with text, images, or elements in a graphic; without a thoughtful, well-composed layout, your work would basically fall apart. Five basic principles The key to mastering layout and composition is to  think like a designer . Luckily, it's easier than it sounds. There are  five basic principles  that can help you transform your work and sharpen your eye for design. Keep them in mind during your next project, and look for ways to apply them. Proximity Proximity is all about using  visual space  to show  relationships  in your content. In practice, it's pretty simple—all you have to do is make su...
Post a Comment
Read more