two more questions

  • Thread starter Thread starter mary
  • Start date Start date
M

mary

Can I lock some columns on a sheet so they are not
editable ?
And I am new to excel and needed to calc several fields
from different worksheets onto one "totals" worksheet.
How do I do this? Thanks over and over again : )
 
Mary, by default all cells in excel are locked, if you only need a few
locked I would select them all first, Ctrl A, then go to format, cells,
protection and uncheck locked, then select the cells or columns you want to
lock and go to format cells and check locked, the go to tools, protection,
and protect sheet, enter a password if you want, now the cells that are
protected can not be edited, try something like this on your totals page
=SUM(Sheet1!A1:A10), this will sum whats in sheet 1 cells A1:A10

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Just to add to Paul's answer:

If you're adding up cells from different worksheets in different ranges, you can
do something like:

=sum(sheet1!a1,sheet2!b9,sheet3!c9,'sheet 4 has spaces'!d9)
or even
=sheet1!a1+sheet2!b9+sheet3!c9+'sheet 4 has spaces'!d9

But if you're summing the same cell (say A99) from a bunch of contiguous
worksheets, you can do something like:

Add two additional worksheets -- one directly to the left and one directly to
the right of that group of contiguouse worksheets.

Call the left one Begin and the right one Finish.

Then you can do something like:
=SUM(begin:finish!A99)

Kind of a sandwich with Begin and Finish as the bread. Everything between them
will be summed up. Including if you add more sheets later. And if you move a
sheet out of that sandwich, you're formula will adjust accordingly.

======
When I doing these formulas, I don't trust my typing--Either typos or syntax
errors. I'll type =sum( and the use the mouse to point at the individual cells
(and type the commas) to get the giant sum formula.

If it's the sandwich formula, I'll type =sum( and click on the first cell
(begin!a99) and shift click on the last worksheet tab (End).

Excel will do the heavy lifting for me.
 
Back
Top