Mastering Excel is not something that you can achieve overnight. Taking on bite-sized chunks of learning will help you get there. And that’s what you are going to get today. In this article, I am going to focus on 6 Excel tricks, each just a bite-sized chunk, that will make your life easier.
These Excel tricks, which are based on commonly asked questions, when mastered will save you time and make you more efficient in your daily tasks using Excel Spreadsheets.
1. Scale your spreadsheet to fit on one page when printing from Excel
Creating Spreadsheets is easy enough to do, but then printing that spreadsheet onto one page is something that has confused a lot of Excel users.
To scale your spreadsheet to fit onto one page follow these steps
- Select file
- then Print
- Select Scaling
- then select Fit sheet on one page
- Select page layout tab
- Select page set up
- Select Fit to sheet
2. Freeze or lock rows and columns in an Excel worksheet
Very often you will create spreadsheets that don’t fit the size of your screen. When you scroll down or across these sheets, you can no longer see the column or row headers.
Well, this can be overcome with this nifty little trick Freeze or Lock rows and columns.
To do this
- Select the View tab
- Select Freeze panes (selecting Freeze panes will freeze the rows directly above the active cell and directly to the left of the active cell, so ensure that you have the correct cell selected.
3. Quick Navigation
When you are working between a number of different spreadsheets, jumping between different files can be a little annoying. You can make this step faster with this keyboard shortcut. Ctrl + Tab will allow you to shift between different excel spreadsheets freely.
If you are working in a workbook that has a number of worksheets, there is a simple keyboard shortcut that will allow you to move between sheets very easily. Ctrl + PgUp will move from the sheets to the right. Ctrl + PgDn will move to the next sheet to the left.
4. Formula Trick 1
When you enter a formula into a spreadsheet, what you see in the cell is the answer. But what if you don’t want to see the answer? What if you want to see the actual formulas in the spreadsheet? Ctrl + ‘ is a relatively unknown keyboard shortcut that will display all of the formulas in the cells rather than the actual result.
5. Formula Trick 2
Sometimes when you enter a formula you don’t get the answer you expect. And sometimes when you look at formulas created by others they can be hard to understand. A fantastic tool to use in these cases is Evaluate formula.
Evaluate formula will go through the formula step by step, showing you the outcome for each step. It’s basically a debugging tool. To use this function, select the cell that contains the formula you need to evaluate. Then
- Go to the formula ribbon
- Under formula auditing, select Evaluate formula
6. Absolute and Relative Referencing
Once you can enter basic formulas you need to learn Absolute and relative referencing. You see, when you copy a formula down rows or across columns, the formula has a tendency to move, unless you lock in cell references.
This video will give you a good understanding of Relative and Absolute cell referencing.
So there you have it. My 6 Excel Tricks to help you become an Excel master one step at a time, 6 Excel Tricks that will make your life easier. I have some very pretty share buttons below. I hope that you will take the time and share this article on your social profiles, as your referral is the best referral that I can get.