Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Is it possible to change the vertical cell borders in a straight table ?
I already searched in the custom format cell properties and in the table properties, I only found how to change the horizontally cell borders.
I also tried to change the style of the table but it removed my color condition on the dimension header: if(vOption=1, rgb(...), rgb(...))
See the foolowing capture:
Thanks,
Quentin
Hi Bruno,
I thought that couldn't be possible., if you want you can user the line or arrow object to place over the straight table.
Go to Settings
Use Preferences
Design
and select Always Show Design Menu Items
Now Right Click on any cell of Straight Table
and select Custom Format Cell
Border Before Cell - Select any border and
below color select Black.
That will solve your problem...
Hi guys,
Thanks for your quick answer.
Manish, I tried your solution but it still doesn't work, I can only change the horizontal color. I want to have grey borders everywhere.
Thanks,
Quentin
Oh.... It will work on Pivot Table... In Straight table you can change only horizontal lines...
It still doesn't work.
Here is what I get when I convert in a pivot table:
Quentin
You can do something like this by inserting an image...
Hi,
Thanks for your solution but I just want a thin grey border everywhere and not separate columns.
Thanks,
Quentin
It will work on pivot table....
please read the question he mentioned specifically vertical cell border..this where everybody struggling while generating important report .to get custom format you don't need to do the settings just click on snap grid and right click on table you will get ..if you have any solution for getting the cell borders in pivot table as like exactly in the excel cell please share..struggling a lot
thank you.