View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robert Judge Robert Judge is offline
external usenet poster
 
Posts: 24
Default How do I protect a row with functions in it?

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?