In this tutorial I’ve created a formula that can retrieve a list of items, repeat that list, and automatically adjust if items are added to or deleted from that list. You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner. […]
Tag Archives | Autofill
Sometimes AutoComplete just doesn’t do the trick to make it easy to fill in data from a long list. Here’s a great alternative…..
Here is an option in Excel that allows you to fill the entire width of your cell with whatever you type into it…..
Several more options are available if you use your right mouse button when autofilling in Excel…..
Here is how you can sort a range of data based on the order you create in a custom list…..
Here is how you can use custom formatting in Excel to fill the balance of your cell with a character…..