Someone has told me that you are able to add the remainder of a percent by double clicking a cell but that someone forgot how to do so.
For example, say you have a column with the following numbers
30%
20%
10%
0%
10%
You want the 5 boxes to add up to 100%. I heard that there is a trick, where...