Thread: How do I protect a row with functions in it?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I protect a row with functions in it?
Leave a blank row above your SUM row.


Gord Dibben MS Excel MVP

On Thu, 24 Jan 2008 17:46:00 -0800, Robert Judge
wrote:

In an Excel 97 worksheet, my last row contains the "SUM" function for several
columns. When I sort the worksheet by a diferent column, that row gets mixed
up into the worksheet and loses its SUM functions.

When I sort the worksheet, how can I keep or protect that row so that it
remains as the last row in the worksheet, with the forumulas intact?

Reply With QuoteReply With Quote