Two Tables on one sheet

Barbee24

New Member
Joined
Jul 9, 2024
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Can I put two tables of different information on one sheet and be able to adjust the column width separately from each other? I would like them to print on the same page, but need to have different column widths for each
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
You can have two tables on the same sheet. If you want to control the column widths separately, then you'll need put them side by side. The only issue is if you want to filter either one; hidden rows in one will be hidden in the other.
 
Upvote 0
Thank you! I was hoping I could put the smaller table below the top table that has way more columns so I can print them on one page. No magic button for that I guess :)
 
Upvote 0
You can select multiple sheets to print and have them print together. They won't end up on the same page
 
Upvote 0
That's what I figured. I will just have to present to them on two pages.
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top