How to Change a Range in Microsoft Excel. When you copy a formula, referenced ranges automatically adjust according to the formula's new position unless the ranges use absolute references.

In Microsoft Excel, changing the evaluated range on the fly requires a bit of work, but it's definitely possible thanks to the Offset() function.

Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.

How to Set a Rule in Excel. You can use Microsoft Office Excel to set conditional formatting rules to handle complex scenarios without having to code all of the formulas yourself.

You can set up conditional formatting in Excel for dates. We have included detailed examples you can try while reading the guide.

You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen data leaving the screen.

Set data validation If you want to insert different task priorities (High, Medium, or Low) and Status (Pending, Ongoing, Skipped, Completed) in your Excel sheet, you need to use Data validation.