Freeze rows or columns in MS Excel or Office 365 Sheets

 Freeze rows or columns

Sometimes you want to freeze certain rows or columns or even an area in Excel sheet that you do not want to move while scrolling the sheet on left, right, up or down. Here is what you need to do - The Freeze Pane feature!

Freeze the first column

• Select View > Freeze Panes > Freeze First Column.

            The faint line that appears between Column A and B shows that the first column is frozen.

Freeze the first two columns

1. Select the third column.

2. Select View > Freeze Panes > Freeze Panes.

Freeze columns and rows

1. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.

2. Select View > Freeze Panes > Freeze Panes.

Cannot Start Microsoft Outlook. Invalid XML, the View Cannot be Loaded

One way your Outlook blocks you from accessing emails is when it Cannot Start Microsoft Outlook. Invalid XML, the View Cannot be Loaded" Error Message. The cause is also simple and more is its fix.

Follow the following steps below to clear and regenerate your Navigation Pane if you receive an error message that says "Cannot start Microsoft Outlook. Cannot open the Outlook window. Invalid XML, the view cannot be loaded."

Problem:

When opening Microsoft Outlook Windows client, you receive the following error:

"Cannot start Microsoft Outlook. Cannot open the Outlook window. Invalid XML, the view cannot be loaded."

Opening Outlook in SAFE mode does not help, nor can this problem fixed by running repair or even by re-installing Outlook.

Fix:
To fix this error, run the Outlook.exe  /ResetNavPane command:

Where to run:
Hold the Windows key and the R key at the same time.
The Run command window will open. Copy Outlook.exe  /ResetNavPane into the text field.
Click OK to run the command.

What happens:
Running this command clears and regenerates the Navigation Pane for the current profile, removing all shortcuts and favorite folders from the Navigation Pane.


Its time for a cheers ;)
Enjoy.