Prev: numbers in a column are not sorting ascending
Next: Need to bring back 2 vlookup values
From: Gord Dibben on 6 Apr 2010 15:45
Same in 2003 and 2007

I misspoke.

Rows 12 and 13 won't appear as repeating on first page but will on each
successive page.

Right as always...............NOT! <g>


Gord


On Tue, 6 Apr 2010 15:46:15 -0300, "Bernard Liengme"
<bliengme(a)TRUENORTH.stfx.ca> wrote:

>I see the same type of behaviour as Glen in Excel 2010 beta
>best wishes

From: Opal on 6 Apr 2010 19:53
??

Yes, they used to repeat and suddenly not...not sure why
or how this happened, but I can't get these rows to repeat
anymore.
From: Glenn on 7 Apr 2010 09:12
Opal wrote:
> ??
>
> Yes, they used to repeat and suddenly not...not sure why
> or how this happened, but I can't get these rows to repeat
> anymore.

Make sure you have only this one worksheet selected, then go to File / Page
Setup / Sheet / Rows to repeat at top: and enter $12:$13. When you print (or
Print Preview), what is the result?
From: Opal on 7 Apr 2010 16:19
the result is

Page 1

Rows 1 - 21

Page 2

Rows 1 - 9, 22-29

From: Glenn on 7 Apr 2010 17:15
Opal wrote:
> the result is
>
> Page 1
>
> Rows 1 - 21
>
> Page 2
>
> Rows 1 - 9, 22-29
>


Makes no sense. If you want, and if the workbook is less than 1mb, email it to
me at schwandtg at aol dot com and I'll take a look at it.
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: numbers in a column are not sorting ascending
Next: Need to bring back 2 vlookup values