However, it is different from the previous shortcut because we get some options after using shortcut keys, and then we must choose a desired option from the Insert dialog window. This is another useful method that helps us insert a new column in Excel using the shortcut. Inserting a Column using the shortcut 'Ctrl +' and a 'Dialog Box'. Similarly, if we want, we can also insert a new column in place of other existing columns. The existing column B with the other columns after column B will be shifted to the one column right if present. After this, a new column will be immediately inserted at column B.
We can also select the entire column B by clicking on the column header.Īfter selecting the entire column, we need to press the Ctrl key and the Plus key simultaneously, Ctrl +. Suppose we have the following sheet, and we want to insert a new column at column B by shifting the existing columns to the right side.įirst, we need to select any specific cell in column B and then press the Ctrl key followed by the Space button, i.e., Ctrl + Space. According to this method, we first have to select the entire column we want to shift or before which we want to insert a column by using the shortcut 'Ctrl + Space', and then press the combination of the Ctrl and the Plus key. This is one of the most common methods of inserting a column in Excel with the help of shortcut keys. Let us understand each shortcut in detail, including the example: Inserting a Column using the shortcut 'Ctrl + Space'.
Some of the essential shortcuts for inserting a column in Excel are listed below: We use Excel 2013 for example purposes during this article however, the shortcuts also work in other Excel versions accordingly.
This article discusses some common shortcuts that help us know how to insert a column in Excel quickly. Therefore, we must learn the Insert Column Excel Shortcuts to speed up the overall work process and increase the overall productivity of Excel. Although we can easily insert a column(s) in Excel by using the ribbon options or by right-click menu, it is always better and faster with the shortcuts. There are many shortcuts in Excel, including the Insert Column shortcut, which helps make our work fast and convenient. Additionally, inserting a new column in the existing Excel sheet also helps us add new or missing data between the existing columns. We often need to insert a new column to add more and more data to our worksheet.
Please send us your comments on this article.Next → ← prev Insert Column Excel ShortcutĮxcel allows us to work with vast amounts of data. Multiple cells that are far from each other are now highlighted in yellow. Press ↓ (Down Arrow key) several times to select the distant cell you wish to highlight yellow. Highlight multiple cells that are far apart in yellow Multiple contiguous cells are now highlighted yellow. Use the ↓ (Down Arrow key) and → (Right Arrow key) to select Yellow. Press Shift + ↓ (Down Arrow key) to select multiple cells you wish to highlight yellow. Select one of the multiple cells you wish to highlight yellow. Highlight multiple contiguous cells in yellow
The selected cell is now highlighted yellow. Select the cell you wish to highlight yellow. See below for instructions on how to highlight a cell yellow using shortcut. None Use shortcut to highlight a cell yellow Here are shortcuts for highlighting a single cell yellow and for highlighting multiple cells (including distant cells) yellow. However, you can easily highlight a cell yellow by using a shortcut. To turn a cell yellow, most people would select the cell with the mouse and highlight it yellow. If you want to explore a particular cell in Excel, it is useful to highlight that cell yellow. Written in Excel for Microsoft 365 version 2202.Excel shortcut highlight cell yellow - Excel Hack Excel shortcut highlight cell yellow