Excel Codes

Codes
How to write    X2   Or    H2 in EXCEL 
	
Select characters in a cell or cell range that you'd like to format. On the Home tab, in 

the Font group, click the Font Settings dialog box launcher. Press CTRL+1. Under 

Effects, check the Superscript or Subscript box, and click OK.


OR



// Short cut command to apply x square in excel
Press Alt + 0178
To set sequence of Number in Excel Automatically
In the first cell of the range that you want to number, type =ROW(A1).

The ROW function returns the number of the row that you reference. For example, =ROW(A1) returns the number 1.

Drag the fill handle Fill handle across the range that you want to fill.
To set sequence of Number According to our Requirement
Let say we want to make a series of number like 11041,11042,11043 .......... 11060
Type 11041 in first cell.

Type 11042 in second cell.

Now, press shift key , holding them and select both the cell

Drag the fill handle Fill handle across the range that you want to fill.
A4 Print setting in EXCEL
Free Web Hosting