create report in worksheet

A

AskExcel

Hi All,
I create userform for user to do entry. after that, data entered will flow
to worksheet and print out the report.
My problem is creating report in excel worksheet. its difficult if compared
to word.
If i need to readjust the column width at row 22, all my layout above row 22
will become off if i adjust the column width.
May i know how to avoid the changes for the layout above row 22? i tried to
freeze but to no avail.
Please HELP.
Thanks
 
K

kassie

If you chang a column width, you do just that - you change the width of the
entire column. If you change the height of a row, also you do just that.
You cannot change column widths or row heights for just one cell, or even a
range of cells. You either have to merge two adjacent cells, or otherwise
ensure that the cell next to the one which is too narrow, is empty, so that
it can overflow.

The idea is not to make your columns just wide enough, and not to always
work with adjacent cells.

If for example, you want to create an invoice, you make provision for Qty,
Description, Cost, Extended Cost and say tax inclusive. You do not use
columns A-E to do this. Instead, you will use col A for Qty, let Description
take up Column B, Cost you will put in say Column F and so on.

Now, if you want to use row 5 for customer name, 6 for address, etc. You
are not restricted to using column B for this info. You can eg. use Column E
for postal codes or Telephone numbers.
 
Top