6 Excel Tricks to Make Life Easier

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

  • Se
  • Select file     learn excel fast
    excel tips

  • then Print

  • Select>Scaling

  • then s>then select Fit sheet on on/li>


  • S layout tab

  • Select pagS set up

  • Select
  • Seo sheet

h4>2. Freeh4>2. Freeze or lock rows and columns in an Eeet
ery of4>
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.

ell, t

Well, this can be overcome with this nifty little trick Freeze or columns.

img srns.

freeze panes in excel

  • Seis
      iew tab
    • Select

    • 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 ced.

    h4>3. i>

    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 in excel  /><br/>

    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>

    imuate formula

  • Excel tr /><br/><br>h3>6.  height=

    6. ing

    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>

    Take A FREE course with us Today!

    lick here
    cexcel training" width="432" height="501" />
    Access All Areas Unlimited Learning
    a rolees.theexcelclub.com/courses/access-all-areas"> earn acelEarn /awp-content/uploads/2019/09/access-all-areas.png" alt="" width="438" height="502" />
    The Ultimate Excel Formulas Course
    * includes XLOOKUP and will soon include Dynamter>href="https://courses.theexcelclub.com/courses/the-ultimate-excel-formulas-course-excel-365">
    Become a Power Pivot Hero
    Power Pivot online training course

    h4aded="1" />


    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/

    Comments 2

    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

    03.01.2020 11:20

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

    04.01.2020 15:43