Microsoft Excel is a wonderful tool-and perhaps one of the most used software programs in Danish companies. Despite Excel’s popularity, few people get the maximum out of the program.
Therefore, in this guide we have collected 8 Easy Tips and tricks For Excel, which will save you a lot of time in everyday life.
Let’s take a closer look at them right away!
1: jump from sheet to sheet
If you work with Excel in everyday life, there is a high probability that your Excel file consists of several sheets. Instead of clicking on the sheet you want to go to, you can easily jump from sheet to sheet with the following shortcuts:
- Control + Page Up: takes you from right to left & lt;-
- Control + Page Down: takes you from left to right- & gt;
2: Jump to the end of the data set
When you have a collection of data in your spreadsheet, it is super useful to be able to jump from end to end in it. You might be using the arrow keys right now to go from cell to cell? But what if you want to move completely to the second of the dataset?
Then you simply hold Control in + Arrow key in the direction you want.
For example, if you want to get to the end of the data set, Press Control + Down Arrow.
3: select multiple cells
Following on from the above tips, you may want to select a number of cells. Instead of dragging with the mouse, scrolling or other – you actually just build on the shortcut described in tip 2.
You simply hold down Control + Shift and then press an arrow key in the direction you want.
For example, do you have a data set that is 10 rows and 3 columns and do you want to highlight it all? So simply place yourself in the cell at the top left. Then Hold down Control + Shift, press the Down Arrow and then the right arrow-vupti, then the dataset is checked.
4: Copy a formula with 2 clicks
You can easily copy a formula to the end of a data set. You don’t have to click and drag – you can actually just double-click in the cell’s right corner. From there, Excel does the rest for you and copies the formula to the end of the dataset.
5: easily format cell values
You can easily transform a cell’s value from having 2 decimal numbers to dollars and to percentages.
How? Like this:
Mark the cells where you want to format the values.
- If you want 2 decimal numbers, click: Control + Shift+!
- If you want the values made to$, click: Control + Shift +Control
- If you want the values made to percentages, click: Control + Shift + %
Relatively intuitive and easy to remember.
6: lock references with one click
When you copy formulas in Excel, it is often convenient that Excel knows how to refer to the new input cells as the formula “moves”. Other times, however, this feature can completely put an end to what you want.
For example, if you want to refer to a “static” cell in the formula, you need to lock the reference. To lock a reference, insert $ before the column name and row number. However, this takes far too long and is too impractical, so let’s do the following instead:
Just click F4 when you are in the process of the formula. Clicking F4 repeat times, you actually have different options. These proceed as follows:
- Lock the reference to the specific cell
- Lock the row number
- Lock the column letter
- Do not lock
7: & amp; this is smart!
Let’s say you have 2 columns with a first name and last name, respectively. Now you would like to have the full name in 1 cell – but how do you do this easiest and fastest?
You just use: & amp;
In the cell where the full name should appear, simply write: =[Fornavn]& “” &[Efternavn]
In the example (see in the picture) I have simply written: =B3&” “&C3
8: easily generate random values
If you want to try something out in Excel and don’t have a dataset at hand, you can get Excel to generate random values for you. You do this using the SLUMP () function.
The SLUMP () function gives you a value between 0 and 1 by default. But you can also get it to give you random values within, for example, 1-100. If you want a random value between 1-100, just type: =SLUMP()*(100-1)+1
Bonus Tip: Want Another random number? Then simply press F9. Then update the entire workbook (be careful with this as this also affects the rest of the worksheet).
The article was written by Mikkel and Kasper from the course company Proximo, which focuses on Microsoft Office – especially Excel. On their blog you will find bl.a. articles about Excel, Word and PowerPoint.
8 simple Excel tricks that will save you time in everyday life
Microsoft Excel is a wonderful tool-and perhaps one of the most used software programs in Danish companies. Despite Excel’s popularity, few people get it…
Written d. 30 Oct 2015-No comments