|Quickly Calculating the Average of a Range of Cells
Summary: Quickly calculating the Average of a range of cells. Here is how to do this:
To quickly calculate the average of a range of cells follow these steps.
- Select all the data in the range of cells.
- Include a blank row below the table.
- Go the Home Tab and click on the drop-down arrow beside the AutoSum button.
- Select Average from the list.
Excel will calculate the Averages for each column of data and place the value at the bottom of the table.
Applying One Column Width to Other Columns in a Workbook
Back to top
Summary: There are times when you want take the width of one column in a workbook and change other columns to that width. Here is how to do this:
- Select the column with the correct width.
- Press Ctrl+C to copy.
- Select the columns you want to apply that width to.
- Go the Home tab and click in the Clipboard group on Paste, Paste Special, Columns Widths.
The columns you selected will now have the same width as your first column.
Changing the Orientation of Text in a Cell
Back to top
Summary: There are times when you want to change the orientation of text in a cell. Here is how to do this.
- Select the cells whose orientation you want to change.
- Display the Format Cells dialogue box. In the Home tab of the Ribbon click on the small icon at the lower right hand corner of the Number group.
- Click on the Alignment tab.
- Use the Orientation section to specify the angle (in degrees) to which the text should be turned. You can set any value between 90 degrees and -90 degrees.
- Click on OK. The text will be turned as you directed.
- Format your columns to suit the new width of your aligned data.
Setting Line Spacing
Summary: Line spacing is the amount of space between lines of text and paragraphs. There are times when you may want to double space your text. Here is how to do this:
- Select the text you want to edit.
- Click on the Home tab in the Ribbon.
- Click Line and Paragraph spacing.
- Select the spacing you want for this section of text.
- Word will then apply the spacing to the text.
Summary: Getting rid of your deleted e-mail automatically is a time saver. Here is how to do this::
When you delete e-mail in Outlook you are moving it to your Deleted Folder, not to the Recycle Bin on your desktop. Disk space is used for this deleted e-mail and your system runs slower. The solution to this is to have Outlook automatically delete your trashed e-mails when Outlook is closed. Here is the setting to do this:
- Open Outlook 2010.
- Click on the File menu and select File | Options.
- In the Outlook Options window, select Advanced.
- Go to the the Outlook Start and Exit area in the Advanced list.
- Click on the Check box for Empty Deleted Items Folder when Exiting Outlook.
- Click OK.
Now Outlook will empty the Delete Folder every time you exit Outlook.
Using Multiple Monitors
Summary: It is often useful to have your audience view your presentation on one screen while you view it on another screen. Your view is called the Presenter View. Here is how to do this:
When you use the Presenter View, you can see different views of your presentation without the audience being able to see your screen. Very useful if you are using notes in your presentation.
The first step in making this happen is to Extend Your Desktop.
- Press the Right Mouse on your desktop and select Personalize.
- Select Display Settings from the list.
- Select 2 for the second monitor.
- Check the Extend the Desktop on to this monitor check box.
- Set the resolution and colors, as appropriate for your second monitor.
- Click OK.
The next step is to Enable the Presenter View.
- Click on the Slide Show tab to display the Monitors group.
- Set the resolution or leave as Use Current Resolution.
- Select the monitor to Show Presentation on.
- Check the Show Presenter View box.
- Start the slide show.