How do I protect a row with functions in it?

R

Robert Judge

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?
 
F

Fred Smith

Two options:

1. Specify the range before sorting. If you let Excel find the range, it
will include the total line. So don't. Highlight the range first, then sort.

2. Move your total line to the top. Then sort starting with the line below
it.

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Top row of excel stays even in sorting 1
Value used in a Paste Link to remain constant during a sort 1
Lookup Column Headings and Sum the Rows 3
Row() and SUM() ?s 7
Cell reference value to remain constant in a sort using Paste Link 2
hide, unhide column or row after protect worksheet 4
autofilter with summary row 1
Create List/Add Row 1

Top