Access Rights in Excel

Access Rights configuration for users in Excel

Hello Secretive Excel Users, Have you ever wanted to give access to only particular worksheets to some user and hide some worksheets for particular user. Below is the perfect solution you would like to implement. First in step by step with screenshots. Later in Video. Step 1 Create a worksheet called “Access Rights” as below […]

Share

How to TRANSPOSE links to the copied cells?! “Paste Link + Transpose”

Hello Excel Tricky Users, Today I am going to share with you the most effective way to Paste Links while Transposing the Copied cells. i.e. Transpose Links. Actually The it is first important to Understand the Problem. Paste Special Dialogue Box Gives two separate options to paste copied cells i.e. “Transpose” and “Paste Link” as […]

Share
Dynamic Drop Down Excel

Dynamic Drop Down List Excel

Hey Excel Dynamic User, I am going to show you one very important technique to create a Dynamic Drop Down List Excelin cells (of course with data validation but with addition to function “INDIRECT”) with n number of dependency you can create. I have tried to make it shortest and easy to understand with 5 […]

Share
Excel 2003 keyboard shortcuts

Excel 2003 keyboard shortcuts – you should never forget

Hey Excel Shortcut lovers, I am sharing with you some of the important Excel 2003 keyboard shortcuts which are still applicable in Excel latest releases.   You can add to this list with your favorite excel 2003 keyboard shortcut in comments. If you want to get knowing such fruitful and upcoming techniques subscribe to my course […]

Share
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 […]

Share

Subscribe for Newsletter