Excel - should be a defined Header footer section within the sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/com...f-3f14931b39de&dg=microsoft.public.excel.misc
 
In addition to Headers do you use the "rows to repeat at top" on th
page set-up...sheet options? If you leave a blank row between you
header and the data section (even if the row is hidden) then the heade
will not get included in the data section.

Rather fewer option for footers : only the normal Excel Footer

regard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Legacy Headers and Footers 1
EXCEL 2007 -INSERT WORK SHEET ICON 1
Common header/footer in Excel 4
Excel should be able to track changes without sharing workbook 0
interpreter .csv files (when opening .csv) should be configurable 2
Excel Show sheets side by side 1
Paste Special should be a nested menu....not a dialogue. 3
Excel needs the option to unhide multiple sheets at the same time 3

Back
Top