ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can you put a table in excel footer (https://www.excelbanter.com/excel-discussion-misc-queries/114748-can-you-put-table-excel-footer.html)

VMorts

Can you put a table in excel footer
 
Is it possible for to but a table in an excel footer?

Dave Peterson

Can you put a table in excel footer
 
Not really--well, you can type anything you want and try to make it look like a
table. But that usually looks as bad as it sounds.

If you're using xl2002+, you can add a picture to the header/footer. Maybe you
could save your table as a picture and then insert that picture into the footer?

VMorts wrote:

Is it possible for to but a table in an excel footer?


--

Dave Peterson

Gord Dibben

Can you put a table in excel footer
 
Your table text could be no longer than 255 characters in any case.

That is the limit.

Best to go with the picture of the table as Dave suggests.

You can take a picture a couple of ways.

1. Select the range and hold SHIFT + EditCopy Picture.

Open MS Paint or similar and paste then save as a graphics file.

2. There is a Camera Tool found under ToolsCustomizeCommands

Drag to your Toolbar. Select the range and hit the Camera Icon.

Right-click and Copy.

Back to Paint or similar as above.


Gord Dibben MS Excel MVP


On Tue, 17 Oct 2006 10:22:59 -0500, Dave Peterson
wrote:

Not really--well, you can type anything you want and try to make it look like a
table. But that usually looks as bad as it sounds.

If you're using xl2002+, you can add a picture to the header/footer. Maybe you
could save your table as a picture and then insert that picture into the footer?

VMorts wrote:

Is it possible for to but a table in an excel footer?




All times are GMT +1. The time now is 05:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com