Most Powerful Excel Keyboard Shortcuts + Excel Shortcut PDF

Hey Excel Shortcut savvy guys, Have you ever removed all the filters applied in separate columns with a shortcut? Many of us might not have done so instead they would be removing filter from the data and again applying filter. I was doing this long exercise upto few years back. But from 2007, we have […]


How to create drop down in Microsoft Excel?

Hello Excel Lovers, In this animated GIF below, I have shown how to create drop down list in cells in Microsoft Excel with Data Validation Function. Share your views on this trick and how it helped you at your work in comments! To Subscribe to the courses go to Courses page and be effective user […]

Lock Format Painter

Have you ever double clicked Format Painter in Excel!!!

Hello Excel Enthusiasts, You all must know the use of Format Painter brush. But have you ever double clicked the Format Painter i.e. locked the Format Painter Mode. Press Escape to switch off the Format Painter Mode. I am sure once you learn and experiment this trick, it will save a lot of time in […]


Welcome to the XLGURU Blog

Hi there,   Welcome to my blog on   Here you can find solution to your queries on Excel and learn new and time saving techniques in Excel.   Enjoy Excelling….!!   DJP


Subscribe for Newsletter