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...
Showing posts with label ShortCuts. Show all posts
Showing posts with label ShortCuts. Show all posts
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...
Shortcut to Insert or delete Row or Column in Excel
in ShortCuts
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. ...