nsalocal.blogg.se - How to edit on excel

Type the number 9.99 and press the ENTER key.

Using the ENTER key is an efficient way to enter data vertically down a column. After you press the ENTER key, cell B4 will be activated.

Type the number 2670 and press the ENTER key.

Good column headings reduce the chance of someone misinterpreting the data contained in a worksheet, which could lead to costly errors depending on your career. In professional environments, you will likely be sharing Excel workbooks with coworkers. It is critical to include column headings that accurately describe the data in each column of a worksheet. We will examine formatting techniques to correct this problem in the next section. This is because the column is too narrow to fit the entry you typed. Notice that the word Price in cell location C2 is not visible.

Repeat step 4 for the words Average Price and then again for Sales Dollars.įigure 1.15 shows how your worksheet should appear after you have typed the column headings into Row 2.

Type Unit Sales and press the RIGHT ARROW key.

This will enter the word into cell A2 and activate the next cell to the right.

Click cell location A2 on the worksheet.

The following steps explain how the column headings in Row 2 are typed into the worksheet: You will begin building the workbook shown in Figure 1.1 by manually entering data into the worksheet. The skills covered in this section are typically used in the early stages of developing one or more worksheets in a workbook. In this section, we will begin the development of the workbook shown in Figure 1.1.

Learn how to move data to different locations in a worksheet.

Understand how to delete columns and rows from a worksheet.

Examine how to insert columns and rows into a worksheet.

Understand how to hide columns and rows in a worksheet.

Examine how to adjust column widths and row heights in a worksheet.

Understand how to delete data from a worksheet and use the Undo command.

Examine how Auto Fill is used when entering data.

Examine how to edit data in a worksheet.

Understand how to enter data into a worksheet.