| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How doe I protect user defined functions in VB Editor | Excel Worksheet Functions | |||
| Can I protect an Excel spreadsheet, and use Outline functions? | Excel Worksheet Functions | |||
| Protect Workbook Vs Protect Sheet | New Users to Excel | |||
| Can I protect columns w/in a "List" using Protect Sheet? | Excel Discussion (Misc queries) | |||
| How do I protect only formulas(functions) in a workbook? | Excel Worksheet Functions | |||
Hybrid Mode
