I find it frustrating when formattng spreadsheets with headings/titles/images
having insert these at the top of the sheet with my data, because the heaer
and fooer sections are limited.

Perhaps Headers could be improved so that they are a defined area within the
sheet, and can be as large a possible, but are not part of the 'data' area
and therefore not included for sorting/subtotals/etc.

This could be he same for footers.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

In addition to Headers do you use the "rows to repeat at top" on the
page set-up...sheet options? If you leave a blank row between your
header and the data section (even if the row is hidden) then the header
will not get included in the data section.

Rather fewer option for footers : only the normal Excel Footer

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=564203