Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide and unhide Rows & Columns
Hi, I have a worksheet that is Plan calculator for customer of a telecom company. There are four sheets, sheet 1 Instructions (Instructions given how to put data and get result) sheet 2 Input sheet (data to be input) sheet 3 current Bill Data sheet (Showing cost to customer in which terrif plan he is) sheet 4 Best bill data sheet (this sheet guaides that which plan customer should choose) these all sheets are having so many calculations,formulas and formating. I want to know is 1) so may rows and columns are hidden and I am not able to unhide them. 2) In Input sheet al left side where row no. are there is + sing given. there are rows hide and by clicking + sign one can expande and unhide the rows I want to know to perform this task I am attaching the excel file for your reference. I am new user and not knowing formulas and formating, help me to understand. Thanks Aarif +-------------------------------------------------------------------+ |Filename: Best Plan calculator_Ver 1[1].2_Mar,06.zip | |Download: http://www.excelforum.com/attachment.php?postid=4492 | +-------------------------------------------------------------------+ -- Aarif ------------------------------------------------------------------------ Aarif's Profile: http://www.excelforum.com/member.php...o&userid=31998 View this thread: http://www.excelforum.com/showthread...hreadid=524844 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide and unhide Rows & Columns
Hi Aarif:
To unhide rows or columns, you have to choose the row (or column) on each side of the row you want to unhide. I do not know why, but you can not click on the cell to the left and above A1. To unhide all columns, click the A column, press and hold Cntl/shift , then press the right arrow until you get to the last column in your spreadsheet. Right click in the selected (blue) area, and choose Unhide. All the hidden columns will be unhidden. You can do the same for rows, but using the down arrow. John "Aarif" wrote: Hi, I have a worksheet that is Plan calculator for customer of a telecom company. There are four sheets, sheet 1 Instructions (Instructions given how to put data and get result) sheet 2 Input sheet (data to be input) sheet 3 current Bill Data sheet (Showing cost to customer in which terrif plan he is) sheet 4 Best bill data sheet (this sheet guaides that which plan customer should choose) these all sheets are having so many calculations,formulas and formating. I want to know is 1) so may rows and columns are hidden and I am not able to unhide them. 2) In Input sheet al left side where row no. are there is + sing given. there are rows hide and by clicking + sign one can expande and unhide the rows I want to know to perform this task I am attaching the excel file for your reference. I am new user and not knowing formulas and formating, help me to understand. Thanks Aarif +-------------------------------------------------------------------+ |Filename: Best Plan calculator_Ver 1[1].2_Mar,06.zip | |Download: http://www.excelforum.com/attachment.php?postid=4492 | +-------------------------------------------------------------------+ -- Aarif ------------------------------------------------------------------------ Aarif's Profile: http://www.excelforum.com/member.php...o&userid=31998 View this thread: http://www.excelforum.com/showthread...hreadid=524844 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide and unhide Rows & Columns
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide and unhide Rows & Columns
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide or unhide rows with button | Excel Discussion (Misc queries) | |||
Hide / Unhide columns and rows | Excel Discussion (Misc queries) | |||
Hide Unhide Rows | Excel Discussion (Misc queries) | |||
Can't unhide rows | Excel Discussion (Misc queries) | |||
Checkbox to hide and unhide rows Please. | Excel Worksheet Functions |