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

FIX ROW IN EXCEL

by admin | May 17, 2012 | Excel Formulas | Essential formulas, Excel | Excel Beginner Lessons

How to fix/lock a reference to a row in Excel In another post I have shown you how to create a reference to a locked/fixed cell. However at times we need to be able to fix a reference  to a row. For example if you need to calculate a set of daily numbers against a...

Excel shortcut keys – FREE

Recent Posts

  • How do I know what formula to use when?
  • Get metrics based on age and waiting times – Part Two ..the longest wait
  • Get metrics based on age and waiting times – Part One
  • Using Forms to capture data for analysis – Part Three – Meet Power Automate
  • Using Forms to capture data for analysis – Part Two

Categories

  • 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

Like Excel Expert on Facebook

Recent Posts

  • How do I know what formula to use when?
  • Get metrics based on age and waiting times – Part Two ..the longest wait
  • Get metrics based on age and waiting times – Part One
  • Using Forms to capture data for analysis – Part Three – Meet Power Automate
  • Using Forms to capture data for analysis – Part Two

Like Excel Expert on Facebook

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