Excel Tips: Calculation & Formulas > Other tips

Cell References

How to anchoring formula cells (change cell reference to absolute) in Excel?

How to change relative reference to absolute reference in Excel?

How to change/convert absolute reference to relative reference in Excel?

How to drag or copy formula and lock the cell value in Excel?

How to extract cell reference from formulas in Excel?

How to find and replace string within formulas only in Excel?

How to find or get the cell reference of the previous active cell in Excel?

How to force formula to always use same cell in Excel?

How to get a row or column letter of the current cell in Excel?

How to get or reference cell from another worksheet in Excel?

How to get the address of active cell in Excel?

How to increase or increment cell reference by X in Excel?

How to increment worksheet reference automatically in Excel?

How to keep formula cell reference constant in Excel?

How to lock all cell references in formulas at once in Excel?

How to move or replace references in Excel formula?

How to prevent cell reference in a formula from incrementing /changing in Excel?

How to quickly add $ into Excel formulas?

Copy Formulas

How to apply same formula to multiple cells in Excel?

How to autofill formula when inserting rows in Excel?

How to autofill VLOOKUP in Excel?

How to copy cell formula only not formatting in Excel?

How to copy formula without changing its cell references in Excel?

How to copy formulas and paste to other worksheet as text in Excel?

How to copy formulas from one workbook to another without link?

How to fill series or formula to a specific row without dragging in Excel?

How to paste transposed and keep formula reference in Excel?

How to quickly apply formula to an entire column or row with/without dragging in Excel?

Remove Formula but remain calculation result

How to make formula results permanent in Excel?

How to remove all formula references but keep values in cells in Excel?

How to remove all formulas from a range or a worksheet in Excel?

How to remove formulas from worksheet but keep the values/results in Excel?

How to replace formulas with results or value in Excel?

Named Ranges

Change cell reference in formulas to range names in Excel

How to batch rename multiple range names in Excel?

How to create dynamic named range in Excel?

How to create multiple names from selection in Excel?

How to define named range across worksheets in Excel?

How to define range based on another cell value in Excel?

How to easily edit name range and the scope in Excel?

How to find and locate named ranges in Excel?

How to find named range reference in Excel?

How to find where a certain named range is used in Excel?

How to hide / unhide all named ranges in Excel?

How to highlight all named ranges in Excel?

How to insert or display named range on another sheet?

How to list named ranges in Excel?

How to populate Combo Box with data of Named Range in Excel?

How to quickly delete all named ranges in Excel?

How to quickly get address of named range in Excel?

How to quickly select named range cells in Excel?

How to replace range names with cell references in Excel?

How to resize an existing named range in Excel?

How to see all named ranges in Excel?

Find Position of Character

How to find position of first/last number in a text string in Excel?

How to find position of nth space in Excel string?

How to find the position of the first lowercase letter from text strings?

Other Functions

How to combine transpose function and If statement function in Excel?

How to insert function in Excel?

How to use HLOOKUP to sum a range of values in Excel?

How to use IF function with AND, OR, and NOT in Excel?

How to use Replace function to replace and add string in Excel?

How to use SUBSTITUE function in Excel?

Others

How to determine if a number or value is in a range in Excel?

How to find and return the second to last value in a certain row or column in Excel?

How to find nth occurrence (position) of a character in text string in Excel?

How to find the first, last or nth occurrence of a character in Excel?

How to get the cell value based on row and column numbers in Excel?

How to return filename without extension to cell?

How to return the row number of first or last non blank cell in worksheet?