if you want to protect a shape the active sheet must be protected. Sub ActiveShtUnProtectShapes() 'ActiveSheet.Unprotect Password:'1230' For Each s In ActiveSheet.Shapes s.Locked False Next End Sub. Now you can scroll up and down, side to side and not lose your place overall in your workbook. In our example, weve scrolled down to row 18. ActiveSheet.Protect Password:'1230' End Sub. On the View tab, in the Window group, click Freeze Panes, Freeze Top Row.
Click and drag the vertical line to appear just to the right of your row headings. In the Charts section, youll see a variety of chart symbols. #Lock columns excel symbols how to#
To learn how to unlock the cells, read the article How to Open a Password Protected Excel File.
Follow the steps below to learn how to lock and protect cells in Microsoft Excel versions 2010, 2007, and 2003. You will see a thick vertical line appear (may also see a thick vertical line). Cells that are locked and protected can be unlocked at any time by the user who initially locked the cells. Similar to locking the column headings, do the following. Your column headings are now locked in place.
Now click Freeze Panes in the Window group of the View tab. If we enter exactly 9 digits in column B then cell will accept the numbers. The above mentioned formula will prevent the users from entering digits lesser or greater than 9 digits. In Settings tab, select Custom in Validation criteria & enter the formula as LEN (B2)9 in Formula box. Click and drag the horizontal line to appear to underline your column headings. The Data Validation dialog box will appear. You will see a thick horizontal line appear (may also see a thick vertical line). If you want to pin or lock in place your column headings Excel lets you do that with the following steps. This will allow you to freeze row and column headings in Excel. If you ever need to keep the row headings or the column headings “pinned” on the screen so that you can track your place easier you need to use the Split and Freeze Panes features in Excel. And often you wind up having to scroll up and down or side to side in order to keep track of which column or which row you are looking at. It’s pretty easy to get a large number of rows or columns in one of your spreadsheets. How to freeze row and column headings in Excel 
Facebook 0 Tweet 0 Pin 0 LinkedIn 0 Print 0
0 kommentar(er)
