Ctrl+Shift+& ➡️Places border around selected cells.Ctrl+Shift+* ➡️Selects the current region around the active cell.Ctrl+Shift+* ➡️Applies exponential formatting.Ctrl+Shift+% ➡️Applies percentage formatting.Ctrl+Shift+# ➡️Applies date formatting.Ctrl+Shift+$ ➡️Applies currency formatting.Ctrl+Shift+! ➡️Applies comma formatting.
Ctrl+Shift+~ ➡️Switches between showing Excel formulas or their values in cells.Ctrl+Shift+= ➡️Inserts anew column or row.Ctrl+- ➡️Deletes the selected column or row.Ctrl+Shift+” ➡️Copies value from cell above.Ctrl+ ➡️Copies a formula from the cell above.Ctri+ ➡️Changes between displaying cell values or formulas in the worksheet.Ctrl+Shift+: ➡️Enters the current time.Ctrl+5 ➡️Puts a strikethrough all cells in the highlighted rl+5: section.Ctrl+4 ➡️Underlines all cells in the highlighted section.
#WHAT IS EXCEL SHORTCUT KEYS PLUS#
In this post I will share Keyboard Shortcut in MS Excel, you will find 100 plus keyboard shortcut keys for Microsoft excel. Today, it is one of the most widely used business application software. Microsoft created Excel back in 1985 as a spreadsheet. Microsoft Excel is widely used in organizations for various purposes and it is most important in the office.