Row 1 to repeat at top help

[kevs]

How does one get the top row to print out top of each page. Thanks!
Kev
OS 10.4.7
Office 2004

 

[Bob Greenblatt]

How does one get the top row to print out top of each page. Thanks!
Kev
OS 10.4.7
Office 2004

Assign it as a print title. Look in help.

 

[PhilD]

How does one get the top row to print out top of each page. Thanks!

To get you started: in Windows there's a feature "Rows to repeat at
top:" and "Columns to repeat at left:". You will need something
similar.

As Bob G says, Help will help.

PhilD

 

[kevs]

To get you started: in Windows there's a feature "Rows to repeat at
top:" and "Columns to repeat at left:". You will need something
similar.

As Bob G says, Help will help.

PhilD

Thanks , help menu did not explain. In short I just want to repeat row 1.
But if I put 1, in field to repleat does not work, says that is not good
formula.


OS 10.4.7
Office 2004

 

[Art]

Thanks , help menu did not explain. In short I just want to repeat row 1.
But if I put 1, in field to repleat does not work, says that is not good
formula.


OS 10.4.7
Office 2004

kevs,
The Page Setup / Sheet / Print Tiles fields want a range specification.

Examples -

Ff you want rows 1 through 3, enter: $1:$3
in the "rows to repeat at top".
So in your specific case for row 1 only: $1:$1

If you want columns A through C, enter: $A:$C
in the "columns to repeat at left"



Art

 

[CyberTaz]

.... Or use the Range Selector button at the right end of the field & select
the row(s) to be repeated - that's what it's there for

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Art]

Bob,
I was referencing the dialog on Office X (Excel 10.1.9) which doesn't
have this feature. The hashed diamonds next to the edit boxes
collapse/expanded the dialog box.

Art

 

[CyberTaz]

Hi Art:

Wasn't contradicting, just expanding I believe we're simply calling the
same thing by different names.

The triangle is what I'm referring to as a "Range Selector" button. I don't
have Office X installed, but I'm certain this type of device has been there
as far back as I can remember on Mac & PC - although its appearance has
changed over the years. It's also used in the Insert Function dialog as well
as a number of others where selecting _ranges_ is required. Part of its
operation is collapsing the dialog to display only the field being edited &
allow more viewing are in the workbook window.

Truth be known, you don't even have to click the button. Simply navigate
into the field then click/drag in the sheet. The dialog will not only
collapse as you do but it will automatically expand when you release the
mouse button.

BTW: the OP's sig indicated he's using Office 2004

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Art]

Bob,
The "Range Selector" functionality as you describe is indeed present in
Office X. I guess I've always found it just as efficient to enter the
ranges with keystrokes vs. rodent movements, especially in the case of
print area definitions.

Not having access to Office 2004, I wanted to reply with something that
I knew wound work and to clarify the expected syntax which is where the
OP was having difficulty.

Art

 

[CyberTaz]

No problem, Art - in fact, I agree about the keyboard entry _most_ of the
time The main advantage of the button for me is getting the dialog to
collapse in order to visually verify the reference... And clarifying the
required syntax was quite helpful for the OP, I'm sure - it isn't the most
"intuitive" for most uninitiated users Oddly enough, using the mouse
automatically imposes the proper syntax when used to select the range.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[kevs]

No problem, Art - in fact, I agree about the keyboard entry _most_ of the
time The main advantage of the button for me is getting the dialog to
collapse in order to visually verify the reference... And clarifying the
required syntax was quite helpful for the OP, I'm sure - it isn't the most
"intuitive" for most uninitiated users Oddly enough, using the mouse
automatically imposes the proper syntax when used to select the range.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Excellent tips guys.
Bob, where is this hidden ranger finder. I've never heard of it and can't
find it, even help does not mention it.



OS 10.4.7
Office 2004

 

[CyberTaz]

In Mac XL it's represented by a triangle at the right end of an editable
field in a dialog box. When you click the triangle it collapses the dialog
to take up less screen space and allows you to use the mouse to select the
range of cells. The range reference is inserted into the field as you select
it, and when you click the triangle (which is now inverted) the dialog
expands so you can go on from there.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Art]

In addition, you can simply click or tab to the edit box of choice
(e.g.: Print Area, Rows or Columns to Repeat) and then move the rodent
to the worksheet area. Then click and drag to select the area of choice.
This action will cause the dialog box to collapse as Bob J. indicates.

When the rodent is released, the dialog box will revert to normal size.

Art

 

[kevs]

In Mac XL it's represented by a triangle at the right end of an editable
field in a dialog box. When you click the triangle it collapses the dialog
to take up less screen space and allows you to use the mouse to select the
range of cells. The range reference is inserted into the field as you select
it, and when you click the triangle (which is now inverted) the dialog
expands so you can go on from there.

HTH |:>)
Bob Jones
[MVP] Office:Mac

Thanks guys, don't know what "XL" means, never heard of that, and don't
think ever seen arrow in the fields.


OS 10.4.7
Office 2004

 

[kevs]

XL = Excel.

As far as the arrow, just go to File> Page Setup> Sheet lock at the Rows to
Repeat at Top field. At its right end you'll see a button with a triangular
arrowhead icon - that's it.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Thanks Bob:
I don't see words sheet lock anywhere.
I do see an upward arrow at the right of the rows to repeat field, but when
I click on that, it just minimizes the page set up box, nothing more.



OS 10.4.7
Office 2004

 

[CyberTaz]

Thanks Bob:
I don't see words sheet lock anywhere.

OK - that was a typo... You don't have to tell everyone It was meant to
indicate the Sheet Tab of the Page Setup dialog and the word "lock" should
have been "look".

I do see an upward arrow at the right of the rows to repeat field, but when
I click on that, it just minimizes the page set up box, nothing more.

*Exactly what I'm saying*, we're just using different terms. I refer to it
as _collapsing_ the dialog [Page Setup in this case] because the dialog
remains in the same position on screen. To my way of thinking "minimize"
refers to removing something from the work area altogether & sticking it
someplace else to be called back later... Such as minimizing a file or
application window to the OS X Dock or to the Taskbar in Windows.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[kevs]

Thanks Bob:
I don't see words sheet lock anywhere.

OK - that was a typo... You don't have to tell everyone It was meant to
indicate the Sheet Tab of the Page Setup dialog and the word "lock" should
have been "look".

I do see an upward arrow at the right of the rows to repeat field, but when
I click on that, it just minimizes the page set up box, nothing more.

*Exactly what I'm saying*, we're just using different terms. I refer to it
as _collapsing_ the dialog [Page Setup in this case] because the dialog
remains in the same position on screen. To my way of thinking "minimize"
refers to removing something from the work area altogether & sticking it
someplace else to be called back later... Such as minimizing a file or
application window to the OS X Dock or to the Taskbar in Windows.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Ok Bob, still don't get it, you minimize box, but what?
Bottom line -- to repeat a row you need to enter a formula,,, or not?


OS 10.4.7
Office 2004

 

[PhilD]

Ok Bob, still don't get it, you minimize box, but what?
Bottom line -- to repeat a row you need to enter a formula,,, or not?

As instructed before:

EITHER click and drag on the row(s) you want to repeat;
OR type $1:$3 to get rows 1 to 3.

PhilD

 

[kevs]

$1:$3

Phil:
I'm going with the $1:$3 route,
The other option, I still don't have a clue about, just curious.




OS 10.4.7
Office 2004