Highlighted Rows Extend Passed Table - Real Annoyance

[Nick17]

Hello,

My manager reviewed some of my work in Excel.

In order to highlight rows in a certain color, he clicked on the row # so the entire thing was selected. After that, he would change the highlighted color to Red or Green.

The problem is that the table is only about 6 columns; however the new highlights extend passed these 6 columns infinitely.

Is there a way to remove his highlights beyond column 6? If I delete these columns, more just re-appear from the right. If I select, for example, columns 7-14 (the visible columns) and remove the highlight, columns 15 - infinity will still be colored.

Anyone have any suggestions with this problem? I would really appreciate it!

Thanks,
Nick

[Moo the Dog]

If your data is in columns A:F, click on the Column label for column G (this will select the entire column), then press Shift + Ctrl + Right Arrow. Then select the fill color picker and choose 'No Fill'

- Moo

[Nick17]

EXACTLY what I needed!

Thank you!!!!!

[Nick17]

EXACTLY what I needed!

Thank you!!!!!

[Moo the Dog]

Glad to help, and thanks for the feedback. =)