Forgot bit locker pin, forgot bit locker recovery key, 5 Easy ways to fix

-
Image
 Did you forgot your bit locker pin and recovery key. Try these methods, I hop it help you. 1. When you see this screen, Press "Esc" key in your keyboard for more recovery option. It will say preparing BitLocker recovery, You will see the screen bellow in few minute. Here we will click on "Skip the drive", You will see the screen bellow. Here you need to Turn off your PC, and then enter the BIOS of your PC. In order to enter BIOS, check for your PC brand and model and search on google, how to enter BIOS for your particular brand and model of your PC. Search for "Secure Boot" Enable it and check it, if it works for you. If it do not work, come back to same place and Disable "Secure Boot" and try again, see if it work for you. 2. If the above method do not work for you, try resetting your PC, You can choose any of the two option for resetting your PC, "Keep my files" or "Remove everything" whichever works for you. 3. If the abov...

How to Expand Columns and Rows in Excel

-

The EXPAND function is a new dynamic array function introduced in Excel 365. It is used to automatically expand an array formula output range based on the number of rows and columns returned by the formula.

Syntax: EXPAND(array, [rows], [columns], [pad_with])

Here, 

·        array: The array or range of cells to drop rows or columns from.

·        rows: The final number of rows after being added

·        columns: The final number of columns after being added

·        pad_with: Value to use for new cells (optional)

Suppose you have a table of data in cells A1:E5, and you want to add two more columns and last two rows. You can use the following formula:

How to Expand Columns and Rows in Excel

This formula will return a new array with two rows and two columns added with the original range. For matrix calculation in Excel, this function is used.