Office Solutions

How to Write Protect Specific Cells or Formulas in Your Worksheet

It is natural that all of us want to protect cells with important values. In this article, we will explore the feature of cells protection in Excel. The cells protection in Excel will take effect when the worksheet is protected. You can lock a cell or hide a cell to protect it. But the different options will take different effects, which depends on whether the value in a cell is an ordinary content or a formula. Therefore, in the following sentences, we will find how the cells protection...

Read more »

4 Effective Methods to Zoom Your Excel Worksheet

The necessity to zoom Excel worksheet will come out at any time. Here we will introduce 4 effective methods to zoom Excel worksheet. Sometimes you will zoom in an Excel worksheet to arrange its interface. And sometimes you will zoom out the worksheet to check certain values. Now we have 4 methods to fulfill this task. Method 1: Use IntelliMouse When you scroll the wheel of mouse, the worksheet will move upwards or move downwards. But here you can use the wheel to zoom the worksheet. ...

Read more »

How to Create a New Mailbox in Exchange Management Shell

In this article we are going to see how to create a new mailbox in Exchange 2010 server using Exchange Management Shell (EMS). Introduction: In previous article, we have learned how to use Exchange management console to create a new user mailbox. Today we are going to see how to create a new mailbox using Exchange management Shell (EMS). Usually EMS will be very helpful for doing the tasks in bulk. We can execute Exchange PowerShell scripts in EMS. It will be helpful to recover any user data,...

Read more »