The CtrlD shortcut fills data down or to the right through all selected cells. Select all of the cells of the Percentage of Change column and then press CtrlD. This value can be text numbers Boolean values or any other type of data.
To work out the turnout as a percentage you need to enter those into two cells B3 and A3 respectively in Excel then select a third and type the following formula.
Method 2 - Percentage Formatting Through the Format Cells Dialog Box. To convert the B2 value into percentages you need to apply percentage formatting to this cell. C3-B3B3 The brackets around the subtraction part of the formula ensure that calculation occurs first. B4B2 You will see fraction numbers.