Excel
Excel 2003 - inserting a line into worksheet, causes the columns
(w/formulas) to get misaligned. Worksheet has some 3300 lines and 12 columns, we use this to track our inventroy. Any suggestions would be helpful. |
what do you mean by "misaligned"?
is the data off horizontally or vertically? are all of the locations off, or just some? "KP" wrote: Excel 2003 - inserting a line into worksheet, causes the columns (w/formulas) to get misaligned. Worksheet has some 3300 lines and 12 columns, we use this to track our inventroy. Any suggestions would be helpful. |
What do you mean mis-aligned? The reference in the formula does not change
automatically after line insertion? One possible reason is that how to cell address is referred in your formula. Please be more specific about your problem. ===== * ===== * ===== * ===== Daniel CHEN www.Geocities.com/UDQServices Free Data Processing Add-in< ===== * ===== * ===== * ===== "KP" wrote in message ... Excel 2003 - inserting a line into worksheet, causes the columns (w/formulas) to get misaligned. Worksheet has some 3300 lines and 12 columns, we use this to track our inventroy. Any suggestions would be helpful. |
All times are GMT +1. The time now is 10:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com