#1   Report Post  
KP
 
Posts: n/a
Default 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.
  #2   Report Post  
bj
 
Posts: n/a
Default

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   Report Post  
Daniel CHEN
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting Excel Data from One Sheet to Another.... Robin Excel Discussion (Misc queries) 2 April 21st 05 01:15 PM
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 03:44 AM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM


All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"