You want to prepare a list of persons and their loan tenure. You want to temporarilyhide the No. Of Installments Per Year and Principal Amount columns' data fromview. How will you achieve the requirement in Excel 2010?
You want to prepare a list of persons and their loan tenure. You want to temporarily hide the No. Of Installments Per Year and Principal Amount columns' data from view. How will you achieve the requirement in Excel 2010?
ASelect the respective columns, on the Data tab, click Group. In the Group
dialog box, select Columns. Click the minus sign to hide the group.
BSelect the respective columns, on the Insert tab, click Group. In the Group
dialog box, select Columns. Click the minus sign to hide the group.
CSelect the respective columns, on the Data tab, click Hide Detail to hide the
column`s data.
DSelect the respective columns, on the Data tab, click Filter. Click the minus sign
to hide the group.
Post your answers here:
Post
