Expand Spreadsheet Permit For Free

On the Review tab, click Unprotect Sheet (in the Changes group). Click the Protect Sheet button to Unprotect Sheet when a worksheet is protected.

If you want to ungroup rows and you just need to select the groups that you want to ungroup, and then click on the Data tab, and then click on ungroup button located in the Outline Group, and click Ungroup?. From the drop-down menu list.

The only way to carry out such functionality is to run a VBA macro. The key to getting this functionality is setting the UserInterfaceOnly protection property to TRUE and then enabling the ability to expand/collapse row/column groupings. This code only needs to be run once per sheet.

Click File, then Options, then select Proofing on the list on the left. Click the 'AutoCorrect Options' button. On the 'AutoFormat as You Type' tab, check the box labeled ?Include new rows and columns in table?

In other words, you can allow certain cells on a protected sheet to be unlocked with password. Here's how: Select the cells or ranges you want to unlock by a password when the sheet is protected. Go to the Review tab > Changes group, and click Allow Users to Edit Ranges.

Unprotect an Excel worksheet Go to the worksheet you want to unprotect. Go to File > Info > Protect > Unprotect Sheet, or from the Review tab > Changes > Unprotect Sheet. If the sheet is protected with a password, then enter the password in the Unprotect Sheet dialog box and click OK.

To switch the default paper size, go to Page Layout > Page Setup > Size, and then choose the size you want.

If there are cells that users should be able to change after a worksheet has been protected, make sure to unlock them before you protect the worksheet. Select the cells you want to unlock. Click the Format button on the Home tab. Select Format Cells. Click the Protection tab. Clear the Locked check box.Click OK.