I have table with data, columns, rows, etc. I only want to display data from say columns A:Z. Then I want to expand column AA to 255 width and make it completely white for a dashboard view feel, while disabling horizontal scroll for the users. However, with the table, I am encountering that I can make most of the formatting for column AA white but the gridlines for column AA cannot be made white no matter the border changes, etc. I make. Is this possible or not b/c it is a table?
If you click on table styles then the down arrow at the bottom right at the very bottom you will see "clear" which removes the grid lines. This is in Excel 2019 - not sure about 365.
Maybe the following will help, if needed, with the navigation:
table1.png
And then:
table2.png
Last edited by GeoffW283; 09-28-2021 at 02:58 PM.
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks