To find the percentage of each expense, you would divide the
total expenses by the total of each expense category. Right-click
on the cell where you want to display the percentage and format the
cell to display the value as a percent. You also can select the
number of decimal places to display.
If your total expenses are displayed in cell N12 and your office
expenses are in cell N3, put the following formula in O3: =N3/N12.
This will divide the office expenses by the total expenses and give
you a decimal. If Total Expenses are $100 and Office Expenses are
$20, cell O3 will display .2. When you format the cell to display
as a percent, you will see .2 change to 20% (if you format to
display 0 decimal places). If you want to display as 20.00%, then
format to display 2 decimal places.