Two Types of Cell Formatting in One Sheet.

shaggyforum

New Member
Joined
Feb 26, 2013
Messages
11
This is an odd situation, I'm making a workbook that is supposed to be an application people can use, so the main page has some formatting to make it look more like a product than an excel sheet. There are some images in the header and some buttons, and then at about row 15 one of the buttons will make a pivot table. The problem is that this pivot table is never the same in terms of how wide each column needs to be for the data within. I have my worksheet being formatted (column widths) to the pivot table, but the problem is that this formatting will cause all my buttons and images above the table to be misplaced.

Is there a way to separate a worksheet into two such that I can have all the cells above the pivot table formatted one way and all the cells below another? I'm afraid this might be something obvious that I'm missing in excel so I'm sorry for being a noob if that's the case. I should also note that I do not want to use the freeze frame option. Thanks very much for your time.
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,464
Office Version
  1. 365
Platform
  1. Windows
You can change the properties of the images and buttons to "Don't move or size with cell"

Right click, choose format and look for properties.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,511
Messages
5,596,576
Members
414,079
Latest member
Frills

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
Top