MrExcel Publishing
Your One Stop for Excel Tips & Solutions

section breaks???

Posted by wendy on January 25, 2002 6:10 AM

I want to create a purchase enquiry form in EXCEL. To dot this I need to have my companies details at the top of the page and my customers, when I go further down the page to create a table to place in data such as the product, description, price quantity etc, I need to have differing columns widths to the information above this. is it possible to place a section break in EXCEL, so that I can have different size column widths?

Posted by George J on January 25, 2002 6:37 AM

Don't know about section breaks in excel, but can you not select cells and merge them to put the company details into, then the size of cells further down the page will not be an issue.

Good luck

Posted by Ian Bartlett on January 25, 2002 8:57 AM

Excel doesn't allow differing column widths down the page (I think Lotus Improv does, never used it).

If you can do what you need by following George's advice, do so - it's th ecleanest way.

However, there's another way:

- Make the tables that you want to appear on the printout in a separate area (off to one side, for example), and format them as you wish.

- Highlight one of the tables, select Edit|Copy.

- Click the top left cell in the printout area where the table should appear, hold the {shift} key down, and select Edit|Paste Picture Link.

This'll place a linked picture into your print area - resize it to suit. Changes in the original table will reflect in the pasted picture. When resizing, hold {shift} down to maintain the height : width ratio, and hold {alt} down to make the edges snap to cell boundaries.



Posted by Chris D on January 26, 2002 12:37 AM

Ian !

maintaining those ratios in the picture by holding down shift - you just made my day !! I use this picture facility a lot in my narratives, illustrating the management text with linked snapshots of the underlying spreadhseet.

Roll on Monday !