Excel Tips 29 - Disable the Quick Fill Handle and Drag and Drop in Excel

Опубликовано: 04 Октябрь 2024
на канале: TeachExcel

11,794

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

This Excel Video Tutorial shows you a trick in Excel that allows you to turn off the quick-fill handle and the drag and drop feature in Excel. This is a neat thing you can do to fool-proof your spreadsheets that need to be distributed out to other people. As well, this could be used to simply annoy your co-workers or friend.

The one thing to note is that when you turn this feature off, it will be turned off for all of the Excel spreadsheets on the computer.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!