There is no doubt that Excel is a very useful tool for organizing business and personal life.
However, most people who are used to using the software are still unaware of all the features it has.
There are countless Excel formulas and shortcuts that streamline the template creation process.
That's why we've put together a post listing key laos email list 75226 contact leads commands and some shortcuts that will help you save your precious time while using the program.
Curious? Keep reading!
Digital Marketing Guide
Find out how to improve your strategy right now!
5 Excel formulas to make your work easier
1- Automatically fill lines and columns
When it comes to time optimization, there is a very important command in Excel to record data that follows a pattern.
Instead of filling in cells manually, the resource allows the insertion of all the desired information in a single step.
To do this, click on the lower right corner of the cell that contains the data you want to copy and drag the selection box until the desired number of cells is filled.
Then release the mouse. The program will replicate the content, filling in the adjacent cells like the first one selected.
2- Quickly select a fragment of lines or columns
Are you short on time and need to select part of an Excel table or even the entire document?
For those who don't know, this job can be done very simply and quickly, leaving more free time for the professional to edit other more important features.
If you want to select the entire spreadsheet, you should know that you can do so with just one click:
There is a button in the upper left corner, between the numbering of the 1st line (number 1) and the title of the first column (letter A). With just one click, the mentioned function is executed.
However, if you need to mark only part of the lines or columns, you should use the following shortcuts:
Ctrl + Shift + down arrow or up arrow to select lines; and
Ctrl + Shift + right arrow or left arrow to select columns.
On Apple computers, there is a slight difference:
Command + Shift + Down arrow or Up arrow, while selecting lines; and
Command + Shift + Right Arrow or Left Arrow when selecting columns.
