Entering percentages

How to enter percentages in Excel?
When I format cells as percentages, the exact percentages don't show up. They get multiplied by 100.

To convert a number into percentage,
RIGHT CLICK->FORMAT CELLS->NUMBER->PERCENTAGE and CLICK OK.
You can also specify the number of decimal places to follow percentage.

Tip:

It is always advised to format cells as percentage before you enter values. This is because if you enter your values and format it to percentage, they get multiplied 100 since cent percentage is equal to 100. For example, if you enter the number 4 and format cells as percentage, you get the value 400%. But if you format the cells as percentage and enter 4, you get the value 4%.You can also enter decimal values if you format the cells prior to entering values.

Delete columns

How to delete columns in Microsoft Excel?


To delete rows RIGHT CLICK->DELETE->ENTIRE COLUMN
Alternatively, you may select the column you want to delete and EDIT-> DELETE->ENTIRE COLUMN. (This is not at all a shortcut)

If you want to delete column in a single click, you should

• Select the entire column
• RIGHT CLICK ->DELETE

If you want to delete more than one column in a single click just follow the above steps ,by selecting a range of cells, rather than a single cell.

You can also repeat deleting columns by pressing CTRL+Y. But to use this option you must have deleted the column from the EDIT menu.

Also see,
Delete rows
Insert columns
Insert rows

Delete rows

How to delete rows in Microsoft Excel?


To delete rows RIGHT CLICK->DELETE->ENTIRE ROW.
Alternatively, you may select the column you want to delete and EDIT-> DELETE->ENTIRE ROW. (This is not at all a shortcut)

If you want to delete rows in a single click, you should

• Select the entire row
• RIGHT CLICK ->DELETE

If you want to delete more than one row in a single click just follow the above steps ,by selecting a range of cells, rather than a single cell.

You can also repeat deleting rows by pressing CTRL+Y. But to use this option you must have deleted the column from the EDIT menu.

Also see,
Delete columns
Insert columns
Insert rows

Insert Columns

How to insert columns in Microsoft Excel?
How to insert more than one column at a time?

To insert rows, select the cells above which you want to insert rows. Go to the INSERT menu and select COLUMNS. Alternatively, you can RIGHT CLICK->INSERT->ENTIRE COLUMN to insert a column.
If you want to insert column in a single click, you should

• Select the entire column
• RIGHT CLICK ->INSERT

If you want to insert more than one column in a single click just follow the above steps ,by selecting a range of cells, rather than a single cell.

If you insert a column it is normally inserted to the left of the cell. So if you insert a column from B2 it would be inserted to the left of B2

You can also repeat inserting columns by pressing CTRL+Y. But to use this option you must have insert column from the Insert menu.

Also see,
Insert rows
Delete rows
Delete columns

Insert rows

How to insert rows in Microsoft Excel?
How to insert more than one row at a time?

To insert rows, select the cells above which you want to insert rows. Go to the INSERT menu and select ROWS. Alternatively, you can RIGHT CLICK->INSERT->ENTIRE ROW to insert a row.
If you want to insert row in a single click, you should

• Select the entire row
• RIGHT CLICK ->INSERT

If you want to insert more than one row in a single click just follow the above steps ,by selecting a range of cells, rather than a single cell.

If you insert a row it is normally inserted above the cell. So if you insert a row from B2 it would be inserted above B2.

You can also repeat inserting rows by pressing CTRL+Y. But to use this option you must have insert row from the Insert menu.

Also see,
Insert columns
Delete rows
Delete columns

Font size

What is the maximum font size in Excel?
What is the minimum font size in Excel?
Can I use decimal in font size?

The minimum font size available in Microsoft Excel is 1 point and the maximum size is 409 points. Thus the font size may range anywhere from 1 to 409 points. As regards decimal, you can use font sizes in multiples of 0.5(e.g)1.5,2.5,3.5 etc., You can only use one decimal point and if you use more than one decimal points its rounded off. Same is the case for other decimal values. Thus if you enter 12.3 then font size is rounded to 12.5 and when you enter 12.73 then it is rounded as 13.
It should be noted that the font values should be directly entered into the font size box and cannot be selected from the dropdown box since the dropdown box contains only standard font sizes.