38066 or higher, and you'll have that ability at your disposal. And so is the ability to rename worksheets after queries! All you need is Monkey Tools version. This is also a "Forever Free" FeatureĪs mentioned in my last post, while the DestinationSleuth's colour highlighting is only available in the trial and pro versions of Monkey Tools, the ability to Change Multiple Load Destinations at Once is a "forever free" feature. In this example, we want to rename Sheet1. If you want to insert a new sheet into the middle of your list of worksheets, click Insert in the Home tab of the Ribbon, and select Insert Sheet: This will create a new worksheet to the. It will always be the right-most sheet in your workbook. We'll change the Load Destinations, creating the worksheets AND naming them to match the query in one step. To rename a sheet, simply right-click on the name of the sheet that you wish to rename. Click that button, and you’ll get a new worksheet with a name like Sheet2 or Sheet5.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |