Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create report in worksheet
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create report in worksheet
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. "AskExcel" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I create a worksheet menu to select each other worksheet | Excel Discussion (Misc queries) | |||
quickly create extra copies of a worksheet template in a workbook | Excel Worksheet Functions | |||
Create a Pop window in a Excel Worksheet | Excel Discussion (Misc queries) | |||
create menus in excel worksheet | Excel Worksheet Functions | |||
Create a "recap" worksheet that includes all info from all worksh. | Excel Worksheet Functions |