Summary: It is easy to Hide and Unhide columns in Excel. The exception is when you hide Column A. If you later want to unhide column A the solution can be challenging. Here is how to do this:
- Press the F5 function key.
- Excel displays the Go To dialog box.
- In the Reference field at the bottom of the dialog box, enter A1.
- Click on OK.
- Cell A1 is now selected, even though it is not visible on the screen.
- Select the Home tab on the ribbon.
- Select Hide and Unhide.
- Select Unhide Columns.
Column A will now be visible.
Filtering for Unique Items
Summary: There are times when you want to copy a list of unique items to another column. This involves using filters in Excel.
Here are the steps to filter a data set for unique items.
- Select the data to be filtered.
- Go to the Data tab.
- Click on Advanced in the Sort and Filter group.
- Select Copy to another location.
- Select Unique Records.
- In the Copy To box enter the cell location where you want Excel to place the Unique Records.
- Click on OK.
You will now have a list of the unique items in the original data set.
|
Back to top
Deleting Duplicates from a Data Set
Summary: It is very easy to delete duplicate values from a data set. Here is how to do this:
- Select a cell in the data set.
- Go to the Data Tab.
- Click on the Remove Duplicates in the Data Tools group.
- Excel will highlight the data set. If there are columns missing in the selection, go back and make sure there are no blank columns in the selection.
- Make sure that My Data has Headers is selected if your data set has headers.
- By default, all the columns are selected. A selected column means that the tool will use all the columns to check for duplicates. Duplicates in an unselected column will be ignored. Select the columns that you want to match for duplicates.
- Click OK. The data set will update, deleting any duplicate rows. A message will appear to tell you how many rows were deleted and how many rows remain in the data set.
Note there is no undo for this process. Save your work before you run this process.
|
Inserting Captions
Summary: You can add captions to screen shots, pictures, charts, text boxes and other graphic objects. Here is how to do this:
Word's captioning features include preset captions for Figures, Equations, or Tables. Word also handles the caption numbering for you, such as Figure 1, Figure 2, etc.Here's how to add a caption:
- Right-click on the figure that you want to add a caption for.
- Click Insert Caption.
- The Caption dialog box will open.
- Click on the Label drop-down arrow.
- Select a Caption label.
- At this point you change the location of the caption below the figure.
- Click OK and Word will insert the Caption.
|