Duplicate the data from the first column of the selected range down. Suppose you want to bring this information together though. You can also assess which vendor is more reliable by sending an an email question to the two companies and check which vendor replies without delays. For example, when I deleted a category called Asset Sales from the Income section, Excel automatically deleted the Asset Sales section of the formula that calculated total income. Select dropdown list, without switching tabs and numbers spreadsheet programs in your document with authentication for. Plus, you may need one of the advanced features for calculating something in Excel or formatting a report in Word.