Well I am having an issue with the Microsoft Excel which I have installed on the computer of mine. I have noticed that I am unable to do subtotal on Excel sheet. I have tried with the lots of stuff but there was no solution to fix the matter of mine. Any help to fix the matter would be highly appreciated. Thanks a lot in advance.
If you are using Microsoft Excel 2003 on the computer of yours then I think I am aware of the solution and I would like to share with all of you. I think you are using list box and it would have the blue outline. If you wanted to convert the same then you have to use the choose the desire range on the Excel sheet and simply press the Alt, D, I and V from the keyboard of the computer of yours. so you should try the instruction which I have mentioned over here I am hoping that it would be useful to you.
Looking at the matter I am suggesting following steps which you can use to fix the matter of yours.
First of all you have to sort the list where you wanted to insert the sub total.
Now you have to add the subtotal button on the data tab.
Now choose the field for which you wanted to calculate the sub total.
You have to specify the type of total which you wanted to insert the function from the drop down list
You have to select the check boxes from the field and if you wanted to add the subtotal into the list box.
Now click on the Ok button.
No comments:
Post a Comment