Ask Your Question

What cells is a style applied to

asked 2020-01-19 21:08:27 +0200

Inve1963 gravatar image

updated 2020-08-07 20:38:47 +0200

Alex Kemp gravatar image

I have a Calc document that I created some months ago containing several messed-up styles. Now I need to fix it and I would prefer not to rebuild it from scratch but I can't remember how I created and assigned the styles. Is there an easy way to check what cells I applied each style to?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-01-19 22:43:28 +0200

Opaque gravatar image

updated 2020-01-19 22:52:20 +0200


if you really applied styles (and did not perform direct formatting) then do

  • Styles -> Manage Styles -- or -- F11
  • Assure the icon leftmost in the pane header is selected (just beneath the word Styles)
  • Move to a cell its applied style you want to determine
  • Watch the Styles pane of the right side (assure Hierarchical is chosen in the drop down at the boot of the pane). The style applied to the selected cell will be highlighted.

I don't know of any way to Show me all cells having a special style applied - if that's what you are looking for. You only could select a range of cells (and extend a current selction) and as long the styles pane shows a specific style highlighted all cells in the range have that style (If highlighting vanishes at least two styles are applied to cells within the selected range).

Hope that helps.

If the answer helped to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more



Close to "Show me all cells having a special style applied" is editing the style in question to, say, have red background. Given the rationale mentioned in question, this might be appropriate approximation.

Mike Kaganski gravatar imageMike Kaganski ( 2020-01-19 23:02:51 +0200 )edit

OMG - embarrassing, I missed the forest for the trees.

Opaque gravatar imageOpaque ( 2020-01-19 23:17:31 +0200 )edit

answered 2020-01-20 00:43:09 +0200

m.a.riosv gravatar image

It can be done through Search & Replace , there is an option to search for styles, and only used styles are showed for search.

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-19 21:08:27 +0200

Seen: 117 times

Last updated: Jan 20 '20