Category Archives: How To

How to Back Up Boot Configuration Data

The Boot Configuration Data (BCD) is information used to boot the Windows operating system when you start up your computer. But as we always said, backup your data before it’s too late. So Here is the instruction to tell you how to back up your Boot Configuration Data before you change its information.
1. Click the “Start” menu and type “cmd.” Click “Ctrl”+ “Shift” +”Enter” at the same time. Click “Yes” to open the dialog. A command prompt will appear.

1

2. Type the following command into the command prompt and press “Enter”:

bcdedit /export C:\bcdbackup

2

 

The following message reading will appear when your backup is complete:

“The operation completed successfully”

 

3. Close the dialog. Go to C: disk and you could find your Boot Configuration Data backup file stored there.

How to Lock the Entire Worksheet in Excel

Microsoft Excel need some adjustment to get the data to display or print correctly on a page.

To prevent these changes, you can lock the worksheet so that other users can’t add or delete rows or columns, or make any other changes to the formatting. Here is the instruction to tell you how to lock entire worksheet in Excel.

excel1

1. Highlight the spreadsheet only with the data you need to lock.

2. Right-click and then select “Format Cells.”

3. In the Format Cells dialog box, select the “Protection” tab and keep the box next to “Locked” is locked. Click “OK” to close it.

4. Select the “Review” tab on the Excel toolbar, and then click “Protect Sheet” in the Changes group.

5. Here if you want to protect your worksheet better, you could enter a password or just leave the password field blank is also OK.

6. Click “OK”. Now you’ve successfully lock the entire worksheet so that no users can alter the widths of the columns and rows.

How to Lock Pivot Table Size in Excel

Microsoft Excel is a great program, it would need some adjustment to get the data to display or print correctly on a page. However, some little changes in size will break the whole layout if the data is a tight fit. In case the wrong this happened, we need to lock the table. Here is the instruction.
excel1

1. Run Excel program by double clicking the icon.

2. Right-click any cell in a pivot table and select “PivotTable Options.”

3. Select the “Layout & Format” tab.

4. Keep “Autofit Column Widths on Update” unchecked.

5. Click “OK” to save the change.

6. Now Excel will no longer adjust the column width for this pivot table when the data changes.