Insert a line above a Word table at the top of the page
Thursday, February 19, 2009 01:41 PM
If you've ever gotten stuck trying to add text above a table at the beginning of a document, this tip's for you--and you won't believe how easy it is.
Microsoft Word
Insert a line above a Word table at the top of the page
You've just created a table beginning on the first line of the first page of your document. After you've completed your table, shown in Figure A, you decide to add a caption above it.
Figure A
But when you try clicking the mouse above the table, the mouse keeps positioning itself in the first cell of the table, not above it. You could insert an extra row above the first to give yourself a place to type, but then you would have to remove the borders and merge the cells after typing the caption.
Fortunately, you don't need to do all that formatting. Simply follow these steps to insert a blank line above the table:
- Click in the upper left-hand corner of the first cell in the first row (before any text).
- Press the Enter key.
Word inserts a line above the table and positions the mouse pointer at the beginning of the line, where you can now type the caption (Figure B).
Figure B
Microsoft Outlook
Determine how Outlook displays unread messages
By default, Outlook displays unread messages in your Inbox using a bold font. It works, but you might prefer another way of making unread messages stand out. If that's the case, read on:
- In Outlook select the Inbox.
- Choose Arrange By from the View menu.
- Select Current View from the resulting submenu.
- Select Customize Current View.
- Click Automatic Formatting.
- At this point, several options are (probably) checked. Whatever options you leave checked will reflect the changes you make in subsequent steps. If you want to change the format only for unread messages, uncheck everything but the Unread Messages option.
- Click Font.
- Specify the formats you want to apply.
- Click OK three times.
It couldn't be easier--it's just a matter of knowing where to look for the right option. Don't settle for defaults unless they're really what you want.
Microsoft Excel
Create a timesheet in Excel to track billable hours for your customers
You can use an Excel spreadsheet to keep track of your billable hours: Just list the start time in one column, the end time in a second column and then subtract the first from the second.
But what if you don't charge the same for each block of time? For example, suppose you're working on three projects for one customer. You want to charge the hours directly spent on the projects in full, but you want to charge the customer for only half the time spent administering the project.
Follow these steps:
- Enter the labels for the worksheet as shown in Figure A.
Figure A
- Select F2:G9. Right-click the selection and then select Format Cells.
- Under Category, select Time. Under Type, select 1:30 PM (Figure B). Click OK.
Figure B
- Select H2:H9. Right-click the selection and then select Format Cells.
- Under Category, select Custom. Under Type, select h:mm (Figure C). Click OK.
Figure C
- Right-click H10 and then select Format Cells.
- Under Category, select Number (Figure D) and click OK.
Figure D
- Select H2:H7 and then enter the following function (Figure E):
=IF(OR(E2=”Project 1″,E2=”Project 2″,E2=”Project 3″),G2-F2,(G2-F2)*0.5)
Figure E
- Press Ctrl + Enter.
- Enter the data as shown in cells D2:G7 (Figure F).
Figure F
Excel automatically calculates half the time for Admin and full time for the projects. The total number of hours is calculated in H10.
There are currently no comments for this post.