Manipulate Columns Release For Free

Select the column you want to protect, right Click-> Format Cells->Protection, and select the "Locked" check box.

Unhide Rows or Columns Select the rows or columns that surround the hidden row(s) or column(s). Click the Format button under the Home tab. Select Hide & Unhide. Select Unhide Rows or Unhide Columns. Right-click the selected row(s) or column(s) and select Unhide from the contextual menu.

Select the column or columns that you want to change. Go to Home > Cells > Format. Under Cell Size, select AutoFit Column Width. Note: To quickly autofit all columns on the worksheet, select Select All, and then double-click any boundary between two column headings.

If you have an Excel table where multiple columns are hidden and want to show only some of them, follow the steps below. Select the columns to the left and right of the column you want to unhide. ... Go to the Home tab > Cells group, and click Format > Hide & Unhide > Unhide columns.

You're scrolling down your worksheet (or scrolling to the side), but part of it is frozen in place. This is probably because at some point you decided to freeze the panes. To fix this, click View > Window > Unfreeze Panes.

On the Home tab, click the Format Cell Font popup launcher. You can also press Ctrl+Shift+F or Ctrl+1. In the Format Cells popup, in the Protection tab, uncheck the Locked box and then click OK. This unlocks all the cells on the worksheet when you protect the worksheet.

Freeze columns and rows Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.