+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Nick
    Guest

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

    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

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1