The Excel Expert
  • Welcome to the Excel Expert
  • Blog
  • Books for sale
    • Your Excel Survival Kit
      • Get the e-book plus bonuses here!
      • Buy on Amazon.co.uk
      • Buy on Amazon.com
      • Create Great Reports in Excel
      • Create Great Reports in Word
    • Get and Transform your data
  • Products for Sale
  • Free Webinars
  • Testimonials
  • About
    • Resources
    • About
    • Privacy Policy
    • Terms of Use
  • Contact
Select Page

11 – How to freeze top row of large data set – View | Freeze Panes

by admin | Mar 8, 2021 | Excel | Useful tricks

Ah, yes that joyful scenario. You have a list – a great big juicy list and you want to scroll down that list but oh no my headings have disappeared…WHAT DO I DOOOOO? Well I *have* heard of people who have sellotaped the headings onto their...

Time keeps on slippin’ slippin’….roundin’ on up to nearest 15 minutes

by admin | Apr 28, 2015 | Excel | General, Excel | Useful tricks

Anyone get that song reference? I give you a clue down the bottom of the post… Well have to say I do love my students (in a good way…not a weird way I hasten to add. :-).). I recently had a woman in class who had the following Excel conundrum… She...

Data Protection | How can I let users sort but not touch?

by admin | Aug 11, 2014 | Excel | General, Excel | Useful tricks

Not so long ago I was asked by a user for help with her file. She wanted people to be able to sort and filter but not do ANYTHING else with it. Of course I went to try my usual things of setting up protection Review – Protect Sheet – tick Sort, tick...

Aging debtors analysis | Using Today() and vlookups or how to know who you need to send to the Sopranos

by admin | Jun 2, 2014 | Excel Pivot tables | Introduction, Excel | Case Studies, Excel | Useful tricks

I was recently teaching a class on Powerpivot and the subject came up of how to use Excel to construct an aging analysis. The person had already created some serious serious formulas to do what he needed to do so no point in re-inventing the wheel. His big interest...

Formula showing formula not result | How to solve

by admin | Oct 24, 2013 | Excel | Useful tricks

I recently came across an interesting problem. A student in one of my classes asked me to help her set up some If functions which I did and which worked fine. It was a function to say that if a cell was blank, then the answer was to show today minus the days in F2,...

Creating an Excel hyperlink – Part 02 | Linking to other files – using named ranges

by admin | Sep 3, 2013 | Excel | General, Excel | Useful tricks

In a previous post, I covered some of the basics of using hyperlinks to link to other documents but today I’m going to show you how to link to specific cells (or if you are feeling a bit adventurous :-)) to some named ranges. Also note that you can hyperlink to...
« Older Entries

Excel shortcut keys – FREE

Recent Posts

  • Cleaning up emails
  • Calculating a Location Allowance – with conditions
  • Creating a Dashboard in Excel
  • 11 – How to freeze top row of large data set – View | Freeze Panes
  • Remove unwanted spaces using Trim() and combine multiple entries – 3 ways

Categories

  • Excel – From The Beginning
  • Excel Formulas | Essential formulas
  • Excel Formulas | Essential Functions
  • Excel Functions | Useful
  • Excel Lists | List basics
  • Excel Lists | Sorting and Filtering
  • Excel Pivot tables | Introduction
  • Excel | Advanced Lessons
  • Excel | Case Studies
  • Excel | Conditional Formatting
  • Excel | Excel Beginner Lessons
  • Excel | Excel for Small business
  • Excel | General
  • Excel | Intermediate Lessons
  • Excel | Useful tricks
  • Personal
  • Powerpivot 2010
  • Training Records Management
  • Using Excel for tracking training

Like Excel Expert on Facebook

Recent Posts

  • Cleaning up emails
  • Calculating a Location Allowance – with conditions
  • Creating a Dashboard in Excel
  • 11 – How to freeze top row of large data set – View | Freeze Panes
  • Remove unwanted spaces using Trim() and combine multiple entries – 3 ways

Like Excel Expert on Facebook

  • Resources
  • Welcome to the Excel Expert
  • About
  • Blog
  • Contact
® 2019. All Rights Reserved