Resources

How to highlight a column

How to highlight a column

To highlight a column may be tricky because there is no built-in option in Excel's Conditional Formatting feature. Here, you can find out how you can do this dynamically using Excel formulas. Steps Begin by selecting rows by clicking on column letters Open...

How to highlight a row

How to highlight a row

To highlight a row may be tricky because there is no built-in option to in Excel's Conditional Formatting feature. Here, you can find out how you can do this dynamically using Excel formulas. Steps Begin by selecting rows by clicking on row numbers Open...

How to return an entire row

How to return an entire row

To return an entire row you need to use array returning functions like INDEX or OFFSET. Both of these functions can return arrays, as well as single values, which can be used in other functions like SUM, AVERAGE or even another INDEX or OFFSET. How to...

How to return an entire column

How to return an entire column

To return an entire column you need array returning functions like INDEX or OFFSET. Both of these functions can return arrays, as well as single values, which can be used in other functions like SUM, AVERAGE or even another INDEX or OFFSET. How to return...

How to merge columns using formulas

How to merge columns using formulas

Traditional Copy+Paste might do all you want, but when working with large tables that are constantly updated, it's a tedious task to merge columns of data. Using this formula combination instead will save you time and prevent errors. Syntax =IFERROR(     ...