Posts

Showing posts from September, 2017

Unbrick or Recover Xiaomi Redmi 10A and other MTK devices

Case: Your Redmi 10A (probably other MTK devices too) is not turning on and doesn't react to any button pressed nor cable connection. Requisites:   Dead phone USB Cable  You tried tons of tutorials to unbrick the phone and didn't work This image Willingness to even use Linux to fix it (it's not hard) Steps: Create a bootable USB using the image downloaded. Make sure your computer allows booting from USB. Boot the computer from the bootable USB. When booting, a list of options will be shown. Pick the first one: Boot Live system. Once the system is loaded, go to the right-upper corner to connect to Wi-Fi. Once you have internet, use the Firefox browser (click on the icon in the left-upper corner) and download the Linux version of this tool (SP Flash) and save it in the desktop. Unzip the tool downloaded. Download the fastboot version of the stock ROM . Unzip the ROM, to have the folder and files. Click on 'MTK' icon that is in the desktop. In the command line opene

Preventing Excel File to Open or Edit with Password

Image
When you have an Excel file and don’t want everyone to open or edit it but only specific people then you could protect the file with a password. To do this, you have to use the ‘Save As...’ option and select ‘Browser’:   In the typical window to save the file, go to ‘Tools’ option and then select ‘General Options...’:   With that selection, you will be able to set a password that will be asked when opening or editing the file, without the right password the file will not open or edit:   This is the popup that will appear to anyone after setting the protection:   Also, you can use this option to set a recommendation when opening the file to use it as read-only, to do this just check the box ‘Recommend as read-only’ located under the password box, then when opening the file will always show this:      This read-only function can be used without setting a password.

Fixing Excel When Scrolling Sheet Instead of Moving Cell Selector

Image
When you have in Excel your cells like this:     And use the arrows on the keyboard to move to the right, for example, you will move the cell selector to the right cell:     However, I have seen that in some cases the result is not that, instead, when pressing the previous key the entire spreadsheet is scrolled to the right, with the cell selector staying in the same place:       This happens when the ‘Scroll Lock’ in pressed in the keyboard, then to fix it just press it again, but nowadays many keyboards have no this key, therefore, to fix this situation you should use the keyboard on screen, to open this keyboard in Windows go to ‘Start’ and search for ‘On-Screen Keyboard’, once you select it you will see this:   You see that the ‘Scroll Lock’ key is highlighted, click on it to disable this function and close the keyboard, now you recovered the usual behavior of the arrows keys in Excel.