Hello again.
I am not sure what you mean by "group rows". If what you want to do is hide
rows 1, 2, 3, 5, 6, and 7, so the person viewing the spreadsheet can only see
the sums in rows 4 and 8, this is easy to do.
All cells are automatically set up as "protected". The protection does not
start, however, until you protect the worksheet. If you want your viewer to
only see the spreadsheet, and not to change anything at all, complete the
sheet as you want it to appear to your viewer, then go to
ToolsProtectionprotect sheet. Make sure all options are unchecked. Enter a
password, and click OK; re-enter the password, and it is done. People will be
able to view the sheet, but will not be able to do modify it in any way
unless they have the password.
Toolsprotectionprotect sheet gives you many different options if you want
to allow your viewer to modify some aspects of the sheet.
If you want to leave certain cells or rows or columns unprotected so your
viewer can enter information, choose the cells you want to unprotect, then
FormatCellsProtection, and uncheck the Protection box. Those cells will now
be completely open to your viewer.
I am sorry, I was not able to open your attachment, so I am not sure if this
answers your question.
John
"Aarif" wrote:
Hi john,
First of all thanks for spending ur valuable time for me, it works but
i want to konw that how can I restrict others to unhide hidden rows and
my 2nd question was that how to group rows like for Example,
a1,a2,a3 having figures and a4 having sum of a1:a3
a5,a6,a7 having figures and a8 having sum of a5:a7
I want to group rows 1,2 & 3 and want to hide and as same way row 5,6
& 7
I Want to know that sheet should show only a4 a8 field which containing
sum and three feilds of figures should be hidden. And I want a + sign at
left most side at row no 4 & 8 by pressing that i can expand thos hidden
rows.
I am from India and my english so poor I dont know u will get my point
or not. I am not able to explain my question so i am sending u a screen
shot of excel file. In that screen shot row no 13,16,20,23,26 i can see
and when i am clicking the + sing given near left side of row no hidden
rows are expands and Row no 14,15,17.......becomes unhide i want to know
hot to make it done.
Thanks,
Aarif
+-------------------------------------------------------------------+
|Filename: excel screen shot.gif |
|Download: http://www.excelforum.com/attachment.php?postid=4507 |
+-------------------------------------------------------------------+
--
Aarif
------------------------------------------------------------------------
Aarif's Profile: http://www.excelforum.com/member.php...o&userid=31998
View this thread: http://www.excelforum.com/showthread...hreadid=524844