Forum Discussion
How to sort blank columns with color
I'm unable to access those sites from my office, are these screenshots helpful?
I also cannot share the data, so this is just an example file.
Colored rows, before running a sort.
After running a sort on Column 5.
The issue is the colored columns starting in Column F, they are not included in the sort.
Typically, the rows are much longer than this, they extend beyond multiple screens wide, lots of columns.
Thank you
Patrick2788 wrote:
As an aside, I'd recommend not adding fill to cells beyond your data. Formatting beyond the data can cause a workbook to bloat. This tip will come into play with conditional formatting, too. Conditional formatting formulas are single threaded. Keep the sheet tight and optimized.- Yes, that sounds like what I need! I just don't know how to do that.
- When coloring a row, what's the quickest/easiest way to only fill the fields within a column that has a title/header, and not extend the color into the empty columns on the right?
- Is there perhaps a keyboard shortcut to select those fields within a row, by starting on the left?
- I'm trying to avoid scrolling all the way to the right-most field and doing a SHIFT+HOME combo.
- Is there something similar to that, but reverse... starting on the left and selecting only columns that would be included in a sort (ie clicking on the "Filter" button doesn't include all columns, just those with data).
Please let me know if you need any clarification, I sincerely appreciate your help.
Thank you!!
- I think it's OK to extend conditional formatting to 1,000 rows or so if you're using 500 and will add more (All within reason). The situation you want to avoid is filling entire columns or rows yellow.
Thanks for the reply.
I'm looking for a simple solution without conditional formatting.
* How would you select all the data in an individual row, without extending beyond the columns included in a sort? If there's a simple way to do this, it's the answer I'm looking for 🙂