However, changing the width of columns, or the height of rows underneath the chart has no effect on its size.įinally, let's turn off move and resize options altogether. Now, if we delete a column, the chart shifts on the worksheet. Let's try the second option, "Move but don't size with cells." Note that by default, the chart will both move and resize with cells. In the dialog, click Properties.Īt the top are options for Object positioning. This will open the Format Chart Area dialog box. Click the Format Selection button on the Chart Tools Layout tab. You can control this behavior by adjusting the chart's position property. If we increase or decrease row heights, the chart automatically expands and contracts. We can see this behavior in action if we increase or decrease the width of any columns underneath the chart. (Alternatively, under the Home tab, click on the expansion icon next to Alignment, and in the Format Cells window go to the Protection tab.In this lesson we'll show you how to adjust the size and location of a chart.īy default, Excel charts will automatically move and resize when cells underneath them change. Right-click on your selection, select Format Cells, and click on the Protection tab. These will be the specific cells that can be edited even after the sheet is protected.Ģ. Select all the cells you don't want to be locked. However, you can specify whether a certain cell should be locked or unlocked in the cell's format properties.ġ. As mentioned above, all cells are locked by default when you protect the sheet. In our example, in an inventory list you might allow unit prices and stock quantities to be updated, but not the item IDs, names, or descriptions. There might be times when you want to lock certain cells from being changed but still allow users to adjust other cells in a worksheet. How to Lock Specific Cells in an Excel Worksheet The cells can only be unlocked when the sheet is unprotected (by going to the Review tab again, choosing "Unprotect Sheet," and entering the password, if required).
0 kommentar(er)
