Splitting excel into 4 areas.

Guys, the figure below is not any photoshop work, it is the faeture of Microsoft Excel.

Freeze and Unfreeze panes in Microsoft Excel

This will make certain columns or rows freeze or fixed in Microsoft excel. Suppose you want to stroll on the large page of excel without going away from the first column(certain column). In other words, you need to view other columns or rows with respect to a fixed row, then you can use freeze and unfreeze in excel.
To freeze and unfreeze,

How to create a hyperlink in excel work sheet

1. select the cell in which you want to create a hyperlink

How to Auto-Increment/Auto-decrement Numbers in Excel in any series

1. select the cell from which you want to start the series or where the incrementing should start

Basic shortcuts in Microsoft Excel

Some of the important and basic Microsoft excel Keyboard short-cuts are listed below:

How to enter a single value/formula in multiple excel cells?

If you want to enter the same value in many cells in excel, the easiest way is -

Paste/write multiple lines in an excel cell.

To Paste:
1. Chose the cell, press F2 and Ctrl+V

How can you select select the whole data in a particular row(s) or column(s) in excel sheet that have thousands of data?

1. Chose the cell in the edge of the data
2. Press Shift or Ctrl and select the rows or columns you want

How to make the rest of the unused table as blank or white in excel?

This is very simple and it makes the sheet attractive.
1. Just go to page layout tab, Align, and select View Gridlines

How to paste a row as colomn and vice versa in Excel Sheet?

1. Copy the row/column from the source
2. RightClick the cell you want to start pasting
3. Select special paste option
4. Select Transpose

Note: You can select any style of pasting according to your need