+ Reply to Thread
Results 1 to 2 of 2

How to create a table in the Excel footer?

  1. #1
    Registered User
    Join Date
    01-22-2008
    Location
    Germany
    Posts
    1

    Question How to create a table in the Excel footer?

    Hello.

    I'm having problems trying to get some uniformity in our documents. The problem is that all of our company Winword documents (thousands of documents) already have a table in the footer in which the following information is listed in sequential order:

    Machine no.:
    Filename:
    Version:
    Date:
    Page x of x

    The table is made up of 2 rows and 5 columns.
    The bottom row is updated by the worker that processes the file.

    Furthermore, we do not edit the winword footer but instead edit the document properties because there are fields in the winword footer that are connected to the document properties. In other words machine no., version and date are edited in the document properties and this changes the footer.

    Can this be done in Excel with a footer?

    I have found out how to insert the properties into the footer (in Excel), but not how to create a table in the footer.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Tao_Yogi,

    You can insert most of this information into the Excel footer. Machine number is something that isn't available as part of the standard footer. Starting with Excel 2002, you can now insert pictures into the header or footer, but I don't think you can embed objects like a table. So, you will have to deal with having the data justified to the left, center, or right on the footer. Adjust the footer's height for more rows.

    Sincerely,
    Leith Ross

+ 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