Filtering Multiple Data Points in the Same Column

RobTennis

New Member
Joined
Jun 27, 2019
Messages
1
Hi,

I have a report that spans many columns (A-AT) and thus becomes too small to print on one page. Some columns contain few characters like names and sport while others columns like Update contain a large amount of data. Currently, I use the filters and like to see all of the data across the different columns. However, in order to print on one page, I have moved/stacked some of the columns (Sport, Name, Coach) under one column and merged the Update/Details across the rows. In doing so, I have now lost my ability to accurately filter the data. Any ideas or help is appreciated.

Thanks,
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,902
Office Version
365
Platform
Windows
Any ideas or help is appreciated.
Yup, get rid of the merged cells.
They are best avoided like the plague, because they cause all sorts of problems.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,462
Messages
5,468,786
Members
406,608
Latest member
G3TEN

This Week's Hot Topics

Top