Excel shift cells right keyboard shortcut

#Excel shift cells right keyboard shortcut how to#

We could use the click-and-drag method on the data below, but if there were thousands of rows, it could take a long time. On the Developer tab of the Ribbon click the Stop Recording. From the Insert menu choose Cells and choose Shift Cells Right in the Insert Dialog then click the OK button. Click OK to close the Record Macro dialog. Optionally, type a more complete description of your macro. Sometimes it will be easier to use Excel Shortcut Keys for data selection. In the Record Macro dialog, assign your Macro a Shortcut. Excel Shortcut Key to Select a Whole Data Set Ctrl+A, Selects the entire worksheet or the current data region (the rectangular region containing filled cells around the active cell). On a MAC, use the Command key instead of the Ctrl key.

Hold down the CTRL key and select the second set of rows/columns.

As a result, a column of new cells is added, and the current data is shifted to the right. In the Insert dialog window choose Shift cells right and press the OK button. From the drop-down menu, (2) choose Insert. Selecting non-adjacent rows or columns is easy. First, (1) select the cells that you want to shift right, then right-click. Selecting Non-Adjacent Rows or Columns of Data They are available in Excel 2019, 2016, 20. Surprisingly, these shortcuts are not new. Still others are unaware of the shortcut keys that can make data selection easier than the click-and-drag method.

#Excel shift cells right keyboard shortcut how to#

However, I have found that a lot of people have no idea about how to select non-adjacent rows or columns of data.

Most people find it easy to select data in Excel by clicking and dragging the mouse. Free Agile Lean Six Sigma Trainer TrainingДЇree Excel Tips В» Excel Data Selection with Shortcut Keys Excel Tips - Data Selection with Shortcut Keys Save Time on Data Analysis Using These Easy Shortcuts.In some environments you may see the selection box (border) around the column change to an I-bar. Animated Lean Six Sigma Video Tutorials Best Answer If youre not set on using the keyboard only, highlight the column, either by Ctrl + Space or clicking on the column header.