Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 wrote in message ... 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. |
#3
|
|||
|
|||
"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. |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help w/ Weight Formula | Excel Discussion (Misc queries) | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
How do I set up and use a group box form control? | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Copying list-box control | Excel Discussion (Misc queries) |