Latest News & Excel Tips 

Watch, Read & Learn

Latest Excel Tips

How To Insert Sheet/tab Names In a Cell In Excel

Here is an easy way to insert the current worksheet's name into a cellInsert the following formula into any cell and press enter =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) In the below we have called the worksheet Sales Data. The formula above is in...

How to Add a Drop Down list using a Named Range in Excel

Previously we looked at making a simple dropdown list but this can be somewhat limited and time consuming if you need to add more options to choose from for any category. Here we will show you the benefits of using Name Ranges or Dynamic drop downs.Here we have our...

REad

News & Stories

How To Insert Sheet/tab Names In a Cell In Excel

Here is an easy way to insert the current worksheet's name into a cellInsert the following formula into any cell and press enter =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) In the below we have called the worksheet Sales Data. The formula above is in...

How to Add a Drop Down list using a Named Range in Excel

Previously we looked at making a simple dropdown list but this can be somewhat limited and time consuming if you need to add more options to choose from for any category. Here we will show you the benefits of using Name Ranges or Dynamic drop downs.Here we have our...

Let Us Lend a Helping Hand

Call Now Button