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.Ctrl+3 ➡️Puts italics on all cells in the highlighted section.Ctrl+2 ➡️Bolds all cells in the highlighted section.CTRL+1 ➡️Change cells format (Opens Format Cells dialog box.CTRL+Z ➡️Undo last entry/action performed.CTRL+Y ➡️Repeats the last entry/action performed.CTRL+X ➡️Cuts all cells in the selected area/section.CTRL+K ➡️Opens the “Insert Hyperlink” dialog Box (Insert hyperlink).CTRL+I ➡️Change text /Content format in selected cells into italic.CTRL+H ➡️Opens the Find & Replace dialog box.CTRL+G ➡️Open the “Go to” dialog box (Go to any area, cells, or named range).CTRL+F ➡️Find in Current Sheet (Opens Dialog Box).CTRL+U ➡️Underline content in selected cells.CTRL+R ➡️Fill Content of the right cell in the selected cell.CTRL+D ➡️Fills the content of an upper cell in the selected cell.CTRL+B ➡️Bold all Cells in Highlighted Area.CTRL+C ➡️Copy all Cells in Highlighted Area.Alt + Enter: To insert a new line character in a cell without moving to another cell. Ctrl + X: To cut selected cells’ contents and move them to Clipboard. Ctrl + V: To paste content from Clipboard into selected cells. Some of the important shortcut keys for MS Excel are:Ĭtrl + C: To copy the selected cell’s content to Clipboard. Learning them can save you a lot of time and effort when working with spreadsheets. These are just a few of the many useful shortcuts available in Microsoft Excel. If you accidentally delete something, you can press Ctrl+Y to redo it. Another useful shortcut is Ctrl+Z, which undoes your last action. Similarly, the keystroke Ctrl+V pastes the content of the clipboard into the selected cell. For example, the keystroke Ctrl+C copies the content of the selected cell to the clipboard. You can use shortcut keys in Microsoft Excel to save time. There are a few thousand keyboard shortcuts in Microsoft Excel 2013, and that number grows over time as Microsoft adds more functionality to the program. There are a few thousand keyboard shortcuts in Excel 2013, and that number grows over time as Microsoft adds more functionality to the program. For example, when the Office ribbon is displayed, a complete set of shortcut keys is displayed along with the ribbon itself, and you can see what each keystroke does by looking at the ScreenTips that appear as you roll over each button. Keyboard shortcuts are a very efficient way to work in Excel.
#Excel shortcut keys fill color 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.