different formatting of split pages

Hutia

New Member
Joined
Nov 9, 2009
Messages
17
Dear Sir/Madam,

Could someone help please? How do I split the worksheet in half so that I can format (eg make wider cells) only the bottom part and leaving the top one intact?

Your hlep would be abppreciated.
Regards,
hutia
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
An individual cells height and width are tied to the column width and Row height.
You can use merged cells to make bigger cells, but this can create issues with selecting rows/columns where merged cells exist.
Your question suggest you have two tables on the same worksheet. While in some cases this seems like a great idea, it can create any of several issues, like when disparate formatting is required.
Tables are best places on individual worksheets, especially when for reporting or dynamic data tables. (Fixed reference tables can be combined to a single worksheet usually without any problems since they are not generally printed.)
 
Upvote 0

Forum statistics

Threads
1,214,569
Messages
6,120,286
Members
448,953
Latest member
Dutchie_1

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