http://www.howtogeek.com/forum/ How-To Geek Forums Topic: Changing Cell Sizes for only part of the document en Fri, 09 Jan 2009 04:07:46 +0000 http://www.howtogeek.com/forum/topic/changing-cell-sizes-for-only-part-of-the-document#post-43895 Fri, 22 Aug 2008 14:42:13 +0000 Aleeve 43895@http://www.howtogeek.com/forum/ <p>Ok, I have found a way around this now, but, if anybody knows it would be good to know please! </p> http://www.howtogeek.com/forum/topic/changing-cell-sizes-for-only-part-of-the-document#post-43887 Fri, 22 Aug 2008 11:55:48 +0000 Aleeve 43887@http://www.howtogeek.com/forum/ <p>Ok,<br /> Basically, for my coursework I need to create a booking system for a school production (like a theatre)</p> <p>As you can see in the picture, I have copied out the stage plan, and then in the section that I have (very badly) highlighted in yellow scribbles, I will need a table, using =COUNTIF formulas and similar to work out how many seats are taken etc. I know how to do all that side of it, but the thing is, as you may notice in the screenshot, I have had to fiddle around with the cell size so the whole stage plan fits on the screen.<br /> This then means that for the whole sheet the sizes are different, and I can't possibly have a table with the dimensions that I have changed it to!</p> <p>So, essentially, what I am asking is how do you change just some of the margins - I want the highlighted area 'sectioned off' if you like so that the margins can go back to default in that bit.<br /> Normally I would use a picture or something, but obviously all the data needs to be updated all the time - you change something in the plan (eg add an 'a' or 'c') and that will change the chart.</p> <p>So, I know this is a lot to read and probably quite a lot to ask, but I could really do with solving this! Thanks :)</p> <p><a href="http://s294.photobucket.com/albums/mm90/TheAleeve/?action=view&#38;current=Excel.jpg"><img src="http://i294.photobucket.com/albums/mm90/TheAleeve/Excel.jpg"></a></p> <p>Link to full size image:<br /> <a href='http://i294.photobucket.com/albums/mm90/TheAleeve/Excel-1.jpg'>http://i294.photobucket.com/albums/mm90/TheAleeve/Excel-1.jpg</a> </p>