Reorganize Your Excel Spreadsheet With These Keyboard-Mouse Shortcut Combos
Many prefer to work in Microsoft Excel using their keyboard mainly, while others like to use their mouse. However, you don’t need to be one or the other! Using them both at the same time is a great way to select, copy and insert things into Excel into a single action.
Whether you accelerate your Excel workflow using keyboard shortcuts or know the best ways to use your mouse, such as double-click to display and hide the ribbon, or a right click to filter a data set, the combination of the two allows you to put your spreadsheet in order even more quickly.
Selection of cells, ranges or non -adjacent objects
By clicking and sliding your mouse on the adjacent cells selects them, but what about the selection of cells that are not next to each other? The answer is to keep CTRL when click on individual cells.
Let’s say that you want to make the text in cells A1, C1 and E1 BOLD without applying the same formatting to B1 and D1 cells. To do this, select the A1 cell, hold CTRL, then select the C1 and E1 cells.
Now press CTRL + B to apply fat in formation to selected cells.
When you use the CTRL + Click combination, the final cell you select remains white to indicate that it is the active cell. In other words, if you start to type, the entry will only appear in the white cell. To activate a different cell in the selection, press Tab or Shift + Tab.
You can also contain CTRL when selecting non -contiguous beaches.
The same goes for lines and columns. For example, if you want to increase the width of columns B and D, select column B by clicking on the column header, then hold CTRL, then click on the header of the D column D.
Now click and slide the left-right arrow cursor which appears when you fly over the border between the headers of columns B and C to modify the width of all the columns selected simultaneously.
The use of the CTRL + CLICK COMBURO is not reserved to select non -adjacent cells. Indeed, you can use the same shortcut to select other objects, such as shapes, text zones and graphics, which is particularly practical if you want to cut them and stick them in an Excel dashboard or keep their formatting coherent.
Related
How to format your graphic in Excel
Excel offers (also) many tools to ensure that your graphics look like the room.
Selection of a wide range of cells
You probably already know that you can select a beach by clicking and dragging your mouse over one cell. However, if you want to select a large area, click and slide can take too long.
Instead, select the left upper cell of the beach you want to select, and then access the right lower cell, keep Shift and click on it. In fact, as long as the first cell that you select is in one of the corners of the range, you can go to any direction.
This is a practical shortcut if the beach you select is part of an even larger beach. To select a continuous and continuous beach, select one of its cells and press CTRL + A.
You can also use the Click-Shift-ClicK combo to select adjacent lines or columns-simply select the first column or line by clicking on your header, keep the change, then select the last.
When you use the click-shift-click combination, the first cell you select remains active. To activate a different cell in the same selection line, press Tab and Shift + Tab. To go up and down the selected columns, press Enter and Shift + Enter.
Duplication of selection (and substitution of existing data)
You can move cells, lines or columns by selecting, clicking and sliding them to another area on a spreadsheet.
When you do this, if the new location already contains data, you will see a dialog requiring you if you want to replace this data.
You cannot move more than a cell, a line or a column at the same time as if they are adjacent to each other.
However, if you maintain CTRL when carrying out this click and drag action, the content of the selected beach is duplicated (rather than moved to) wherever you drop it, replacing everything that is already there.
With this keyboard mouse combo, Excel does not warn you that you replace the existing data, so use this shortcut with caution.
This combination also works with the lines and columns: select the line or column that you want to duplicate, maintain CTRL, and click and slide (from the beach edge, not from the line or the column header) to its new location, where it will replace all the data already in the line or column of destination.
Move the selection (and insertion between existing data)
If you click and slide a selection to an area already containing data, by default, it replaces it. However, you may want to move and insert the selected cells in a busy beach without losing data.
To do this, after selecting the cell or the beach, you want to move and insert, press Shift and drag it to its new location. During this, a thick green line indicates where the selection will be inserted.
Once you are happy, release your mouse and keyboard and see that you have moved cells without deleting any existing information.
You can also follow the same principle to reorganize whole lines or columns.
Duplication of selection (and insertion between existing data)
The two keyboard mouse combinations involved moving Or Insert cells, rows or columns. However, you can do both at the same time by pressing CTRL + Shift when you slide.
In this example, I wish to duplicate the header line after all 20 rows of data so that the information is easier to read when printed. To do this, I will select the header line, maintain CTRL + Shift, then click and drag it to the new location, guided by the thick and green line that appears.
Related
How to repeat specific lines or columns on each page printed in Excel
Print line and column headers (also called printing titles) on each page so that your data is properly labeled.
As you can see in the screenshot below, a copy of the header line was inserted between the data from teams 20 and 21, and no data has been replaced. I can then go ahead and repeat this process when I go down the data set.
.
The organization of your spreadsheet using keyboard mouse combinations is not the only way to accelerate your workflow in Excel. For example, you can use the name box for navigation, the shutters to avoid upgrading and customize the quick access toolbar.
