How to remove comments only from filtered cells in Excel

Consider a column which has number one to five. Cell with odd number has a comment "ODD" and even number as "EVEN".

If you have to delete comments only from even number then, 

- Filter the even numbers in column (i.e. 2 and 4)

- Then, hit the keystroke (Alt + :) this will highlight only the filtered cells

- Then, right click and delete comment from the selected cells in context menu

To apply formats for filtered cells, select all filtered cells and use comments in paste special option to paste only the comments as shown below.

.

Read More

Excel Shortcuts to convert Number into different formats

Excel Shortcuts:

Keyboard shortcuts in Excel allow you to reduce the time spent doing routine task using mouse and thereby boosting productivity.

Below is a list of Excel shortcut keys to convert number into different Time and Date formats.

1) To Convert Number to Date format: Select the range of cells that contain numbers and press             CTRL+SHIFT+3

2) To Convert Number to Time format: Select the range of cells that contain numbers and press            CTRL+SHIFT+2

3) To Convert Number to Percentage format: Select the range of cells that contain numbers and           press CTRL+SHIFT+5

4) To Convert Number to Currency format: Select the range of cells that contain numbers and             press CTRL+SHIFT+4

Read More

Shortcut to Insert or delete Row or Column in Excel

In order to insert a row in Excel, press Alt, I and R. This will insert a row above the active cell.

Similarly, to insert a column, press Alt, I and then C. This will insert a column to the left of the active cell.

To delete a row or column , press Alt, H, D and the R (for Row) or (C for column). This will delete the row or column of the activecell. 

Read More