We're currently migrating from Ask to Discourse, read the details here

Ask Your Question

Can not change column width on protected sheet [closed]

asked 2013-11-24 16:58:39 +0200

Paijo gravatar image

updated 2020-08-02 17:12:23 +0200

Alex Kemp gravatar image

How to change column width in protected sheet?

I receive the file from email contains protected sheet, and I can't see some figures because the column is not wide enough.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-16 17:32:47.564814

2 Answers

Sort by » oldest newest most voted

answered 2013-12-18 15:12:02 +0200

w_whalley gravatar image

A work around: Select all cells in the sheet (Ctrl-A), copy (Ctrl-C), and paste into a separate blank spreadsheet (Right-click, Paste Only/Number).

edit flag offensive delete link more


That's it. In my case, i just paste everything, change the column width and I can print the sheet without the "###" on the table. Thank you!!

Paijo gravatar imagePaijo ( 2013-12-19 04:48:49 +0200 )edit

answered 2013-12-18 19:41:12 +0200

m.a.riosv gravatar image

Maybe the file is only-read because you are open it directly from the email, what puts the file in a temporary directory, and this is the reason for make it only-read, because is easily lose a document saved in a temporary directory. You can first save before open, or make the file editable with the edit icon.

image description

edit flag offensive delete link more


The file already in harddisk. Nothing wrong with the cells. I can edit, modify, save, and reopen file without any problem. I can reproduce the sample file. It contain only one protected cell (not protecting the entire sheet).

Paijo gravatar imagePaijo ( 2013-12-19 04:35:50 +0200 )edit

Question Tools

1 follower


Asked: 2013-11-24 16:58:39 +0200

Seen: 3,655 times

Last updated: Dec 18 '13