Ask Your Question
1

Can not change column width on protected sheet [closed]

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

Paijo gravatar image

updated 2014-01-29 20:19:23 +0100

manj_k 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
2

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

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

Comments

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 +0100 )edit
0

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

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

Comments

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 +0100 )edit

Question Tools

1 follower

Stats

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

Seen: 749 times

Last updated: Dec 18 '13