On Mon, 13 Jun 2005 04:10:02 -0700, "Omaheke"
wrote:



"George Tung" wrote:

How is the direction of the cursor movement changed in a group of highlighted
cells when enter is pressed?

ToolsOtionsEditMove selection after ENTER.

For other methods of tabbing through a range see Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Is it possible to have page setup be applied to all sheets of a workbook?
Presently I have to setup each page individually.

Right-click on the active sheet tab and "Select all sheets". Set up the
active sheet and will be done for all sheets. Note: some setup features are
not available when in "group" mode.

DO NOT FORGET to right-click and "ungroup sheets" when done.

Is it possible for the Header to appear on page 1 of a sheet only?
Presently it appears on every page of a sheet.

Only by using VBA code. See Ron de Bruin's site for this.

http://www.rondebruin.nl/print.htm#Header


Gord Dibben Excel MVP