Table of Contents
1️⃣ Calculate the Sum Using Quick Analysis
📌 Steps:
- Select the data range (B2:E3).
- Click on the Quick Analysis tool (or press
CTRL + Q
). - Click on Totals → Sum to get row-wise and column-wise totals.
2️⃣ Calculate the Percentage Using Quick Analysis
📌 Steps:
- Select the total values you just calculated.
- Click on the Quick Analysis tool (
CTRL + Q
). - Choose % (Percentage) under the Totals section.
- Excel will automatically calculate and format percentages.
✅ Now, Excel quickly shows both the sum and percentage with just a few clicks! 🚀