Locking and unlocking a cell in Excel 2011 for Mac. Unlock a cell by selecting it and then press Command-1 to display the Format Cells dialog. Click the Protection tab in the Format Cells dialog and then deselect the Locked option. If you installed the MVP Toolbar, you can simply click the Lock/Unlock Cell toggle button on the toolbar. On the MVP Toolbar, the Lock Cell button acts as status indicator.
What do you mean by 'be the absolute function'? Does this mean it inserts the ABS function into the selected cell, changes the selected cell reference from relative to absolute, or what?
F4 in Excel for Mac (2010) is 'Paste text into active cell', which is not really necessary as it is duplicated by cmd-V. The Fx keys require pressing the fn key on the keyboard in addition to pressing the Fx fey. F4 in Excel for PCs is the 'repeat last function' key. Numbers does not have this. Apparently Excel for the Mac doesn't either.
And are we talking Excel or Numbers? You can sometimes get Excel questions answered here but this is a forum for Numbers.
Message was edited by: Badunit. Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site.
All postings and use of the content on this site are subject to the.