• IMPORTANT NOTICE: The Excelguru Help Forums will be permanently shut down on Friday, June 26, 2026.

    With AI taking a more prevalent role in answering user questions, the traffic to the Excelguru Help Forums has seen a sharp decrease in traffic over the past couple of years. We do not see this trend changing anytime in the near future. As such, continuing to run the forums is just no longer feasible, so we have made the difficult decision to close them down at the end of the month.

    We appreciate everyone who joined our forums to ask and answer questions over the past decade – and in particular – want to say a huge THANK YOU to the moderators and administrators who volunteered their time and expertise on a daily basis. You made the community what it was.

    NOTE: NEW USER ACCOUNTS CAN NO LONGER BE CREATED.

FORMULA

Dheeraj

New member
Joined
Apr 21, 2026
Messages
1
Reaction score
0
Points
1
Excel Version(s)
M365
after writing the formula in a cell, it works but the drop down menu appears. once you click on this, it looks like this. i am not sure how to fix the drop down menu.
1776738204537.png
 
That's normal for the total row of a table.
 
Back
Top