Protecting A Table Column In Word For Mac 2011

Please change the table name and the name of the column that is containing formula you will protect. And change the offset in the code Selection.Offset(1, -4).Select to the first target column of the table. For example, if there are six columns in the table, please change the Offset to (1, -5).

This Excel tutorial explains how to freeze panes to keep the first row and first column visible when scrolling in Excel 2011 for Mac (with screenshots and step-by-step instructions).

See solution in other versions of Excel:

Question: In Microsoft Excel 2011 for Mac, I have a spreadsheet with column headings. I need to freeze the first row and also freeze the first column. That way, I can see the first row and first column at all times even when I scroll. How can I do this?

Answer: If you need to see the first column (column A) and first row (row 1) even after scrolling, you could try freezing the pane in Excel.

NOTE: Freezing panes only works when you are in Normal View.
Table

To freeze the first row and column, open your Excel spreadsheet.

Select cell B2. Then select the Layout tab from the toolbar at the top of the screen. Click on the Freeze Panes button and click on the Freeze Panes option in the popup menu.

Now when you scroll, you should still continue to see row 1 and column A.

Cells, rows, and columns in Excel 2011 for Mac work just like a table in Word or PowerPoint, but have many more capabilities. Adding rows and columns is almost as easy as pressing a button:

  • Inserting a cell: Select a cell (or multiple cells) and then choose Insert→Cells from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Insert→Insert Cells. A small dialog asks you which way to push the existing cells.

  • Inserting a row: Select a cell (or multiple cells row-wise) and then choose Insert→Rows from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Insert→Insert Rows. Your new, blank row(s) push(es) the current row and the rows beneath down one (or more) row(s).

  • Inserting a column: Select a cell or multiple cells column-wise and then choose Insert→Columns from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Insert→Insert Columns. Your new, blank column(s) push(es) the current column and columns one (or more) column(s) to the right.

You can delete cells, rows, or columns in the following ways:

  • Deleting a cell: Select a cell and then choose Edit→Delete from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Delete→Delete Cells. A small dialog asks you which way to move the existing cells.

  • Deleting a row: Select a row number and then choose Edit→Delete from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Delete→Delete Rows. Your selected row vanishes, and the rows beneath move up one row.

  • Deleting a column: Select a column letter and then choose Edit→Delete from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Delete→Delete Columns. Your column disappears, and columns to the right move one to the left.

    Malwarebytes for server. Mild footprint.