- First, open the rate sheet you wish to convert the rates for.
- For this example, we'll add a 20% markup to the rates. In an unused column enter a value of 1.2 into one of the cells.
- Copy the value of the cell you've entered 1.2 into.
- Select the values of the Peak Rate, Offpeak Rate and Weekend Rate columns.
- Right-click the selection and click Paste Special to open a dialog window.
- Click the Multiply option and then click the OK button to complete the process.