column width setting

G

Guest

Hello all. I'm currently working in Excel and have a spreadsheet made up of lots of smaller sheets. Within one 'tab' (sheet) I have set up multiple page breaks. I adjusted the column and row width on the first page (as defined by my breaks). I do not want the second and third and fourth and so on pages to have the same column/row width/height as the first page however, when I am in the second page and go to ajust these it also changes the first page- despite the page breaks (which are set up to break horizontally and vertically).

Any suggestions?
 
A

Anders S

Column widths and row heights apply to the entire worksheet, regardless of page breaks. That's the way it is.

Regards,
Anders Silven
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove page breaks 2
Column Header 1
Pivot Table Page Break Refresh Problem 0
data prints outside column 2
Printing an Excel Spreadsheet 1
excel macro page break 1
How to remove dashed page lines after using print preview 1
Printing, Scaling, Page Breaks 1

Top