Forum Discussion
How to Bold Amount in text formula in excel & Subtotal in Table
sorry jpg is also not attached
so i update it mediafire link
https://www.mediafire.com/file/du2lkgp1x91a0cp/sample+file.xlsx/file
As far as I know (even if that doesn't mean much 🙂 in formula you can't format parts differently.
But you can do it with VBA code.
1. Start the macro recorder
2. In a cell, select only the text that should be bold
3. set the bold attribute for the selected text
4. Press the Enter key to complete this process
5. quit the macro recorder
Now you have recorded the VBA code and can adapt it in the VBA editor.
...Or split it into several cells and format the relevant content accordingly.
Insert subtotals in a list of data in a worksheet
Hope I was able to help you with this info.
NikolinoDE
I know I don't know anything (Socrates)
- sorry Subtotal is not work in table
The formula for the subtotal is available in your sheet (Cell E70), you only need to insert a filter in your table and the subtotal is automatically counted.
=SUBTOTAL(109,[Amount])
The formula for the subtotal is available in your sheet, you only need to insert a filter in your table and the subtotal is automatically counted Enclosed the file as it is, only with additional filters, you can filter as you like by column and only the filtered one is counted, or if you do not filter the total sum.
Thank you for your understanding and patience
I wish you much success in your project
NikolinoDE
I know I don't know anything (Socrates)
- Respect NikolinoDE,
My question is that every break page I want subtotal. Example I have 2 pages I want 1st page subtotal and last page I want to grand total. thanks