Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
#3
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |