Print selected pages from different sections of a Word document
Thursday, November 27, 2008 02:11 PM
Choosing which pages to print is a straightforward process, thanks to Word's Page Range options. But if those pages belong to different document sections, you'll need to give Word a little extra guidance.
Microsoft Word
Print selected pages from different sections of a Word document
The Page Range section of Word's Print dialog box lets you print only the pages you need. For example, if you needed to print pages 1, 10, and 100 of a 100-page document, you would enter 1,10,100 in the Pages text box.
That works--as long as your document is not made up of more than one section.
For example, say you have a document that is divided into 10 chapters, each in a separate section of the document, and each numbered separately starting with 1. Thus, Chapter One is numbered 1-1 through 1-10; Chapter 2 is numbered 2-1 through 2-20; and so on. To print Chapters 1 and 4, you would enter the following in the Pages text box:
s1,s4
To print Chapters 2 through 4, you would enter:
s2-s4
To print individual pages within each section, you would add p and the page number to the section number. For instance, to print pages 1-1 and 2-2, you would enter
p1s1,p2s2
as shown in Figure A.
Figure A
Microsoft Access
Set up Access parameter queries to search for a character string
Parameter queries are not just for querying records when you know exactly what you're looking for. You can also use them to search for records that contain any string of characters, anywhere in a field.
Rather than having users remember how to use wildcards, you can create a parameter query that allows them to enter just the string of characters they're looking for. Follow these steps:
- Open the query in Design mode.
- Click in the Criteria cell of the name field and enter the following, as shown in Figure A:
Like"*"&[Enter character string]&"*"
- Close and Save the query.
Figure A
Now let's say you want to find the balance of a company whose name includes the word Music. When you run the query, you would enter Music in the parameter query dialog box, as shown in Figure B.
Figure B
As you can see in Figure C, even though Music appears in the middle of the name, Access is still able to find the record.
Figure C
Microsoft Excel
Prevent users from inadvertently entering the wrong year in a worksheet
Old habits die hard. This is especially true when it comes to entering dates in January. Fortunately, Excel provides a way to prevent users from mistakenly entering 1/1/2008 when they should be entering 1/1/2009.
Follow these steps when setting up your worksheets for data entry next year:
- Select the range of cells where users will enter a date.
- Go to Data | Validation. (In Excel 2007, click the Data tab and then click Data Validation in the Data Tools group.)
- Click on the Settings tab.
- Click the drop-down arrow in the Allow box and select Date.
- Click the drop-down arrow in the Data box and select Greater Than Or Equal To.
- Under Start date, enter 1/1/2009, as shown in Figure A, and click OK.
Figure A
Now, when a user enters 2008 instead of 2009, Excel displays the message shown in Figure B.
Figure B
There are currently no comments for this post.