Quick Links

• Selecting Non-Adjacent Cells, Ranges, or Objects

• Selecting a Large Range of Cells

• Duplicating the Selection (And Overriding Existing Data)

• Moving the Selection (And Inserting It Between Existing Data)

• Duplicating the Selection (And Inserting It Between Existing Data)

Many people prefer working in Microsoft Excel using mostly their keyboard, while others enjoy using their mouse. However, you don't have to choose one over the other! Using both together is an efficient way to select, copy, and insert items in Excel all at once.

Whether you're speeding up your Excel workflow by using keyboard shortcuts or knowing the best ways to use your mouse—like double-clicking to show and hide the ribbon or right-clicking to filter a dataset—combining both methods helps you organize your spreadsheet more quickly.

Selecting Non-Adjacent Cells, Ranges, or Objects

Clicking and dragging your mouse across adjacent cells selects them, but how do you select cells that are not next to each other? The solution is to hold Ctrl as you click on individual cells.

For example, suppose you want to make the text in cells A1, C1, and E1 bold without applying the same formatting to B1 and D1. To do this, select cell A1, hold Ctrl, and then click on cells C1 and E1.

Now, press Ctrl B to apply bold formatting to those selected cells.

How to Format Your Chart in Excel Excel offers (too) many tools for making your graphs look professional.

Posts Selecting a Large Range of Cells ----------------------------------

You probably already know that you can select a range by clicking and dragging your mouse over multiple cells. But if you need to select a large area, clicking and dragging may take too long.

Instead, select the top-left cell of your desired range, navigate to the bottom-right cell, hold Shift, and click it. In fact, as long as the first cell you select is in one corner of the range, you can move in any direction.

Duplicating the Selection (And Overriding Existing Data) You can move cells, rows, or columns by selecting, clicking, and dragging them to another location on the worksheet.

When you do this, if the target area already contains data, a dialog box will appear asking whether you want to overwrite it.

Moving the Selection (And Inserting It Between Existing Data) If you drag a selection to an area with existing data, it replaces it by default. However, you might want to move and insert the selected cells into an occupied range without losing any data.

To do this, after selecting the cell or range you want to move, press Shift and drag it to its new location. As you do so, a thick green line indicates where the selection will be inserted.

Once you're satisfied, release the mouse and keyboard to see that you've moved the cells without deleting any existing data.

You can also follow this method to rearrange entire rows or columns.

Duplicating the Selection (And Inserting It Between Existing Data)

The previous two keyboard-mouse combinations dealt with moving or inserting cells, rows, or columns. However, you can do both simultaneously by pressing Ctrl Shift while dragging.

In this example, I want to duplicate the header row every 20 rows of data so that the printed information is easier to read. To do this, I'll select the header row, hold Ctrl Shift, and drag it to the new location, guided by the thick green line that appears.

Related ##### How to Repeat Specific Rows or Columns on Every Printed Page in Excel

Print row and column headers (also called print titles) on every page so that your data is properly labeled.

PostsAs shown in the screenshot below, a copy of the header row has been inserted between the data for teams 20 and 21, and no data was overwritten. I can now continue repeating this process as I go further down the dataset.

.

---

Organizing your spreadsheet using keyboard-mouse combinations isn't the only way to speed up your workflow in Excel. For instance, you could use the name box for navigation, freeze panes to prevent excessive scrolling, and customize the Quick Access Toolbar.

The above is the detailed content of Reorganize Your Excel Spreadsheet With These Keyboard-Mouse Shortcut Combos. For more information, please follow other related articles on the PHP Chinese website!