Excel: How do I group columns?

[Steve]

How do I group columns? And how do I compare data in columns, highlighting
like data?

Thx
Steve

 

[JulieD]

Hi Steve

not sure what you mean by 'group' - there is an option under the data menu
called group & outline / group which is basically an alternative to hiding
columns? is this what you're after?

as for comparing data in columns - check out
http://www.cpearson.com/excel/duplicat.htm

 

[Duke Carey]

Grouping columns - look under the Data menu at Group and Outline

Comparing entries - if you want to highlight entries in column B that match
the entry for the same row in column A, use Conditional Formatting (on the
Format menu). First hihglight the values in column B, then select
Conditional formatting. Set 'Cell Value is' , then use 'equal to' and
finally, point to the adjoining cell in column A. Make sure the reference is
relative, i.e., has no $$ in it. Then set your format and OK your way out