8 simple ways to speed up the work in Excel
Technologies / / December 19, 2019
And you know how to quickly select an entire row or column, enter data in a cell in a few lines, add a comment to insert the current date? Today we reveal the secrets of working in Excel.
1. How to quickly adjust the size of columns to the width of the content
In each cell Excel It fits 32,767 characters. Therefore, the width of a column of rapid changes in the function of its contents is not always convenient. :) Although in most cases, it helps. Hover your mouse over the right border of the column header, and then double click on it to the program to find the optimal column width. This trick works for multiple columns, as well as for the entire sheet.
2. How to quickly select an entire row or column
When working with large amounts of data can not dispense with a keyboard shortcut, using which move easily on the sheet and separate individual rows or columns. combinations Ctrl + Spacebar and Shift + Spacebar just responsible for the rapid release of the current column or row.
3. How to quickly select a range of data
Once I watched a four-year child I use hot keys to copy and paste to enter the key to the game. It seems inseparable trinity Ctrl + C, Ctrl + V and Ctrl + A absorbed by the younger generation with the mother's milk. By the way, the command "Select All" in Excel is a small feature: a single press Ctrl + A highlights the current range and a double - the entire table.
4. How to make changes to multiple sheets simultaneously
Steamed turnip, your way! For example, to change the font size on all sheets at once, you need to collect them in a group using the mouse clicks on the tabs sheets, hold down the Ctrl key.
5. How to move a row to the current cell
You want to make fun of freshman in Excel - ask him to enter data in the cells in multiple rows. Of course, school trick, but with the older generation works with a bang. Combination Alt + Enter It prevents a transition to a different cell and moves the cursor to a new line within the current cell.
6. How to insert multiple columns or rows
Insert additional row or column takes three or four mouse clicks. It's a little, but only until such time as you do not need just a dozen new columns, for example. However, pre-selecting the required number of existing cells, it is possible to get rid all the same number of clicks.
7. How to quickly insert the current date
Apparently, hotkeys Ctrl +; and Ctrl + Shift +; you need to turn on the radio instead of the morning anthem. These combinations should be repeated until such time as the planet does not remain of the workaholic who drives a date and time manually.
8. How to quickly add a comment
programmers often add comments to your code, so that in case of need they their colleagues were able to understand nonsense the intricacies of writing. Excel users with such a habit does not hurt. The benefit under this business marked its hot keys: Shift + F2. Combination Ctrl + Shift + O selects all leaf cells to which is attached a note. Handy if you want to get rid of all comments in one fell swoop.