Make sure you’re working productively in Excel, save time, and impress your team with these simple Excel tricks:
This may come in handy if you need to reformat your workbook. Simply click on the square in the upper left-hand corner. Every single cell - even the empty ones - will now be highlighted. If you prefer keyboard shortcuts, holding down Ctrl + A will do the same thing.
It sounds like a complicated job, but it’s a lot easier than you think.
Make sure the workbook you would like your worksheet(s) to be moved to is open, select the worksheet(s) you want to move or copy.
Click Home > Cells > Format. Under Organise Sheets click Move or Copy Sheet
In the Before sheet section of the dialogue box that has appeared on your page, click one of the following:
If you want to copy rather than move your worksheet(s), select the Create a copy > check box in the Move or copy dialogue box.
Tables are constantly changing and it just so happens that today you need to insert 3 blank rows between Row 7 and Row 8. Rather than doing them one by one, try out this handy shortcut:
If your Excel worksheet contains a lot of data it can be hard to find the information you want quickly. Filters are a great way of sorting through to display only the information you need. In order for this to work, you must ensure that you include a header row to identify the name of each of your columns.
Thankfully there is a nifty Excel trick to apply a formula to an entire column/row. If your formula is in B2, click on that cell and then click on the little box that appears in the bottom right-hand corner, dragging it across your desired range of cells. The formula will now populate the range of cells.
Picture this, you’ve put all of your data in a series of rows, only to realise that you were actually supposed to put it in columns. Fear not, this switch is simple.
Why enter data manually when your worksheet can do it for you? An Excel trick called AutoFill will fill your cells with data that follows a pattern.
This is most probably the easiest and quickest of all of the tips listed above. This will help you, especially if you work with figures and finances.
These simple Excel tricks are just the beginning of your journey to becoming an Excel expert. With a bit of practice, expert advice, and taking one of our short Excel training courses you’ll be mastering the spreadsheets in no time.
by Cristina Moraru | 08 Jan 21
3 Interesting Courses For You