[Solved] Make cell borders consistent

[Oskar4U]

The attached snip shows part of a working sheet I have and some of the lines are faded, some they are in bold. This happens thru out the sheet in various places

I know I can do it by Format/Cells but its too time consuming

Any other way to have all lines the same type without loosing my data?

Thanks

TTScreenshot 2023-10-03 151728.jpg (35.44 KiB) Viewed 2588 times

[Hagar Delest]

Select the cells and hit Ctrl+M to remove all the formatting. Then apply the borders as you want.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the 🖉 button if your issue has been fixed.

[Zizi64]

I know I can do it by Format/Cells but its too time consuming

Use the Cell Styles instead of the direct (manual) formatting method (Format/Cells).

[Oskar4U]

Sorry folks nothing worked, I have LO 7.6.2

Using Ctrl+M then Format Cells Border, I pick a thick line but nothing changes in my sheet

Cell Styles? Under Format or Sheet menu I see nothing similar. Where is it?

Thanks

[Oskar4U]

Now I got it,
Format/Cells
Then select presets (the 4th includes outer + inners lines)
Then select at the bottom the width of your choice.

Many thanks

[Zizi64]

Cell Styles? Under Format or Sheet menu I see nothing similar. Where is it?

From the Side Bar:
(Switch ON the Side bar first)
Side Bar - Styles - Cell Styles - Choose a Style, what you want to modify - Modify the desired properties of the style.


From the menu of the LO 7.5.7:
Styles - Cell Styles - Choose a Style, what you want to modify - Modify the desired properties od the style.

[Oskar4U]

Keep forgetting the side bar, very useful
Thanks