Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel: How do I group columns?
How do I group columns? And how do I compare data in columns, highlighting
like data? Thx Steve |
#2
|
|||
|
|||
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 -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Steve" wrote in message ... How do I group columns? And how do I compare data in columns, highlighting like data? Thx Steve |
#3
|
|||
|
|||
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 "Steve" wrote: How do I group columns? And how do I compare data in columns, highlighting like data? Thx Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Word address labels to Excel Columns | Excel Discussion (Misc queries) | |||
convert text labels to excel columns | New Users to Excel | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |