Creating printed forms can be a hassle if you can’t get those blank lines to cooperate. Learn one of the easiest and most versatile ways to set up your form: using underlined tabs.

Word users often create printed fill-in forms that include underlined blanks spaces for writing in form data. While you can press Shift + – (hyphen) repeatedly to create these daily cialis dose underlined spaces, it’s difficult to line up the lines. Leader tabs make it easier to create even lines, as well as saving keystrokes, but you’re limited to four underline styles.

Using the Underline button to underline tab characters gives you all the advantages of leader tabs with a wider choice of underline styles. For example, say you have used tabs to lay out your form, as shown in Figure A.

Figure A

To create the lines, just follow these steps.

1. Select the first tab mark you want to underline, then hold down the Ctrl key while you select each of other tab marks (Figure B).

Figure B

1. Go to Format | Font, choose the thick underline style from the Underline drop-down list, and click OK. In Word 2007, go to the Home tab, click the Underline button arrow in the Font group, and select a style from the Underline style list (Figure C).

Figure C

All lines will be printed, as shown in Figure D.

Figure D

When you have a Word table that spans multiple pages, you’ll probably want the header row to appear at the top of each page. Luckily, repeating a heading row across several pages takes only a few quick clicks.

---

cialis tablets for sale width=”100%” size=”2″ />

Sometimes, what seems to be a difficult problem has an easy built-in solution. I ran into that recently with a Word table that was several pages long. Of course, I wanted to repeat the table’s header row at the top of each page. That way, readers didn’t have to return to the table’s first page to learn what type of data was in a particular column. I had to stop and think for a minute, as I couldn’t remember ever doing this before.

Customized menus make it easy to miss built-in features. If you don’t use the item occasionally, Word doesn’t display the item on the menu! It’s less than intuitive, but I went back to the Table menu and clicked the double arrow to display all the menu items and there it was — Heading Rows Repeat.

To use this feature, simply click inside the header row and choose Heading Rows Repeat from the Table menu. It couldn’t be simpler. Word then displays the heading row at the top of every page as long as the table continues.

If you need to know how many words are in a document, and some of them are inside a text box, you’ll have to perform at least one extra step. Here’s a look at how to get the numbers you need.

The Word Count command in Word 2002/2003 excludes text boxes when totaling the number of words in your document. As Figure A shows, the Word Count dialog shows a count of 0, even though the document contains two linked text boxes filled with text.

Figure A

Since the text boxes are linked, you can find the number of words in those boxes by following cialis soft tabs vs cialis these steps:

1. Press Ctrl + A.

1. Go to Tools | Word Count.

The Word Count box now shows the correct number of Words in the text boxes, as shown in Figure B.

If the text boxes had not been linked, you would have needed to perform this operation on each box separately and then add the totals of each box to get a final count. Likewise, to calculate the total number of words in a document with one text box surrounded by other text, you would go to Tools | Word count to find the total for the surrounding text, follow steps 1 through 3 to find the total for the text box, and then add the two numbers for your total.

Word 2003 offers a gallery of Table AutoFormat styles — but they may not always suit your needs. See how to build your own style to quickly make tables look exactly the way you want.

Word’s Table AutoFormat feature offers an assortment of prefab styles you can use to jazz up your tables. But those styles may not necessarily match your document design or serve your table’s purpose. Luckily, you can specify your own set of attributes and save them as a user-defined style. Then, you can just apply the style to a table whenever you want to use your custom formatting.

Note: This information is also available as a PDF download.

To demonstrate, let’s say you generate a weekly dashboard report whose data is contained in a nice-looking, easily interpreted Word table… but manually formatting the table is getting a little old. Time to build a custom style:

Figure A

1. Enter a name for the style (e.g., Dashboard) and choose the style you want to base your new style on (Figure B). We’re going to base our sample style on the basic Table Grid style, but you can start off with something fancier if you prefer. Or choose Table Normal, which is unformatted, if you want to start with a blank slate.

Figure B

1. Now you can use the various tools in the New Style dialog box to specify the desired formatting. Just choose the table component you want to format from the Apply To drop-down list (Figure C) and make your selections. For this example, we specified 11-point Arial for the entire table, 14-point bold formatting and a light yellow fill for the heading row, a 1.5-point blue outside border, a 1-point yellow inside border, light blue fill for odd rows and light yellow fill for even rows (Figure D). (You’ll notice that some of the formatting — such as the font — doesn’t display in the preview.)

Figure C

Figure D

1. Click the Format button to access additional options governing the appearance of table elements and table text (Figure cialis shelf life E). In this case, we selected Paragraph and specified 6 points of space above and below each paragraph. Not all options are available to include in your table style. For instance, you can’t set Preferred Width or Text Wrapping in the Table Properties dialog.

Figure E

1. If you want the style to be available to other documents based on the current template, click Add To Template. Otherwise, the style will belong to the current document only. Click OK to return to the Table AutoFormat dialog box.
2. If you’d like this table style to be the default for all new tables you create, click Default in the Table AutoFormat dialog box. Word will let you choose between setting the default for the current document or for all documents that use the current template (Figure F). Make your selection and click OK. If you don’t want to set a default, skip this step and simply close out of the Table AutoFormat dialog box.

Figure F

The payoff

To apply the style, click in a table and open the Table AutoFormat dialog box. Choose User-Defined Table Styles from the Category drop-down list box to display your custom style(s) (Figure G). Now, just select the style and click Apply.

Figure G

Avoid the hassle of manually importing Word form data into Excel. With the help of an Excel wizard, you can quickly step through the process.

Word forms provide a convenient way to gather information from users or clients so that you can analyze it later. But bringing the data into Excel can be a big chore. To avoid having to manually enter the data into a worksheet, let Excel’s Text Import wizard bring it in for you. To demonstrate, let’s say you’ve asked employees to complete the form shown in Figure A.

Figure A

Follow these steps to save the data in each completed form to a text file that can be imported into Excel:

Figure B

You can now import the data in the text files into a spreadsheet by following these steps:

1. cialis canadian pharmacy
   Open a blank worksheet in Excel.
2. Go to Data | Import External Data | Import Data. (In Excel 2007, click the Data tab, click Get External Data, and then select From Text.)
3. Click the text file you want to import, then click Import.
4. Select the Delimited option (Figure C) and then click Next.

Figure C

1. For this example, clear the Tab check box and then select the Comma check box (Figure D).

Figure D

1. Click Next and then click Finish.
2. Click in cell A1 and then click OK.

Figure E shows the resulting data. Note that headers have been inserted above the data in row one.

Figure E

To import the second text file, you just open the same Excel worksheet and click in the second row below the last row of data; in this case, A4. (The wizard forces you to skip a row each time you add a new row of data. You can delete these blank rows later.)

Important note: If you need to enter more than a handful of forms a day, you should consider using ADO (ActiveX Data Object) to create a code connection to the worksheet that will automate the data transfer process.