In the very last cell you select, type in your data.Select all the cells where you need the same data filled in (use CTRL + click to select individual cells that are spread across the worksheet).Your natural instinct would be to copy-paste over and over again. Enter The Same Data Into Multiple CellsĪt one point, you may find yourself needing to enter the same data into a number of different cells. So use the appropriate option for your data:Ĥ. There are specific options for different sources. Instead, use the options from the Get External Data option under the Data tab. The trick is importing that data properly so you can create Excel drop down lists or pivot tables from it.ĭon’t copy-paste complex data sets. The benefit of using is Excel is that you can combine different types of data from all kinds of sources. You can also use CTRL + SHIFT + * to select your entire data set.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |