Let us say that we want to create a report of tax rates for different states. Launch Excel and open a blank sheet. Name the table as shown in the image and enter the values corresponding to the names.

Adding Values in Two Different Rows in Excel. ... Click the "fx" formula field at the top of the worksheet and enter your desired formula or string.