View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default Can I lock a cell to a row?

As long as you don't physically insert/delete rows, yes. If you need to copy
entries to put into rows on the sheet. Use copy and Paste Special with the
"Values" option selected to add data to rows without actually inserting a new
row.

"Steve" wrote:

Excel 2007
Windows Vista Premium

I am tallying up a list of expenses and I want the TOTAL to be at a specific
line
at the bottom of the page (Row 45) even after I add some items and their
rows to the list above it.

Is this possible?