Excel 2010 - How do you fix the width of a frozen merged cell to automatically fit the..

A

Adam Davis

New member
...screen? I'm producing a spreadsheet for work that has a header of merged cells at the top. I have frozen the row so it is visible when you scroll down. All the computers in my office have different screen resolutions and versions of MSOffice so when I've made spreadsheets in the past, the appearance has been a lot different to how I wanted it to be. Is there any way of setting the selected cells to auto fit to the screen?

TIA!

Adam
 
Back
Top