The first and simplest method involves increasing the width of the column that contains the cell, or increasing the height of the row containing the cell. Plus a few bonus tips to save time with the setup. Click to clear the Locked check box, and then click OK. CELL can get things like address and filename, as well as detailed info about the formatting used in the cell. This prevents key items like headers from scrolling off-screen. Just click and drag in Excel to place the selected shape as shown and give it a name. We used Microsoft Excel 2000 here, but the concepts work with earlier versions of Excel and other spreadsheets. On the Review tab, click Protect Sheet. All that works, but i still can't prevent users from copying pasting the cells with their comments attached. Jul 23, 2010 · As far as I am aware Excel does not accommodate Events for shapes and so there is no simple way of detecting a change in a shape size and then resizing the shape. The function keys are not in function mode, but are in multimedia mode by default! You can change this so that you don't have to press the combination of Fn+F4 each time you want to lock the cell. This code checks which cells are currently visible and selects the first cell below the visible range which is not in view. Excel pages will be our animation frames, and cells will be our pixels. Shadow, glow, and reflection are examples of the visual effects that you can add. To insert a shape just click on the desired shapes icon and the cursor will then change to a cross. Feb 15, 2013 · How to create a Bullet graph using excel charts and within an excel cell February 15, 2013 February 15, 2013 | Alesandra Blakeston Bullet graphs were invented by Stephen Few to improve upon standard bar charts and gauges. By default, Excel sets the flow chart autoshapes to move when cells are deleted, inserted, or resized. In that dialog, choose the Protection tab and check the Hidden item. Apr 04, 2019 · Bottom Line: Learn how to lock individual cells or ranges in Excel so that users cannot change the formulas or contents of protected cells. The On-Screen Keyboard in Windows, Scroll Lock key in white. You need an absolute cell reference for subtracting numbers with a number. Insert a text box in Excel from the Insert tab by selecting Text, Text Box, and then use your mouse to drag to a region on your worksheet. The Numbers Shortcuts Page helps with troubleshooting, tutorials, service, and information for new users. At First, we will need to select the cells we want to lock. This displays the Chart Tools, adding the Design, Layout, and Format tabs. You can insert graphic shapes such as lines, rectangles, block arrows, stars, and other basic shapes in your Excel 2010 charts and worksheets. Freeze shapes in excel. On the View menu, click Drawing Explorer Window. In this article, we will analyze how to copy and paste multiple cells in Excel. At the cell level, it's easy to both protect and hide formulas using simple formats--albeit not a format in the traditional sense. Dec 26, 2014 · Sudeep wrote me, “I need some help to update a slide containing a map with certain districts. As far as I am aware Excel does not accommodate Events for shapes and so there is no simple way of detecting a change in a shape size and then resizing the shape. Hi Everyone! I tried to insert a picture in specific cells and I have coded a small VBA for Excel 2007. Then, go to the Data > Protected sheets and ranges menu to start. In need to update them monthly from an Excel sheet. The red blood cells of the dromedary camel protect it from dehydration because the oval-shaped cells can circulate even in thick blood and can significantly expand during rehydration. Select the. Right-click on then select "Format Cells" from the popup menu. In Microsoft Excel. Shapes(1) provides access to the first shape on the activesheet, and Activesheet. ; While Microsoft Excel sheets can be a great way to collaborate and share data, sometimes you don't want others to be able to change. Select a range of cells as shown in the picture below. That should do it. I want to some how change property of shapes so that when I scroll then all cells should move but shape should not move. I do a lot of flowcharting and would love to find a way to get Excel to open with shapes set to lock to the cell grid by default (excuse me if the terms aren't always correct - I'm translating from the Italian version of Excel2003). Consider this. logo image1 which is locked. ) What makes them so dangerous-bear with the chemistry lesson-is that each one. Lock Data Cells. Restrict users to edit the cell; Lock Cell and Unlock Cell. See the example below for the menu option. Select cells B1-B3, and enter the formula,. No matter what other text I input or other graphic items I position, I'd like the shape to remain at the top of the page in the center. Sometimes we need to add a "Prefix" & "Suffix" to existing data to clearly indicate what the data pertains to and make it more understandable to the reader. Click Protect Sheet, leave the Select Locked Cells check box selected, and then click OK. I have a shape that I would like to "lock" into the center position on the top of my page. Note that empty cells within your table are OK. The On-Screen Keyboard in Windows, Scroll Lock key in white. Microsoft Excel 2013: Mouse Pointers & Cursor Movements As you move the mouse over the Excel window it changes shape to indicate the availability of different functions. Question: How do I protect a cell from being edited by others in Microsoft Excel 2016? Answer: First, you'll need to un-protect all of the cells on your sheet. Value = StartNumber. Imagine you have two rectangles on your spreadsheet called 'Rectangle 1 and 'Rectangle 2'. Click cell B2. Also, there are a lot of other things you can do with comments once you add them to a worksheet like formatting, changing the shape, resizing and so on. After that Excel doesn't allow to replace the unlocked image in that protected sheet. Click the comment's border to select it as a Shape (or, Ctrl-click the comment to select it as a Shape). Excel is a great tool to use to create a quiz for work or play. Private Sub Workbook_Open() ActiveSheet. You can even protect the entire sheet. Kutools for Excel provides a quite easy way to protect or lock specified cells from editing in Excel: unlock the whole worksheet by Selection Unlock button, next lock the specified cells you will lock from editing by Selection Lock button, at last protect current worksheet. To unselect a range of selected cells hold down the CTRL (or Command for Mac) key and drag the range you want to deselect, starting from within a selected range. Click the chart to which you want to add another data series. Protect worksheet (cells) with password. At First, we will need to select the cells we want to lock. It also allows me to not allow the change of objects, so comments aren't edited. But if you want to lock an image to a cell in Excel 2010 so that you are able to resize or move it, then you have the ability to do so. Excel delivers marketing and telecommunications services for small and medium businesses, as well as the nation wide facilities based infrastructure supporting residential customers, large telecommunications carriers, and everyone in between. Range("C3:D4"). In need to update them monthly from an Excel sheet. Just click and drag in Excel to place the selected shape as shown and give it a name. Insert a text box in Excel from the Insert tab by selecting Text, Text Box, and then use your mouse to drag to a region on your worksheet. First up, start off by highlighting a cell or range of cells that you want to protect. Protect Password:="test", userinterfaceonly:=True Dim shape As shape For Each shape In ActiveSheet. View an alphabetical listing of Excel Tech Tips. I would like to delete all shapes within cell range (B9, I25). How to Align a Picture within a Cell in C#, VB. Step 1: Select the entire. If you want to hide a formula, you have to do TWO things: set the cells to Hidden and then protect the sheet. To do this, select all of the rows and columns in your sheet. Click the 'Insert' tab in Microsoft Excel. Dec 04, 2015 · The title of this article is The Complete Guide to Excel VBA Form Control Checkboxes, but if you can think of something I missed, ask a question in our VBA Q&A platform and let me know! I’ll make the guide MORE complete based on your feedback. This course teaches Microsoft Excel basics. Then do one of the following: "To lock one row only, click. Mar 14, 2012 · The Microsoft Excel Support Team Blog The Microsoft Excel Support Team Blog "The information cannot be pasted because the copy area and the paste area are not the same size and shape" Will Buffington [MSFT] March 14, 2012 20. Apr 26, 2011 · Say we're adding two cells in C1: =A1+B1. If you are not satisfied with the available type of text boxes,. Protect Specific Cells From Editing. Excel 2013 looks a bit different than 2010, but overall it's pretty much the same. To unprotect a worksheet, right click on the worksheet tab and click Unprotect Sheet. Lock Cells Dialog It is also possible to unlock specific ranges of cells in Excel using the Allow Users to Edit Ranges feature in the Review tab. So first, let’s setup our Excel file. After selecting the right-cell, click on the View tab > Freeze Panes > Freeze Panes option in the drop-down menu. The zero value is still inside the cell, but Excel changes how it shows it and it blanks those cells out. Here is the list of keyword combinations I tried in Google: excel - cursor scrolls sheet instead of jumping cells excel - cursor scroll excel - cursor scrolls page excel. below when a SSRS report is exported to excel ,columns in excel get merged and cause issues while printing and exporting to pdf. When you're working with multiple objects or shapes in Excel 2010, you may need to align the objects in certain ways to improve their appearance in the worksheet. All cells are locked now. Finally, protect the sheet. May 26, 2011 · In this tip you’ll learn how to link a cell to a shape in Excel 2007. Click the Design > Protect Sheet or Review > Protect Sheet,. You will now see a familiar dialog pop up. Again, the worksheet must be protected to lock the shape, not the cells. You need an absolute cell reference for subtracting numbers with a number. They ‘spill out’ into the cells to the right-- but the text is actually all in cell B1. It also protects the sheet setting, but sets the User Interface to True so code can still run on the sheet if needed. Select the Scope. Click Protect Sheet, leave the Select Locked Cells check box selected, and then click OK. On the Toolbar, click "Insert" and from "Shapes" select one, say "Rounded Rectangle". To illustrate, suppose the following formulas are in cell D3 and you copy them to cell E4. Lock Excel Cells. Cells(-1,0) – refers to cell B1 (two rows above the top left cell, one column to the left) As you can probably see, this kind of referencing can get a little confusing! It’s usually easier to use the Offset property for this kind of thing. As far as I know that you need to protect the sheet in order to protect any locked image. How to Lock Shapes in Your Excel Dashboards - Duration: 1:45. Sep 26, 2014 · Locked & Hide States For Various Excel Objects. Mar 29, 2019 · How to Freeze (Lock in Place) a Cell in Excel. OR Press the CTRL and C keys. Apr 04, 2019 · Bottom Line: Learn how to lock individual cells or ranges in Excel so that users cannot change the formulas or contents of protected cells. Cells("Angle") = The catch is that the default units of is radians. Excel: Draw an Arrow to Visually Illustrate That Two Cells Are Connected This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. It's also great for repairs, manuals, user discussions, articles, and software updates. End: Moves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on. In this example, a Text Box is being used, but this method will also work for Rectangles and other draw-able Forms shapes. This option works like a switch, either locking or unlocking a cell. Hi, I do not have much experience within Excel VBA but Im trying to write a code that based on a cell value, the arow would change color. Stopping movement of shapes excel 2010 Help. You can insert graphic shapes such as lines, rectangles, block arrows, stars, and other basic shapes in your Excel 2010 charts and worksheets. First up, start off by highlighting a cell or range of cells that you want to protect. Locking cells is a feature in Excel that helps the owner to protect their data. How to Insert a Checkbox in Excel Inserting a checkbox in Excel is an easy task, the checkbox control is available in the Excel developer tools option. By default all cells are locked. Plus a few bonus tips to save time with the setup. This is how you can protect an Excel sheet and lock the entire workbook from changing or opening. Use the Addition Formula in Excel Creating the example shown below in cell C3 is simple when you use a formula to add the values of cells A3 and B3. Is it possible to link the contents of a text box in Excel to data in a cell? A. Right Click > Protection > Uncheck Lock. Protect worksheet (cells) with password. The $ sign in a cell reference affects only one thing: It tells Excel how to treat your references when you copy the cell. Just click and drag in Excel to place the selected shape as shown and give it a name. Typing "SCRL" into Excel help doesn't come up with anything. Now lock/protect the sheet with some password. The On-Screen Keyboard in Windows, Scroll Lock key in white. It also protects the sheet setting, but sets the User Interface to True so code can still run on the sheet if needed. diegolc says:. Scroll to the bottom of the post for those tips. Locking cells is a feature in Excel that helps the owner to protect their data. A shape can be created from a cell, from the Drawing Toolbar, from the Forms Toolbar among what I presume are many other places where shapes can be created. Tom's Tutorials For Excel: Linking a Drawing Object to a Cell Here's how you can link a cell's value to be displayed inside a drawing object. You can also lock cells to not allow certain operations or actions. Add a Character to every cell in Microsoft Excel 2010. Open an Excel file and add the formulas and formatting you need to your sheet. I want to lock these shapes from moving or being dragged / accidentally deleted, but still allowing text to be entered / modified in the cells. How to Insert a Checkbox in Excel in just 5 Minutes (or Less) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Now select the formula in the formula bar so that either the whole formula or just the part you want to lock is highlighted, and then press F4. Say we're adding two cells in C1: =A1+B1. Expanding the height of Excel cells by Smoyhud | March 2, 2008 7:46 AM PST. This code checks which cells are currently visible and selects the first cell below the visible range which is not in view. Microsoft Excel: Fill in a Series of Dates or Numbers You can easily fill a series of cells with consecutive dates in Excel. Select all cells. Restrict users to edit the cell; Lock Cell and Unlock Cell. their content is editable). This makes it easy to view specific data, and keep the original records safe on a hidden worksheet. In this article, we will analyze how to copy and paste multiple cells in Excel. The official Microsoft shortcut for Scroll Lock is Shift + F14. Scale the 3D graph to the same height as the iteration-10 graphs, and put it directly to their right (obscuring some blue text). Learn how to lock cells in Excel and keep vital information on your spreadsheets secure. Click on Text Box 5. A shape can be assigned a hyperlink, by RClick on shape and assign hyperlink. Here is the list of keyword combinations I tried in Google: excel - cursor scrolls sheet instead of jumping cells excel - cursor scroll excel - cursor scrolls page excel. Excel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 Shapes With VBA - Add a new text-box. May 26, 2011 · In this tip you’ll learn how to link a cell to a shape in Excel 2007. Click the Formulas menu. After that Excel doesn't allow to replace the unlocked image in that protected sheet. May 16, 2013 · How to create and lock Text Box in Word 2013. Typing "SCRL" into Excel help doesn't come up with anything. This code allows you to lock and unlock the Aspect Ratio of a shape or picture in PowerPoint. How To Lock Individual Cells and Protect Sheets In Excel - Duration: 8:08. To enter practice data in the cell. Protect Password:="test", userinterfaceonly:=True Dim shape As shape For Each shape In ActiveSheet. May 26, 2011 · In this tip you’ll learn how to link a cell to a shape in Excel 2007. Retrieved November 25, 2019 from www. This is particularly convenient if you want to control the chart colors through your Excel data source in the case of a linked chart. And, as an aside, "Apple's Excel for Mac" is emphatically not among the spreadsheets that "have the ability to lock cells. Hello, Would you please advice of a way to do the following in Excel: My workbook includes 8 worksheets. Changes can also be made with a macro to simplify changes. Written by co-founder Kasper Langmann, Microsoft Office Specialist. Sub DeleteAllShapes() Dim GetShape As Shape For Each GetShape In ActiveSheet. Looking a little closer, Excel displays the characters "SCRL" in the lower right corner when the scroll lock is on. I do a lot of flowcharting and would love to find a way to get Excel to open with shapes set to lock to the cell grid by default (excuse me if the terms aren't always correct - I'm translating from the Italian version of Excel2003). To do this: Click on the worksheet selection cell at the top-right corner of the worksheet to select the entire worksheet. You can lock cells in Excel, as well as lock entire sheets. Save the changes you’ve made. How to make a cell flash in Excel If we are trying to achieve this effect in Microsoft Word, it is actually very straight forward. To hide the formula of a cell, click Format in the Cells panel of the Home tab of the ribbon and check the Format Cells option. Sep 24, 2010 · The Apache OpenOffice User Forum is an user to user help and discussion forum for exchanging information and tips with other users of Apache OpenOffice, the open source office suite. This option works like a switch, either locking or unlocking a cell. Click the Change Shape button on the Quick Access toolbar and choose a new shape for the comment:. You can even protect the entire sheet. Offset(0, 1). By default when you insert a checkbox in excel it will change its position & shape when you expand the cell on which it is placed. If a dollar sign precedes a row number or column letter, the row or column doesn't change when you copy it. Written by co-founder Kasper Langmann, Microsoft Office Specialist. Five tips for working with Excel comments. All cells are locked now. Jan 08, 2011 · In VBA, we can only refer a single cell from another cell but when used as Excel formula, it becomes one of the most important to learn. Microsoft Excel's worksheet password protection options have been known to trip people up from time to time. It is based on request from one of LEM reader who wants to know, How to insert a picture in excel sheet using VBA code It is a very simple one liner code to insert a picture in Excel using vba code. You can't see it, but your skin is constantly under attack by free radicals-damaging molecules that come from light, pollution, cigarette smoke, and more. Value = Player. Jul 23, 2010 · As far as I am aware Excel does not accommodate Events for shapes and so there is no simple way of detecting a change in a shape size and then resizing the shape. name I = I + 1 End If Next End Sub Related examples in the same category. OR Press the CTRL and C keys. How to Insert a Checkbox in Excel Inserting a checkbox in Excel is an easy task, the checkbox control is available in the Excel developer tools option. In cell editing mode, it deletes the character to the right of the insertion point. For example, you could separate columns with thin lines but use a thick border to group several columns together and make them visually distinctive from the rest of the spreadsheet. Step 3: Now we require Commission for each sales representative. Then with Ctrl still down, click on some other cell near the bottom. Locked = True Next End Sub or you build a plugin for Excel in dot. Excel will resize the image and your Excel Sheet will look distorted. Lesson 1: Getting Familiar with Microsoft Excel. NET By default, when we insert an image to a cell, the image automatically be placed at top left corner. In section 2 you will learn all the VBA vocabulary that is essential to work with business data (accounting, sales, production and others). Did you know that you can also link a shape to a cell in. Aug 29, 2012 · Making cells bigger in Excel 2010 is something that can be done using a couple of different methods. Enhanced by intelligence, Excel learns your patterns, organizing your data to save you time. The screen shown here will appear. I don't want the end user to move or edit the shapes and the slicers. If the shapes are grouped where possible it will reduce the amount of fiddling with these properties. It is possible to emulate what you are asking for by using a workaround. Again, the worksheet must be protected to lock the shape, not the cells. Feb 15, 2013 · How to create a Bullet graph using excel charts and within an excel cell February 15, 2013 February 15, 2013 | Alesandra Blakeston Bullet graphs were invented by Stephen Few to improve upon standard bar charts and gauges. So, for example, I have a sheet with some proprietary formulas that I don't want anyone to see! First, I will select the cells in column F, right-click and choose Format Cells. Worksheets( 1 ) oSheet. SathishKumar October 17, 2016 at 08:39:52 Format choose Lock Cell - This will Lock (but not Protect. Bacterial arms race may shape gut microbiome: Large, mobile gene clusters protect against a type of toxic attack by rival bacteria. Instructions on how to install an add-in To replace existing add-in with later version you simply need to overwrite the existing add-in. Ctrl-End to see the 3-D graph. In our example, I typed in excel as the password. Start by selecting the cells you do not want to. With Excel Image Assistant you can easily insert picture into Excel cell or comment, one by one or you can insert multiple pictures at once. Default picture size with Shapes. Finally, protect the sheet. Plus a few bonus tips to save time with the setup. You can insert many types of data in your Microsoft Office Excel spreadsheets, including charts, plain text, images and tables. All that works, but i still can't prevent users from copying pasting the cells with their comments attached. Revision v3. How to Add Shapes in Microsoft Excel. Now from this article, you will learn how to protect Excel workbook from Opening and Editing. Step 1: Open the spreadsheet containing the image that you want to lock to your cell. Excel 2010 Adding Data to an Existing Chart Add a data series to a chart. This illustrated tutorial shows how to freeze cells in Excel. Jun 08, 2016 · This is a great tool to use if you have a spreadsheet that is used by many people and you want to prevent them from accidentally deleting or typing over complicated formulas or valuable data. Say we're adding two cells in C1: =A1+B1. Even the tool tip that shows when you use the mouse to adjust column width is different in Excel for Mac — characters per inch is shown first, followed by inches in parenthesis. Also, there are a lot of other things you can do with comments once you add them to a worksheet like formatting, changing the shape, resizing and so on. If you like this topic, please consider buying the entire e-book. Watch Video - How to Insert Picture into a Cell in Excel A few days ago, I was working with a data set that included a list of companies in Excel along with their logos. Now select Edit in the menu area, and then Copy. After selecting the right-cell, click on the View tab > Freeze Panes > Freeze Panes option in the drop-down menu. This seems easy, but because excel codes the location of an object from the top left of cell A1, it makes it very difficult to work out exactly where the object is on the page. Excel will resize the image and your Excel Sheet will look distorted. The locked cells can easily be unlocked. The newly pasted image of the cells is not necessarily the last item in the Shapes collection. (That's why the air around you might be your skin's biggest enemy. Excel: Locking Cell References - Wisc-Online OER This website uses cookies to ensure you get the best experience on our website. Jul 27, 2019 · Shapes in Excel 2007 and Excel 2010 can be renamed and reordered using the Selection Pane. May 31, 2009 · The Nerve Cell is also called a neuron, its shape and function is it has alot of surface area and is very thin so the diffusion of wastes, water, urea, and other wastes in and out of the blood can. Under Protect, select Shapes, and then click OK. This list is by no means the "be all and end all". As shown in Fig. Each Shape object represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture. Right-click the selected area and go to Format cells, or select Format - Cells from the main menu. Hello Friends, This is a small VBA code to help you in dealing with Protecting and UnProtecting the WorkSheet using Excel Macro. Instructions on how to install an add-in To replace existing add-in with later version you simply need to overwrite the existing add-in. In those cases, here's how to lock (specific) cells in Google Sheets. I know theres a way to do it, I just forget what the formula is. This is usually fine for data entry and dialog forms. Click the comment's border to select it as a Shape (or, Ctrl-click the comment to select it as a Shape). Often times when people are creating dashboards, the shapes that are left on the dashboard are. ScienceDaily. How do I wrap text within a cell in my spreadsheet? To wrap text within a cell, or merged set of cells: Select a cell or group of cells. Insert picture in Excel cell or comment quickly and easily. You need an absolute cell reference for subtracting numbers with a number. -or-Unlock the cells to provide access to a range of cells instead of clicking to select the Allow Users to Edit Rangescheck box. below when a SSRS report is exported to excel ,columns in excel get merged and cause issues while printing and exporting to pdf. You must select a range of cell as wide or wider than the shapes you want to move!. Also, another method would be to unprotect the worksheet, make the necessary changes, and then protect the worksheet again. You can even protect the entire sheet. Next, lock specific cells. So, for example, I have a sheet with some proprietary formulas that I don't want anyone to see! First, I will select the cells in column F, right-click and choose Format Cells. Select the second tab 'Alignment' and set the orientation to 45 degrees. Excel typically displays forms in the center of the screen. Plus a few bonus tips to save time with the setup. Insert call values/references inside of a shape way in which a native Excel formula can reference shapes. What This VBA Code Does. Checkbox and other controls like drop downs can be quite helpful while designing forms in Excel. If you insert a chart in a spreadsheet and you then insert additional data, the position of the chart changes. AddPicture Posted on November 25, 2013 by Rory Archibald I have often resisted using the Shapes. Sep 14, 2011 · IOW, when the workbook is reopened the active cell, or focus as you put it, will be on the activecell as saved. I want to some how change property of shapes so that when I scroll then all cells should move but shape should not move. The code works for me - can you post a workbook. Select the formula (or a part of a formula) in the formula bar, and press F4 to cycle between the 4 reference styles. You then click again where you want your shape to start and then drag to size. This blog describes how you would do that for shapes and there you can use events to overide the delete. This unit is a Dell GX-280 and the problem was in Excel 2003. In order to clear the cell content in Excel, using a macro, you will first need to have a table. Jan 31, 2014 · In excel, the function is called “split cells” but it really means split the data that’s in the cells to be spread out amongst more than one cell. How to Format Data and Cells in Microsoft Excel 2013 Formatting a worksheet can change the look and feel of it. This makes it easy to view specific data, and keep the original records safe on a hidden worksheet. Lock Data Cells 1 year 46 weeks ago; User login. By default, Excel sets the flow chart autoshapes to move when cells are deleted, inserted, or resized. Being able to protect, or lock, a cell or a worksheet can be important to maintaining the integrity of data and formulas in a spreadsheet. Object behind text in cells? The easy way is to copy the cells from excel, put them in word. Don’t forget you can use it on your charts, shapes, textboxes etc etc. When you use a spreadsheet to manage information, adding a checkbox seems like overkill. I have the monthly sales turnover for these districts. Excel Charting Tip- How To Create A Sales Funnel Or Pipeline Chart. On the QAT, click the Change Shape command, and click on a shape to select it. It’s an ordinary lock that prevents accidental changes in the file. On the Freeze Panes button, click the small triangle in the lower right corner. Hide the worksheet and add a password to unhide the worksheet. In need to update them monthly from an Excel sheet. Shapes(1) provides access to the first shape on the activesheet, and Activesheet. percentage, currency, date, or text—helps. Defining a cell name: Select the cell that you wish to name. AppleWorks's spreadsheet module, which used the large, single table model, did offer the ability to lock single cells or groups of cells (but not to assign a password to that lock/unlock operation). To change the shape of a comment, do the following: Make sure that it is visible (right-click the cell and select Show/Hide Comments).