Skip to main content

Posts

Showing posts from March, 2017

How To Prevent Users From Deleting Rows and Columns in Excel | MS Excel Tips & Tricks | dptutorials

Hello Friends, In this video tutorial we will see how we can prevent users from deleting rows and columns in Excel Sheet. This is the smart way of creating the access control on your spreadsheet trackers, reports, dashboards other than the normal routine method of protecting the entire worksheet/spreadsheet. If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. ********************************************************************************* Read my full article on this: http://ift.tt/2kB14dh Subscribe for more Awesome Tutorials: goo.gl/4T8ePc Support The Channel via shopping: http://ift.tt/2jH38PR You Can Connect With Me at G+ :  http://ift.tt/2kAOpa6  Twitter :  https://twitter.com/dptutorials15  Facebook :  http://ift.tt/2kfRnDi  Blogspot :  http://ift.tt/2kB14dh

How To Unhide Multiple Sheets In Excel Quickly || MS Excel || Excel Tips || dptutorials

In this Tutorial, Let us see How To Unhide Multiple Sheets In Excel Quickly, with a single click. copy the code mentioned below and paste in the view code sheet and then Run to unhide all the hidden sheets Sub Unhideallsheets() For Each Wrksheet In ActiveWorkbook.Worksheets Wrksheet.Visible = True Next Wrksheet End Sub  For Personalized detail learning, write to  dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *************************************************************** Read my full article on this:  http://ift.tt/2kB14dh *************************************************************** Subscribe for more Awesome Tutorials:  goo.gl/4T8ePc *************************************************************** Support The Channel via shopping:  http://ift.tt/2jH38PR **********************************

How To Create Sparklines in Excel || MS Excel || Win-Loss Chart || Tips and Tricks || dptutorials

Sparklines are types of graphs that show trends and variation of data. Sparklines are awesome and quick to create. This even saves space and can be used for rough estimations. For Personalized detail learning, write to  dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *************************************************************** Read my full article on this:  http://ift.tt/2kB14dh *************************************************************** Subscribe for more Awesome Tutorials:  goo.gl/4T8ePc *************************************************************** Support The Channel via shopping:  http://ift.tt/2jH38PR ************************************************************** You Can Connect With Me at G+ :  http://ift.tt/2kAOpa6 Twitter :  https://twitter.com/dptutorials15 Facebook :  ht