Now place your cursor in cell B2 and write the following formula: Now take your cursor to the bottom-right corner of cell B2 and when it converts to a plus sign, click and drag it to cell B11.