How to Calculate Percent Without Formula | How to Add Multiple Column Without Formula 😲🤪

2 years ago
2

You can also do many operations in excel without an excel formula. Let's know how to do addition in excel and calculate the percentage of the total without a formula.

#excelformula
#excel
#exceltips
#exceltutorial
#excelshorts
#excelshortcuts

1. How to Add Multiple Columns and Rows without a Formula in excel.

Just Select all Data with the "Ctrl" key and now Press the Alt = from your keyboard and all the data will add and set to the desired cell.

2. How to Calculate % in excel without Formula.

Select the column or row and click on the data shorter showing the right corner of the selection. Now Click on the Totals and then % Total.

It will calculate the percentage from your data.

Loading comments...