Monthly Archives: January 2015

How to Change the Sheet Size from Publisher

Microsoft Publisher is a great program which can publish items like magazines, sheets or other materials. Here is the instruction to tell you how to change the sheet size on Microsoft Publisher .

s147149_L

1. Start Publisher. Click “File” —-“Open” to open the file you want to change the sheet size. The “Page Navigation” can open on the left side of the screen to show all of the pages in the document.

2. Click the “Page Design” tab, and then click the “Size” button below the tab.

3. Here you can choose one of the pre-set sheet size options or just click “Page Setup” to enter your custom dimensions.

4. Increase the page size may make the document smaller, and reduce the page size may add pages. Items such as text boxes and images may have shifted with the sheet size change. Publisher automatically resizes the pages.

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.