Control cursor direction in highlighted group of cells/Page setup

How is the direction of the cursor movement changed in a group of highlighted
cells when enter is pressed?
Is it possible to have page setup be applied to all sheets of a workbook?
Presently I have to setup each page individually.
Is it possible for the Header to appear on page 1 of a sheet only?
Presently it appears on every page of a sheet.

George,

"How is the direction of the cursor movement changed "
tools, options, edit, move selection after enter, change to what you want

"Is it possible to have page setup be applied to all sheets of a workbook"
With the sheet that has the correct settings active, right-click on the
sheet tab and select "Select All Sheets", then use File/Page Setup and
immediately click OK (don't change anything). Click on some other worksheet
to get you out of "Group" mode now all sheets have the same page settings!

"Is it possible for the Header to appear on page 1 of a sheet only"
here is some code by Ron de Bruin that will do it

Private Sub Workbook_BeforePrint(Cancel As Boolean)
'will print the header on 1st page only
Totpage = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
With ActiveSheet.PageSetup
.CenterHeader = "Put Your Header Here"
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1
.CenterHeader = ""
ActiveWindow.SelectedSheets.PrintOut From:=2, To:=Totpage
End With
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"George Tung" <George Tung@discussions.microsoft.com> wrote in message
news:C50D8BF8-4FA4-4C7E-942A-9910011E518E@microsoft.com...
> How is the direction of the cursor movement changed in a group of
highlighted
> cells when enter is pressed?
> Is it possible to have page setup be applied to all sheets of a workbook?
> Presently I have to setup each page individually.
> Is it possible for the Header to appear on page 1 of a sheet only?
> Presently it appears on every page of a sheet.

"George Tung" wrote:

> How is the direction of the cursor movement changed in a group of highlighted
> cells when enter is pressed?
> Is it possible to have page setup be applied to all sheets of a workbook?
> Presently I have to setup each page individually.
> Is it possible for the Header to appear on page 1 of a sheet only?
> Presently it appears on every page of a sheet.

On Mon, 13 Jun 2005 04:10:02 -0700, "Omaheke"
<Omaheke@discussions.microsoft.com> wrote:

>
>
>"George Tung" wrote:
>
>> How is the direction of the cursor movement changed in a group of highlighted
>> cells when enter is pressed?

Tools>Otions>Edit>Move 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

"George Tung" wrote:

> How is the direction of the cursor movement changed in a group of highlighted
> cells when enter is pressed?
> Is it possible to have page setup be applied to all sheets of a workbook?
> Presently I have to setup each page individually.
> Is it possible for the Header to appear on page 1 of a sheet only?
> Presently it appears on every page of a sheet.

On Mon, 13 Jun 2005 04:10:02 -0700, "Omaheke"
<Omaheke@discussions.microsoft.com> wrote:

>
>
>"George Tung" wrote:
>
>> How is the direction of the cursor movement changed in a group of highlighted
>> cells when enter is pressed?

Tools>Otions>Edit>Move 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

"George Tung" wrote:

> How is the direction of the cursor movement changed in a group of highlighted
> cells when enter is pressed?
> Is it possible to have page setup be applied to all sheets of a workbook?
> Presently I have to setup each page individually.
> Is it possible for the Header to appear on page 1 of a sheet only?
> Presently it appears on every page of a sheet.

On Mon, 13 Jun 2005 04:10:02 -0700, "Omaheke"
<Omaheke@discussions.microsoft.com> wrote:

>
>
>"George Tung" wrote:
>
>> How is the direction of the cursor movement changed in a group of highlighted
>> cells when enter is pressed?

Tools>Otions>Edit>Move 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

"George Tung" wrote:

> How is the direction of the cursor movement changed in a group of highlighted
> cells when enter is pressed?
> Is it possible to have page setup be applied to all sheets of a workbook?
> Presently I have to setup each page individually.
> Is it possible for the Header to appear on page 1 of a sheet only?
> Presently it appears on every page of a sheet.

On Mon, 13 Jun 2005 04:10:02 -0700, "Omaheke"
<Omaheke@discussions.microsoft.com> wrote:

>
>
>"George Tung" wrote:
>
>> How is the direction of the cursor movement changed in a group of highlighted
>> cells when enter is pressed?

Tools>Otions>Edit>Move 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

"George Tung" wrote:

> How is the direction of the cursor movement changed in a group of highlighted
> cells when enter is pressed?
> Is it possible to have page setup be applied to all sheets of a workbook?
> Presently I have to setup each page individually.
> Is it possible for the Header to appear on page 1 of a sheet only?
> Presently it appears on every page of a sheet.

On Mon, 13 Jun 2005 04:10:02 -0700, "Omaheke"
<Omaheke@discussions.microsoft.com> wrote:

>
>
>"George Tung" wrote:
>
>> How is the direction of the cursor movement changed in a group of highlighted
>> cells when enter is pressed?

Tools>Otions>Edit>Move 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

"George Tung" wrote:

> How is the direction of the cursor movement changed in a group of highlighted
> cells when enter is pressed?
> Is it possible to have page setup be applied to all sheets of a workbook?
> Presently I have to setup each page individually.
> Is it possible for the Header to appear on page 1 of a sheet only?
> Presently it appears on every page of a sheet.

On Mon, 13 Jun 2005 04:10:02 -0700, "Omaheke"
<Omaheke@discussions.microsoft.com> wrote:

>
>
>"George Tung" wrote:
>
>> How is the direction of the cursor movement changed in a group of highlighted
>> cells when enter is pressed?

Tools>Otions>Edit>Move 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

"George Tung" wrote:

> How is the direction of the cursor movement changed in a group of highlighted
> cells when enter is pressed?
> Is it possible to have page setup be applied to all sheets of a workbook?
> Presently I have to setup each page individually.
> Is it possible for the Header to appear on page 1 of a sheet only?
> Presently it appears on every page of a sheet.

On Mon, 13 Jun 2005 04:10:02 -0700, "Omaheke"
<Omaheke@discussions.microsoft.com> wrote:

>
>
>"George Tung" wrote:
>
>> How is the direction of the cursor movement changed in a group of highlighted
>> cells when enter is pressed?

Tools>Otions>Edit>Move 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

On Mon, 13 Jun 2005 04:10:02 -0700, "Omaheke"
<Omaheke@discussions.microsoft.com> wrote:

>
>
>"George Tung" wrote:
>
>> How is the direction of the cursor movement changed in a group of highlighted
>> cells when enter is pressed?

Tools>Otions>Edit>Move 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

"George Tung" wrote:

> How is the direction of the cursor movement changed in a group of highlighted
> cells when enter is pressed?
> Is it possible to have page setup be applied to all sheets of a workbook?
> Presently I have to setup each page individually.
> Is it possible for the Header to appear on page 1 of a sheet only?
> Presently it appears on every page of a sheet.

"George Tung" wrote:

> How is the direction of the cursor movement changed in a group of highlighted
> cells when enter is pressed?
> Is it possible to have page setup be applied to all sheets of a workbook?
> Presently I have to setup each page individually.
> Is it possible for the Header to appear on page 1 of a sheet only?
> Presently it appears on every page of a sheet.

On Mon, 13 Jun 2005 04:10:02 -0700, "Omaheke"
<Omaheke@discussions.microsoft.com> wrote:

>
>
>"George Tung" wrote:
>
>> How is the direction of the cursor movement changed in a group of highlighted
>> cells when enter is pressed?

Tools>Otions>Edit>Move 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

"George Tung" wrote:

> How is the direction of the cursor movement changed in a group of highlighted
> cells when enter is pressed?
> Is it possible to have page setup be applied to all sheets of a workbook?
> Presently I have to setup each page individually.
> Is it possible for the Header to appear on page 1 of a sheet only?
> Presently it appears on every page of a sheet.

On Mon, 13 Jun 2005 04:10:02 -0700, "Omaheke"
<Omaheke@discussions.microsoft.com> wrote:

>
>
>"George Tung" wrote:
>
>> How is the direction of the cursor movement changed in a group of highlighted
>> cells when enter is pressed?

Tools>Otions>Edit>Move 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