I'm baffled at this point, someone here knows this better than i. I have an Excel workbook saved in 97-03 .xls format. Multiple tabs. On each page I have categories and then data within each category. Each row has a colored background. The format has been established and I can't change it really. What I have going on is on the newest tab the highlighting and some cell borders are present. As I scroll right on the page they extend indefinitely beyond the columns I'm actually using. Because of this I get the used columns compressed to a point I can't read them easily on an 11x17 sheet. How do I get the extra columns to stop highlighting and adding borders beyond my needed columns?
Use the [clear] [clear all] in your tool bar at the top of the page. But this is not the best way because you have to select the rows and columns to [clear all].
You could select all, clear all formats, then reformat it in the proper way. Alternatively, just select all, define every cell as having a border without applying changes, then unselect the border and apply changes.
Even easier, you could just highlight the info you want printed and set a new print area that doesn't include the extra formatted cells.