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

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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,215,731
Messages
6,126,537
Members
449,316
Latest member
sravya

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