ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I print different sized tables on one sheet? (https://www.excelbanter.com/excel-discussion-misc-queries/72977-how-do-i-print-different-sized-tables-one-sheet.html)

akeacm

How do I print different sized tables on one sheet?
 
I have 3 excel tables I'd like to print on one sheet. They have different
column and row dimensions. Is there a way to keep those dimensions in tact?

Dave Peterson

How do I print different sized tables on one sheet?
 
Maybe...

Insert a new worksheet
back to the first table
select it
Edit|copy
Back to the new sheet
shift-edit|Paste picture Link

Then repeat with the other two tables (but situate them nicely on the new
sheet).

Then print that worksheet with the pictures.

By pasting the picture link, the pictures will update if you change a table.

akeacm wrote:

I have 3 excel tables I'd like to print on one sheet. They have different
column and row dimensions. Is there a way to keep those dimensions in tact?


--

Dave Peterson


All times are GMT +1. The time now is 08:55 PM.

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