|Adding a Calculator to the Quick Access Toolbar
Summary: There are many times in Excel when you want to do a quick calculation without using a formula or function. Here's how to use Excel's built-in calculator:
The Excel calculator is one of the many commands that you can add to the Quick Access Toolbar. To put the calculator on your Quick Access Toolbar you do the following:
- Click on the File tab and Select Options.
- Click on Quick Access Toolbar.
- In the "Choose Commands From" drop down box select "Commands not in the Ribbon".
- Click on the "Calculator" icon.
- Click Add and Excel will add the Calculator at the right end of the Quick Access Toolbar.
- Click OK.
Now click on the Calculator icon and it will appear. You use the calculator as you would any electronic calculator. Click on a number, choose an operation such as the plus key to do addition and then click on another number. Press the equal sign key to get the result.
Summary: There are times when you need to add a comment to a cell to provide additional information about the contents of the cell. Here's how:
A comment is a descriptive text that enables you to document your work when you add text or create a formula. You can enter a comment in any cell. Here are the steps:
- Click in the cell to which you want to add a comment.
- Click on the Review tab in the ribbon.
- Click on New Comment in the Comments group and a comment box will appear with a tiny red triangle in the upper-right corner of the cell.
- Type your comment. You can format the text as you would normally format a cell.
- Click outside the comment box when you have finished and the comment box will disappear.
- Move your cursor over the cell to see the comment again.
- Click Edit Comment in the Comments group to edit a comment.
- Click delete in the Comments group to delete a comment.
- To display all the comments in the worksheet click Show All Comments in the Comments group.
- To close the comments boxes, click Show All Comments again
- To cycle through your comments click Previous or Next in the comments group .
Summary: There are times when it is useful to print the row numbers for your worksheet. There is a setting in Excel that enables you to print the row numbers and the column letters. However, there is not a setting to just print the row numbers:
There is however, a way to get the row numbers to print. You need to add a new column A (insert a blank column to the left of the existing column A) and then use this formula in each cell of the column:
The formula returns the row number of the formula's row and it will print.
Highlighting Information Using Shading
Summary: There are times when you would like to highlight a paragraph in your document. Here is how to do this:
You can do this with Word's shading tool. To add shading to a paragraph involves the following steps:
- Click and place your insertion point in the paragraph that you want to shade.
- Click on the Home tab of the ribbon.
- In the Paragraph group, click on the down-arrow to the right of the Shading tool. (This tool looks like a tilted paint bucket, spilling paint to the right.) Word then displays a shading palette.
- Hover over a color and your paragraph will be shaded with that color.
- When you find a color that you like, click on the color and your paragraph will be shaded.