6 Excel Tricks to Make Life Easier

2년 전

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 learn excel fast
    excel tips
  • 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.

freeze panes in excel
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 in excel

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
Excel tricks

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.

If you enjoyed this 6 Excel Tricks please do share this article with your friends and colleagues


Click here

Now there is value in learning Excel. Find out about our Excel Learn and Earn Activities

Learn and Earn

Cross posted from my blog with SteemPress : https://theexcelclub.com/excel-tricks-make-life-easier/

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  trending

Another quick way to Navigate through sheets is by using Excel Name Box.
To select a cell in another sheet from the active sheet, Type in the SheetName and Cell reference in the Excel Name box and press Enter.
Excel NameBox.png


Naming is something most don't do in Excel, although I think using names adds a lot of value