Microsoft Excel 2010 Level III Excel is a spreadsheet program used to enter, manipulate, compute, graph, analyze, and store numeric data. Its uses, include managing budgets, grade books, and maintain simple address lists.
Handout Objectives: 1. Comments a) b) c) d) e)
Insert Show Hide Edit Delete
2. Data Tab: a) Remove Duplicates 3. Home tab: a) Draw Cells 4. Excel Templates: a) Types of Pre-Created Templates
LaGuardia Community College 31-10 Thomson Ave, Long Island City, New York 11101 Created by ISMD’s Dept. Training Team.
1. Comments a. How to add comments to a cell in Excel 2013 The first thing you’ll need to do is click on the cell where you want to insert the comment. In Excel 2013, comments can be added to a worksheet by going to the Review tab from the Ribbon.
In the Comments group, click on New Comment. In the Excel spreadsheet a comment text box will appear simply type in your new comment. (Notice that the Comment will include the Computer Name – This is a hint to show the user where the comment was created.)
2|Page
Type in your comment and click outside of the text box when you are done. You’ll notice that there is a small red arrow at the top right of the cell, indicating that this cell has a comment. Clicking on the cell automatically brings up the comment.
Add Comments Using the Context Menu Simply right click on the cell that you want to insert the comment into. Then click on Insert Comment. This step will follow the same process as before.
3|Page
b. Show Comment The comment is represented by the red arrow on the upper right corner – it will be displayed once the mouse is hovered over that cell.
To have the comment appear and stay on the screen and stay there – right click on the cell and select Show/Hide Comments your comment will now stay visible at all times.
As you can see the selected cell is A6 and the comment is still present on the screen for A2
4|Page
c. Hide Comment Simply right click on the cell with the comment and select Hide Comment, the comments will now be hidden once again.
As you can see the selected cell is A4 and the comment is represented on the screen for A2 as a red arrow.
5|Page
d. Edit Comment Simply right click on the cell with the comment and select Edit Comment this will reopen the comment which now can be easily modified.
The cursor is now back in the comment where the user can make the necessary changes
e. Delete Comment Simply right click on the cell with the comment and select Delete Comment this will completely remove the comment from the spreadsheet
The comment is now gone (You will notice that the context menu will change based on what is visible on the screen)
6|Page
2. Remove duplicate values When you remove duplicate values, only the values in the range of cells or table are affected. Any other values outside the range of cells or table are not altered or moved. CAUTION Because you are permanently deleting data, it's a good idea to copy the original range of cells or table to another worksheet or workbook before removing duplicate values. 1. Select the range of cells, or make sure that the active cell is in a table.
2. On the Data tab, in the Data Tools group, click Remove Duplicates.
7|Page
3. Do one or more of the following:
Under Columns, select one or more columns.
To quickly select all columns, click Select All.
To quickly clear all columns, click Unselect All. If the range of cells or table contains many columns and you want to only select a few columns, you may find it easier to click Unselect All, and then under Columns, select those columns.
Note: Make sure to verify the My data has headers check box is checked.
Click OK. A message is displayed indicating how many duplicate values were removed and how many unique values remain, or if no duplicate values were removed.
8|Page
4. Click OK – Observe the List of names, the duplicates have been removed.
3. Draw cell borders 1. To display the Borders toolbar, click the arrow next to Borders toolbar, and then click Draw Borders
on the Formatting
.
2. On the Borders toolbar, choose a style and line color for your borders.
Click the arrow next to Line Style
and then click the style that you want to
use.
Click Line Color
and then click the color that you want to use.
3. On the Borders toolbar, click the arrow next to Draw Border
to choose which drawing
tool to use.
To draw borders around only the outside of a selection of cells, click Draw Border . The mouse pointer will turn into a draw border tool
.
To draw individual borders around every cell that you select, click Draw Border Grid . The mouse pointer will turn into a draw border grid tool
.
9|Page
4. Tip You can use either tool to draw a border on just one side of a cell. Instead of dragging the tool across a cell, simply click the edge where you want the line to appear. Notes If a cell contains rotated text, the border will appear rotated to the same degree as the text. Holding the CTRL key temporarily switches between the draw border mode and draw border grid mode.
Erase cell borders 1. To display the Borders toolbar, click the arrow next to Borders toolbar, and then click Draw Borders
on the Formatting
.
2. On the Borders toolbar, click Erase Border The mouse pointer will turn into an eraser tool
. .
3. To remove borders, do one of the following:
To remove a single border, click that border with the eraser tool
To remove more than one border, drag the eraser tool
.
across the borders that you
want to remove. 4. To stop erasing borders, click Erase Border on the Borders toolbar again, so that the eraser tool is no longer displayed. Note Holding the CTRL key temporarily switches between the Erase Border mode and Erase Border Grid mode.
10 | P a g e
5. Pre-Created Templates The templates that Office 13 has to offer can be found by going to the File Menu then elect New to view a selection of templates
11 | P a g e
Click on the template of your choice this will bring up a preview screen, with the Download Size and User Ratings.
Click Create.
A new file will open sporting the template you’ve selected, modify as you please and save with desired name.
12 | P a g e
