This chapter covers how to manage cells, rows, and columns.
Use this workbook for the chapter.
Note: This is the same workbook used in the Navigation Shortcuts chapter.
To delete data in a cell, use the following steps:
Sometimes, you need to delete cells themselves, and not just the contents in them. Selecting a cell and pressing the Delete key or Backspace key will delete the content in cells, but the cells themselves remain. To delete cells, use the following steps:
Other options in this dialogue box include Shift Cells Up, which will shift the other cells in the column up; Entire Row, which will delete the entire row the selected cells are found in; and Entire Column, which will delete the entire column the selected cells are found in. Be careful when deleting cells of data, because it can make your data mismatched, and it will leave an empty space at the end of the data.
There is a quicker way to delete entire rows and columns without having to bring up the dialog box. To delete an entire column more quickly, use the following steps:
To delete an entire row more quickly, use the following steps:
You can also insert new cells as well as delete them. To insert a new cell into a worksheet, use the following steps:
To insert an entirely new column, use the following steps:
To make a new column more quickly, use the following steps:
To add a new row, use the following steps:
If a column is too small or too big, you can change the width of the column to fit your needs. To change the width of a column, use the following steps:
Another way to change the width of a column is to hover your cursor over the line that divides the column at the top, and then click and drag the column divider left or right to make it bigger or smaller. A dotted line will appear as a guide that can help show the new width of the cell before you release it. A box will pop up, showing the new measurement of the width as you move it to the left or right. (See Figure 10.12)
In general, it is best to make the columns wide enough so you can see everything in the column. A quick way to fix the width of a column to the correct size without having to guess how wide it should be is to double-click the letter at the top of the column. Excel will auto-fit the column so that it can show all of the information within the cells in that column. Excel will check every cell in the column. Even if you have a long bit of information off the view of that page, when you auto-fit that column, it will take that into account. You can do the same thing with rows, by dragging to change its height or right-clicking and choosing Row Height. (See Figure 10.13)
Next, we’ll look at commenting in a cell. A comment is something that can help a user to better understand what a cell means, or it can help you to remember what you’ve done in that cell. To add a comment to the price column, use the following steps:
Every time you hover over a box that has a note attached to it, you will be able to see the note. (See Figure 10.15)
You can also mention another user of the document using comments. To do this to the cell that contains Order Qty, use the following steps:
When the comment is saved, the person who was mentioned in the comment will get a notification in their account inbox. As people reply to the comments, a chain of messages will appear with the original comment when the user hovers over the cell.
To delete a comment or note, use the following steps:
To edit a comment or note, use the following steps:
You can also use this options bar to reply to a comment or delete a comment. If you are the comment author, there will also be an Edit button on the comment when you hover over the cell with the comment. (See Figure 10.19)
Sometimes when someone shares a new workbook with you, you might want to see all of the comments or notes that have been put onto the workbook. To see all the comments on the worksheet, use the following steps:
To see all of the notes on a worksheet, use the following steps:
These are two different options to share information within a given worksheet to help either yourself or someone using it understand what’s going on.
This content is provided to you freely by BYU-I Books.
Access it online or download it at https://books.byui.edu/bus_115_business_app/managing_cells.