MS Excel Tricks

To Replace the columns

Select the column you want to replace >> Press Ctrl+x

Then select the column you want to move >> press ctrl+shift+=

How to write 1st, 2nd, 3rd in excel?

Write 1st >> select it >> press ctrl+1 >> click on superscript >> ok >> drag the column.

How to make the height of the row and column the same?

Select the required rows >> Press Alt +H +O+ H

Calculate GST in Excel

Select the cell >> pres = >> select the amount >> press* >> then type the %amount >> press enter

shortcuts in Excel

1. To check spelling>> press f7 >> check>>ok

2. Current date >> press Ctrl+;

3. Current time>> press Ctrl+shift+;

4. Ribbon hide/unhide>>Ctrl+F1

5. Chart insert>> press Alt+f1

6. Free the upper row - Alt + WFR

7. Unfreeze the upper row - Alt + WFF

Data Entry form

Select the data >> Press Alt+d+o

Repeat the last action- press the f4 key

Show formula - Ctrl+ tilde button

How to fill data in the required column

Ex: Arun,32, student

This is to put in the column- name, age, occupation

Select arun>>copy>>paste in name colum>> enter>>Ctrl+e

The column will be filled. Do this for other columns

Convert month numbers into month names

write numbers in 1 to 10 columns. >> then in 2nd column 1sst row, write =text(date(2023(year), A2(cell no),1),"mmmm" >> enter . drag the 1st cell. all the numbers will be converted to months.

After deleting a row, the serial numbers will be in series

Select the serial nos column >> delete >>in 1st column put the formula >> =row()-1 >>enter >> drag from corner

Count the Absent/ Present from the attendance sheet

Use the count formula ---ex: =countif(c3:13,"p") >> enter

Arranging data in ascending/descending order

For Ascending order >> Click on the 1st column >> Press Alt + ASA

For Descending order >> Click on the 1st column >> Press Alt + ASD

Ms Excel Tricks(2)