Como congelar as configurações do Excel: largura / altura da célula,… somente para entrada de texto?

1

Eu preciso dar um grupo de pessoas para preencher o formulário do Excel. Eles precisam usar o mesmo computador. Enquanto isso, o formato geralmente muda quando as pessoas alteram a largura / altura da célula e a fonte /...

Estou pensando se você só pode permitir que o usuário insira texto nas células.

SO: Windows 10

    
por Léo Léopold Hertz 준영 15.11.2017 / 11:16

1 resposta

5

Você pode consegui-lo protegendo folhas :

Step 1: Unlock any cells that needs to be editable

In your Excel file, select the worksheet tab that you want to protect.

Select the cells that others can edit.

TIP: You can select multiple, non-contiguous cells by pressing Ctrl+Left-Click.

Right-click anywhere in the sheet and select Format Cells (or use Ctrl+1, or Command+1 on the Mac), and then go to the Protection tab and clear Locked.

Step 2: Protect the worksheet

Next, select the actions that users should be allowed to take on the sheet, such as insert or delete columns or rows, edit objects, sort, or use AutoFilter, to name a few. Additionally, you can also specify a password to lock your worksheet. A password prevents other people from removing the worksheet protection—it needs to be entered to unprotect the sheet.

Given below are the steps to protect your sheet.

On the Review tab, click Protect Sheet.

enter image description here

In the Allow all users of this worksheet to list, select the elements you want people to be able to change.

enter image description here

    
por 15.11.2017 / 11:22