Working Out How Many Periods. You can calculate how many Periods if you know a Future Value, a Present Value and the Interest Rate. Example: you want to know how many periods it will take to turn $1,000 into $2,000 at 10% interest.orking Out How Many Periods. You can calculate how many Periods if you know a Future Value, a Present Value and the Interest Rate. Example: you want to know how many periods it will take to turn $1,000 into $2,000 at 10% interest.
Begin the process by double-clicking the Excel file that contains the cells that you want to resize. Locate the cell that you want to adjust, then right click the column heading at the top of that cellâs column. The column heading is the letter above the spreadsheet. Click the Column Width option, then enter a value into the field. You can enter any value into this field up to 255, but bear in mind that the default value is 8.43, so adjust accordingly. Once you have entered a new value, click OK.
1. Open the Excel table where you need to count cells by color and run the All Colors tool by clicking on its icon. 2. Select the range in your table and you will see its address in the Select Range field.When you count cells by color you can choose a range in Excel that contains both text and numerical values.3. Now you need to define if you want to calculate by fill or font color of the selected cells. 1  Click the Background radio button to count the selected data by the fill color.. Open the Excel table where you need to count cells by color and run the All Colors tool by clicking on its icon. 2. Select the range in your table and you will see its address in the Select Range field.