Select ‘Data Validation’. Here you can still adjust the cell range if you UK B2B List want and then you can set the criteria. In this case I choose ‘List based on a range’. Next to it you can enter a range. You can manually enter the references, but I click on the blocks to select the data range. Then go to the tab with the list and select UK B2B List the cells you want to use (click on the first cell, hold down Shift and click on the last cell to choose the whole list). You will UK B2B List then see in the box ‘Select a data range’ for example: [name tab]!B2:B5. Then click OK. Make sure ‘Show dropdown menu in cell’ is checked and click ‘Save’. Create Spreadsheet dropdown list with data validation.
To Your Advantage UK B2B List
Now you see in the tab that you can choose names for UK B2B List your social planning. Useful! You can also automatically assign colors to these cells with conditional formatting with the first tip in this article. Create Spreadsheet dropdown list for your schedule. You can also use this option with lists to show the status of UK B2B List a project (for example: to do , in progress, on hold , ready) and again with conditional formatting the colors adjust the cells. Then you can see the status of your projects at a glance. 5. Load data from another tab Do you want to bundle data from different tabs UK B2B List of your spreadsheet into one sheet? Which can! Select the cell where you want to load the data.
Tools More UK B2B List
For example: =’Planning content marketing’!B4 6. Get data from UK B2B List another spreadsheet Let’s say you work closely with the marketing team as a social media manager, but they have UK B2B List their own schedule in which they keep track of their campaigns. You may also want to be able to easily UK B2B List see this in addition to your own planning. Or maybe you, as a content marketer, want to see the current sales figures of products and be able to load them from another spreadsheet. Then you can use the importrange function.
