Learning Objectives
Show
In this section, we will begin the development of the workbook shown in Figure 1.1 "Example of an Excel Worksheet with Embedded Chart". The skills covered in this section are typically used in the early stages of developing one or more worksheets in a workbook. Entering DataFollow-along file: Excel Objective 1.0 (This is a blank workbook that was named in the previous section. If you skipped the previous section, open a new workbook and save it with the file name “Excel Objective 1.0.”) We will begin building the workbook shown in Figure 1.1 "Example of an Excel Worksheet with Embedded Chart" by manually entering data into the worksheet. There are other ways in which you can bring data into an Excel worksheet, such as importing data from a website or a Microsoft Access database. However, we will demonstrate these other methods later. The following steps explain how the column headings in Row 2 are typed into the worksheet:
Integrity CheckData Entry It is very important to proofread your worksheet carefully, especially when you have entered numbers. Transposing numbers when entering data manually into a worksheet is a common error. For example, the number 563 could be transposed to 536. Such errors can seriously compromise the integrity of your workbook. Figure 1.18 "Completed Data Entry for Columns B, C, and D" shows how your worksheet should appear after entering the data. Check your numbers carefully to make sure they are accurately entered into the worksheet. Figure 1.18 Completed Data Entry for Columns B, C, and D Editing DataFollow-along file: Excel Objective 1.0 (Use file Excel Objective 1.01 if you are starting with this skill.) Data that has been entered in a cell can be changed by double clicking the cell location or using the Formula BarThe area just above the column letters on a worksheet. It can be used for entering data into cells as well as for editing data that already exists in cells.. You may have noticed that as you were typing data into a cell location, the data you typed appeared in the Formula Bar. The Formula Bar can be used for entering data into cells as well as for editing data that already exists in a cell. The following steps provide an example of entering and then editing data that has been entered into a cell location:
Mouseless CommandEditing Data in a Cell
Auto FillFollow-along file: Excel Objective 1.0 (Use file Excel Objective 1.02 if you are starting with this skill.) The Auto FillAn Excel feature used to complete data in either a quantitative or qualitative sequence. It can also be used to copy and paste data in a worksheet. feature is a valuable tool when manually entering data into a worksheet. This feature has many uses, but it is most beneficial when you are entering data in a defined sequence, such as the numbers 2, 4, 6, 8, and so on, or nonnumeric data such as the days of the week or months of the year. The following steps demonstrate how Auto Fill can be used to enter the months of the year in Column A:
Deleting Data and the Undo CommandFollow-along file: Excel Objective 1.0 (Use file Excel Objective 1.03 if you are starting with this skill.) There are several methods for removing data from a worksheet, a few of which are demonstrated here. With each method, you use the Undo command. This is a helpful command in the event you mistakenly remove data from your worksheet. The following steps demonstrate how you can delete data from a cell or range of cells:
Figure 1.24 Clear Command Drop-Down Menu Adjusting Columns and RowsFollow-along file: Excel Objective 1.0 (Use file Excel Objective 1.03 if you are starting with this skill.) In Figure 1.22 "Auto Fill Options Button", there are a few entries that appear cut off. For example, the last letter of the word September cannot be seen in cell A11. This is because the column is too narrow for this word. The columns and rows on an Excel worksheet can be adjusted to accommodate the data that is being entered into a cell. The following steps explain how to adjust the column widths and row heights in a worksheet:
Mouseless CommandRow Height
Figure 1.29 "Excel Objective 1.0 with Column A and Row 15 Adjusted" shows the appearance of the worksheet after Column A and Row 15 are adjusted. Figure 1.29 Excel Objective 1.0 with Column A and Row 15 Adjusted Skill Refresher: Adjusting Columns and Rows
Hiding Columns and RowsFollow-along file: Excel Objective 1.0 (Use file Excel Objective 1.04 if you are starting with this skill.) In addition to adjusting the columns and rows on a worksheet, you can also hide columns and rows. This is a useful technique for enhancing the visual appearance of a worksheet that contains data that is not necessary to display. These features will be demonstrated using the Excel Objective 1.0 workbook. However, there is no need to have hidden columns or rows for this worksheet. The use of these skills here will be for demonstration purposes only.
Mouseless CommandUnhiding Rows
Integrity CheckHidden Rows and Columns In most careers, it is common for professionals to use Excel workbooks that have been designed by a coworker. Before you use a workbook developed by someone else, always check for hidden rows and columns. You can quickly see whether a row or column is hidden if a row number or column letter is missing. Skill Refresher: Hiding Columns and Rows
Skill Refresher: Unhiding Columns and Rows
Inserting Columns and RowsFollow-along file: Excel Objective 1.0 (Use file Excel Objective 1.04 if you are starting with this skill.) Using Excel workbooks that have been created by others is a very efficient way to work because it eliminates the need to create data worksheets from scratch. However, you may find that to accomplish your goals, you need to add additional columns or rows of data. In this case, you can insert blank columns or rows into a worksheet. The following steps demonstrate how to do this:
Mouseless CommandInserting Rows
Skill Refresher: Inserting Columns and Rows
Moving DataFollow-along file: Excel Objective 1.0 (Use file Excel Objective 1.05 if you skipped the previous skill and are starting with this skill.) Once data are entered into a worksheet, you have the ability to move it to different locations. The following steps demonstrate how to move data to different locations on a worksheet:
Integrity CheckMoving Data Before moving data on a worksheet, make sure you identify all the components that belong with the series you are moving. For example, if you are moving a column of data, make sure the column heading is included. Also, make sure all values are highlighted in the column before moving it. Deleting Columns and RowsFollow-along file: Excel Objective 1.0 (Use file Excel Objective 1.05 if you are starting with this skill.) You may need to delete entire columns or rows of data from a worksheet. This need may arise if you need to remove either blank columns or rows from a worksheet or columns and rows that contain data. The methods for removing cell contents were covered earlier and can be used to delete unwanted data. However, if you do not want a blank row or column in your workbook, you can delete it using the following steps:
Mouseless CommandDeleting Columns
Skill Refresher: Deleting Columns and Rows
Key Takeaways
Exercises
What steps will show hidden rows or columns quizlet?Select the columns and rows on both sides of the hidden columns or rows.. Under Home tab, click Format in the Cells group.. Select Unhide Columns or Unhide Rows.. How can you tell if a row or column is hidden in Excel?Locate hidden cells. Select the worksheet containing the hidden rows and columns that you need to locate, then access the Special feature with one of the following ways: Press F5 > Special. Press Ctrl+G > Special. ... . Under Select, click Visible cells only, and then click OK.. Which indicator appears when a column or row is hidden?Note: The double line between two columns is an indicator that you've hidden a column.
What is true about hidden columns?Once a column is hidden, it will not be shown on the display or printed when you print the worksheet. The column is not deleted; its width is simply reduced to 0.
|