Scroll while highlighting multiple columns

**Snaxx** · 12-06-2014, 10:54 AM

I want to be able to scroll through a sheet, just by using the down arrow or mouse, but to have it continually select 5 columns at a time. My goal is when I find something that fits my data search, I'll be bolding it. Instead of scrolling A1, A2, etc., and then highlighting A, B, C, D, & E, I'm hoping there's a way to lock the scroll choice to pick A-E continually. Is this making any sense to anyone but me?

Thanks for your help.

**alansidman** · 12-06-2014, 11:03 AM

It might be easier to do this with a VBA solution. Tell us what your criteria is and where it might be located and we might be able to give you a suitable solution.

**Snaxx** · 12-06-2014, 11:09 AM

Thanks. I'm basically just trying to reconcile my expense reports to my amex statement to see if I've missed anything. So, I have a download of my excel/AMEX statement, but it's 290 lines. I've expensed some of those lines already. So, I want to scroll and when I find that I've expensed, just hit ALT+B and bold it. But all the columns of the sheet. If I can only do it via VBA, I don't have that knowledge or ability (I don't think) as this is on my work PC and I'm limited on programs. But would like to know still.

**alansidman** · 12-06-2014, 02:05 PM

Dummy up your spreadsheet so that there is no confidential material in it. Upload it and let us know what critieria would require a line to be bold and I am sure that some VBA code can be written quickly to make this happen.