A
Akshay Bakhai
Bhavesh,
Go to the cell exactly below the cell where you have
typed "plno". So for example, if "plno" is in cell A1
then go to cell A2.
From the menu bar, select option WINDOW followed by option
FREEZE PANES. This will do the trick.
On converting your data to uppercase, you can use the
worksheet formula UPPER.
As an example, if you have in column B all the names; use
a helper column (an empty column). Let's say you use
column H. In column H2 type in the formula =UPPER(B2)
where B2 contains a name. This way in H2 you will have
same name but in uppercase. Copy the cell H2 and paste it
as many cells down as you wish. And you will get all
names in upper case.
If you want to overwrite the existing names; then you must
copy the column H and then go to the column where your
names are currently present and do PASTE SPECIAL VALUES.
After this is done successfully you may delete the
contents of column H.
Best of luck.
Go to the cell exactly below the cell where you have
typed "plno". So for example, if "plno" is in cell A1
then go to cell A2.
From the menu bar, select option WINDOW followed by option
FREEZE PANES. This will do the trick.
On converting your data to uppercase, you can use the
worksheet formula UPPER.
As an example, if you have in column B all the names; use
a helper column (an empty column). Let's say you use
column H. In column H2 type in the formula =UPPER(B2)
where B2 contains a name. This way in H2 you will have
same name but in uppercase. Copy the cell H2 and paste it
as many cells down as you wish. And you will get all
names in upper case.
If you want to overwrite the existing names; then you must
copy the column H and then go to the column where your
names are currently present and do PASTE SPECIAL VALUES.
After this is done successfully you may delete the
contents of column H.
Best of luck.