Posts Tagged ‘view’

Printing Different Pages in MS Excel

Wednesday, February 9th, 2011

Have you ever wondered how to print specific pages of your worksheet like you can do in MS Word? Well if you have, read on.

If each of your worksheets fit on one page (single sheet) then the answer to your question is fairly simple.  All you really need to do is select the worksheets that you would like to print, using your CTRL key to select each worksheet tab. Then when you print, only those worksheets will be printed.

However, if you would like to print specific pages from a worksheet that normally flows to multiple pages, then the answer is a bit more vexing.

One method is to temporarily hide the unwanted portions of your worksheet and then print the unhidden area. There is, however,  a much simpler resolution.

Follow the steps below to learn how:

  1. Click on View | Page Break Preview.
  2. MS Excel will display your worksheet, showing the various page breaks. In version 2007, this view is available to you by displaying the View tab of your Ribbon and clicking the Page Break Preview tool in the Workbook Views group.
  3. Select all cells in the first page you want printed.
  4. Hold down your CTRL key and select all the cells in your second page you want printed.
  5. Repeat steps 3 and 4 above,  for each page you would like to print.
  6. Click on File | Print to display the Print dialog box.  In version 2007, click Office button | Print.
  7. In the Print What area, select Selection.
  8. Click OK.
  9. MS Excel will print the pages you previously selected.
  10. Close the Page Break Preview display.

Versions 97, 2000, 2002, 2003, 2007

Headers & Footers in MS Word and OpenOffice Writer

Tuesday, March 3rd, 2009

A header is text that appears at the top of each page, or the pages that you select, in your document. A footer appears at the bottom of your pages. You may want to add pages numbers to the top or bottom of a document, and you can do so from the header or footer area. You do not have to add headers and footers to each page. Word enables you to type them just one time and it automatically adds them to each page.

Follow the steps below to add a header or footer to your document:

  1. Select View | Header and Footer, to display the Header and Footer toolbar and display an entry area in which you can type the header and footer text

  1. Type your header text. If you want to type footer text, click the toolbar’s Switch Between Header and Footer button to display the footer entry area and type your footer text.
  2. If you want to add page numbers, the date or the time to your header or footer text, click the appropriate buttons on the Header and Footer toolbar.
  3. Click the Close button to anchor the header or footer in your document.

Word normally dims header and footer text so that you can easily distinguish between the header and footer and the rest of your document. You can see these items when editing your document within the Print Layout view, but they remain dimmed while in Normal view. If you want to specify that the header or footer are to appear only on certain pages such as odd or even numbered pages, select File | Page Setup | Layout and check the Different Odd and Even or Different First Page check box. You must be in Print Layout view to see headers and footers in their proper places on the page.

If you want to edit a header or footer, display your document in Print Layout view and then double-click the dimmed header or footer text. Word opens the Header and Footer toolbar and enables you to edit the header or footer text.

Now let’s do the same thing in OpenOffice Writer:

You can create headers and footers for your pages. The most common use for headers and footers is to insert page numbers, but you can use them for anything your little heart desires.

To create a header or footer in OpenOffice Writer, follow the steps below:

  1. Choose Format | Page to open the Page Style dialog box.

  1. Click the Header tab or the Footer tab.
  2. Select the Header on check box or the Footer on Check box.
  3. To turn either off, deselect the check boxes.

Specify the rest of the settings for the header or footer as follows:

  • Same content left/right inserts the same header or footer content on both even and odd pages.
  • Left margin sets the left margin between the page and the header or footer.
  • Right margin sets the right margin between the page and the header or footer.
  • Spacing sets the space between the top or bottom of the page text and the header or footer.
  • Use dynamic spacing allows the header or footer to expand toward the text, overriding the spacing setting.
  • Height sets the height of the header or footer.
  • AutoFit Height adjusts the height of the header or footer according to the amount of text that the header or footer contains.
  1. Click OK to return to your document.

You can now see the header or footer in your document.

Click inside the header or footer, and enter the text and enter the text that you want to appear there.

If you haven’t subscribed to Carol’s Word Bytes Newsletter, perhaps you should!  http://www.carolscorneroffice.com.

Word 2007 Split Screen Tool

Wednesday, July 16th, 2008

 

The Split Screen functionality in MS Word is a nifty little tool.  It allows you to divide the screen in two, allowing you to work in one section of your document while viewing another section.

This can be very useful when referencing portions of your document, and moving content from one place in your document to another.

To access the Split Screen in Word 2003, the functionality and manipulation of the document is determined by your cursor, which will act as the focus for the window.

In version 2007, several features are governed by the mouse location – scrolling and zooming, which were previously controlled through the mouse, now use the mouse to determine window focus.

Accessing the Split is also a bit different. On the Ribbon, it is located under the View tab on the Window Ribbon.

I am sure you will find some documents where this feature will come in very handy sometime soon!