LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
John K
 
Posts: n/a
Default Excel edit problem, (of my own making!!)


Hi I am new to this forum.
Can you help me with a problem.
I was given an inventory in a spreadsheet. My experience with Excel is
limited, but I am a quick learner.
Here is my problem.
I have a column that should have formulas as follows:
=SUM(A1:F1)
the two cells are always supposed to be on the same row.
Somehow in the middle of the column I find this happenning:
=SUM(A234:f236)
the rest of the column formulas are offset by two row values.
Is there any easy way to edit this enite spreadsheet without having to
actually edit each individual cell?
Thank You,
John


--
John K
------------------------------------------------------------------------
John K's Profile: http://www.excelforum.com/member.php...o&userid=34726
View this thread: http://www.excelforum.com/showthread...hreadid=544910

 
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
strange problem with links updates in excel [email protected] Excel Discussion (Misc queries) 1 April 23rd 06 10:59 AM
Macro problem in Excel pd Excel Discussion (Misc queries) 2 March 14th 06 05:49 AM
EDIT FORMULA BAR in excel 2003? why not? where is it? alnav89 Excel Worksheet Functions 2 April 26th 05 07:02 PM
Excel Display Problem Bill Martin -- (Remove NOSPAM from address) Excel Discussion (Misc queries) 0 April 19th 05 05:25 PM
Problem Opening An Excel file. - by yk ilikecy Excel Discussion (Misc queries) 0 February 4th 05 08:19 AM


All times are GMT +1. The time now is 09:53 PM.

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

About Us

"It's about Microsoft Excel"