Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you create a complex footer (e.g. title block) in Excel?
I would like to create a complex footer (e.g. one that simulates a standard
drafting drawing title block) that will print at the bottom of each sheet. Essentially I need the ability to repeat a group of columns at the bottom of the sheet. Has anyone achieved this? Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you create a complex footer (e.g. title block) in Excel?
No way to do this
You might want to try linking the worksheet to a Word doc and putting complex footer in the Word doc Being basically lazy, it this workbook was in my control (ie, not being given to other to use) I would just print the footer from Word and re-inset the paper and print the Excel doc with appropriate bottom margin setting best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Yrrag" wrote in message ... I would like to create a complex footer (e.g. one that simulates a standard drafting drawing title block) that will print at the bottom of each sheet. Essentially I need the ability to repeat a group of columns at the bottom of the sheet. Has anyone achieved this? Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you create a complex footer (e.g. title block) in Excel
Hello Bernard,
Unfortunately I cannot take this approach. This document must remain self contained as it will be passed between companies through their document control process. We are considering creating some custom VBA code that will generate a footer on each page. However, this poses the issues of long term support and releasing our intellectual property to other companies (we'll have to deal with this). Our other thought is to lock the page sizes and to intersperse "slave footers" throughout the large document. The slave footers would be linked to a master footer on a separate tab of the document. This solution has the advantage of being self contained and relatively easy to maintain. Thx, Garry "Bernard Liengme" wrote: No way to do this You might want to try linking the worksheet to a Word doc and putting complex footer in the Word doc Being basically lazy, it this workbook was in my control (ie, not being given to other to use) I would just print the footer from Word and re-inset the paper and print the Excel doc with appropriate bottom margin setting best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Yrrag" wrote in message ... I would like to create a complex footer (e.g. one that simulates a standard drafting drawing title block) that will print at the bottom of each sheet. Essentially I need the ability to repeat a group of columns at the bottom of the sheet. Has anyone achieved this? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a Title row or field in Excel 2003? | New Users to Excel | |||
Insert some cells by keeping the title block as same | Excel Discussion (Misc queries) | |||
Create capability to Paste Text into an Excel Footer | Excel Discussion (Misc queries) | |||
Title Block in Excel Chart - Size problem | Charts and Charting in Excel | |||
Title Block as a header? | Excel Discussion (Misc queries) |