Editing xls is fast and straightforward using DocHub. Skip downloading software to your laptop or computer and make adjustments using our drag and drop document editor in just a few fast steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and powerful features that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and email documents for completion to other people. All of this, put together with a competing price, makes DocHub the perfect option to rub out personal information in xls files effortlessly.
Make your next tasks even easier by converting your documents into reusable templates. Don't worry about the security of your data, as we securely keep them in the DocHub cloud.
hello and welcome to another episode of excel learning series with syed in this brief episode i will show you how to hide sensitive data and protect it in excel to follow along with me make sure you have a copy of this workbook downloaded using the link in the video description there are two worksheets on this workbook see it is where i will demonstrate do it is for you to practice let us start what i really want to do in this sheet is i would like to hide that salary figures and protect it but at the same time i would like to show the number of digits in that salary for example itamp;#39;s a five figure salary or a six figure salary whatever it is how do i do it let me copy this salary column here in the column l to get the job done i have this function called rept this function will repeat a given text for a given number of times letamp;#39;s take a look i will start typing in the function in column l r e p t thatamp;#39;s the function i will press tab to complete it now w