Hi All,

My report is displaying over 20 columns of data, and spans across 2 - 3 pages in the excel sheet.

I want to format my header and subhead in such a way that the heading appears at the centre of the first page. I am using EXL97, as I need borders. EXL2K is not displaying any borders at all in the report.

If there is any workaround, please let me know.

Thanks,
Ved

This message has been edited. Last edited by: Kerry,

Hello Ved,

There really isn't a way to center a heading on a page in EXCEL, because there isn't a page until you print it. It's a spreadsheet. It really doesn't have pages.

What you could do is use colspan, to pick a number of columns that the heading will spread across.

Justify will center it.
Choose a colspan that best fits.

Here is an example......

HEADING CENTER
"MY HEADING"
PRINT
COUNTRY COUNTRY COUNTRY COUNTRY COUNTRY
COUNTRY COUNTRY COUNTRY COUNTRY COUNTRY
COUNTRY COUNTRY COUNTRY COUNTRY COUNTRY
COUNTRY COUNTRY COUNTRY COUNTRY COUNTRY
ON TABLE PCHOLD FORMAT EXL97
ON TABLE SET STYLE *
TYPE=HEADING,HEADALIGN=BODY,$
TYPE=HEADING,LINE=1,OBJECT=TEXT,JUSTIFY=CENTER,
COLSPAN=8,$
ENDSTYLE
END

Hope this helps....
John
WebFOCUS 767 linux, 764 / 717 win/xp