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.
hese 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 Spdsheets.
h4>1. 1. Scale your spreadsheet to fit on one page when printing fromcel
reatinting Spreadsheets is easy enough to do, but then printing that spreadsheet onto one page is something that has confused a lot of El users.
o scalcale your spreadsheet to fit onto one page follse steps
- Select file
- then Print
- then s>then select Fit sheet on on/li>
- S layout tab
- Select pagS set up
- Seo sheet
h4>2. Freeh4>2. Freeze or lock rows and columns in an Eeet
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 colheaders.
Well, this can be overcome with this nifty little trick Freeze or columns.
hen you arn
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 freely.
f you 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 he left.
h4>4. to the leftk 1
hen yo 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 result.
h4>5. ctual resultk 2
ometim 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 thformula.
img srte 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 foThen
- Un formula ribbon
- Under formula audit/li>
nce yotive 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 moverences.
his viin cell references.
This video will give you a good understanding orencing.
iframesolute 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 i/strong>
h3>If al that I can get.
If you enjoyed this 6 Excel Tricks please do share this artic/h3>
/awp-content/uploads/2019/09/access-all-areas.png" alt="" width="438" height="502" />
Take A FREE course with us Today!
cexcel training" width="432" height="501" />
Access All Areas Unlimited Learning
SIGN UP FOR OUR NEWSLETTER TODAY – GET EXCEL TIPS TRICKS AND LEARN AND EARN ACTIVITIES TO YOUR INBOX
Learn and Earn
Cross posted from my blog with SteemPress : https://theexcelclub.com/excel-tricks-make-life-easier/