 Changing a Page's Column Breaks
|
Summary: When you have a worksheet with a lot of columns it is helpful to able to define where the vertical page break occurs. Here is how to set the break:
- Select Page Break Preview from the View tab.
- Place your cursor over the blue column line you want to move until it becomes a double arrow.
- Hold down your left mouse button. The dashed blue line will become a solid blue line.
- Move the blue line to where you want the column break to be.
- Release the mouse button and the dashed blue line will become a solid blue line defining the column page break.
|
Inserting the Filename and Date into the Header
|
Summary: It is often useful to have the filename and date in the header of a workbook. Here is how to do this:
- Go to the View tab.
- Click on Page Layout.
- Move your mouse to the top of the worksheet where it says "Click to Add Header".
- Click on the left header field.
- Go to Header & Footer, Tools Design and select the File Name. The code for this is &[File] and it will be placed in the header.
- Click on the right header field.
- Go to Header & Footer, Tools Design and select Current Date. The code for this is &[Date] and it will be placed in the header.
- Click anywhere in the worksheet to leave the header.
- The codes will update and show the actual file name and date.
|
Back to top
Sorting by Color Using the Sort Dialog
Summary: Sorting by values is the usual type of sorting you do in Excel. However, Excel 2007 and Excel 2010 let you sort by font color, fill color or
icon set. Here is how to sort by color.
- Make sure that your data doesn't have any blank rows or columns.
- Select a cell in the data set. Excel will use this cell to define the boundaries of your data set.
- Right click on the cell and select Sort, Custom Sort.
- Be sure that the My Data Has Headers, check box in the upper right hand corner is selected.
- Be sure that all the data columns are selected. If they are not all selected, a blank column exists, and that confuses Excel as to the size of your data.
- From the Sort By drop down, select the first column header to sort by.
- From the Sort By drop down, select Cell Color.
- From the first Order drop down, select the color by which the column's data should be sorted.
- From the second Order drop down, select whether the color should be sorted to the top or bottom of the data. If you select multiple colors to sort at the top of the data, the colors will still appear in the order chosen.
- If you want to sort the data again by another column, click on Add a Level and repeat steps 6 though 9. Repeat these steps until all the columns you want to sort by are configured.
- If you get the order wrong, use the Up or Down arrows to move it to the right location.
- Click OK to sort the data.
Back to top |
| Word Keyboard Shortcuts
Summary: For those of you who are keyboard shortcut fans, here are 12 of my
favorite shortcuts.
Word Keyboard Shortcuts
Back to top
Inserting a Caption
Summary: If you are using pictures, charts, text boxes and other graphical objects in a Word document you can add a caption to provide a description of the object. Here is how to do this:
- Right click on the picture or the object for which you want to add a caption.
- Click on Insert Caption.
- The Caption dialog box will appear.
 - The Caption dialog box will open.
- Click on the Label drop-down arrow.
- Enter a Caption Label .
- If you want to change the position of the caption, click on Left, Centre or Right in the Home tab.
- Click OK.
Word will insert the Caption.
Back to top
|
Managing Multiple Accounts
Summary: If you have configured Outlook to connect to multiple e-mail accounts, you need to ensure that your message is being sent from the correct account. Here are the steps to do this:
By default Outlook assumes that you want to send a message from the account that you are currently working in. If you are viewing the inbox of your Work account, Outlook selects Work as the message sending account. If you reply to a message in your Personal account, Outlook selects the Personal account as the message sending account.
When Outlook is configured for multiple accounts, a From button appears in the message header. You can easily change the message sending account. Click on the From button to display a list of active accounts. Select the account you want to send the message from.
Back to top
|
