Ask Your Question

If cells are hidden, cannot format all of them together [closed]

asked 2012-12-22 06:47:07 +0200

neo269 gravatar image

Hi In Calc, If cells are hidden, I cannot format all of them together. Can some one help me with this


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 14:19:26.550157

1 Answer

Sort by » oldest newest most voted

answered 2012-12-22 16:55:14 +0200

m.a.riosv gravatar image

How do you select the cells? If you are using ctrl+click then no possible to select hidden cells. If you drag with mouse or using shift+arrows the hidden cells are selected.

A simple test. New spreadsheet Enter a text form A1 to D1 Hide B column Click on A1, retain Shift key pushed and click on D1. Change the format. Unhidden B column, have the same format as other cells?

edit flag offensive delete link more

Question Tools


Asked: 2012-12-22 06:47:07 +0200

Seen: 46 times

Last updated: Dec 22 '12