Learn how to save webpage as PDF in Chrome, Edge,Firefox browsers.,. It is a straight forward method that enables to save whole website page into single PDF file.
How to Replace #N/A with 0 in Excel or blank – Simple Formula?
How to replace #N/A with 0 or blank in Excel formula. Formula like Vlookup returns such errors & this Excel function can rectify these NA errors.
Outlook VBA – Sort Emails by Date – in a Folder
Get Outlook vba code to sort emamils by date in the inbox or in any folder. This code can sort the emails by oldest first/newest firlst as per your choice.
New Update – Very useful for Whatsapp Web Users
Learn how to use Whatsapp Web without keeping your smartphone online with the latest update from Whatsapp team itself.
How to remove Drop down list in Excel?
Learn how to remove a drop down list in Excel using these simple steps. This trick is a quick shortcut just by using copy paste method.
How to create drop down list in Google sheets – 7 Easy steps?
Learn how to create drop down list in Google Sheets with this step-by-step guide. Utilize the data validation built-in option, choose a range or list of values, and select an action for invalid data. Improve user input validation and save time with this useful feature.
VBA Unhide all Sheets in Excel or with their Name – VeryHidden Worksheets
Learn VBA to unhide all sheets in a Excel workbook. This code sets visibility property of sheet to unhide even the very hidden sheets.
VBA Userform – Escape key to Close – Unload form
Learn how to close a vba userform with escape key. Map command button to Exit or Close a Userform with Escape key.
VBA to open or save Word document Protected or Encrypted with password
Use this VBA code to password protect or unprotect the Word document while openening the file. This macro also handles readonly protection, Write protection etc., right within the code itself.