Skip navigation

How to lock numbers

555 Views 5 Replies Latest reply: Apr 22, 2013 12:11 AM by Yellowbox RSS
RichardJan Calculating status...
Currently Being Moderated
Apr 19, 2013 3:29 AM

I locked excel file in microsoft but when i open in Mac Numbers. He lock automatically. why? Someone have solutions?

MacBook Pro, OS X Mountain Lion (10.8.2)
  • Yellowbox Level 4 Level 4 (3,890 points)
    Currently Being Moderated
    Apr 19, 2013 4:05 AM (in response to RichardJan)

    Hi RichardJan,


    Is your Numbers document locked? Or are the Tables in Numbers locked?


    To lock or unlock a Table in Numbers, click on the Table in the left pane ('Sheets'). Then:


    Pages > Menu > Arrange > Lock or Unlock


    If your Numbers document is locked, there is another problem. Please reply with more information.




  • Yellowbox Level 4 Level 4 (3,890 points)
    Currently Being Moderated
    Apr 21, 2013 5:00 PM (in response to RichardJan)

    Thanks for the green tick.


    The Number'09 User Guide (download from the Help Menu in Numbers) explains how to password-protect a document (Page 31) and how to lock a document (Page 34).




  • Yellowbox Level 4 Level 4 (3,890 points)
    Currently Being Moderated
    Apr 22, 2013 12:11 AM (in response to RichardJan)

    When you import an Excel document into Numbers, the Excel password protection is removed. You can add password protection to a Numbers document, but that may not carry over if you export to Excel.


    You can export from Pages to PDF and lock the PDF file. Page 237 of the Numbers User Guide: Exporting a Spreadsheet in PDF Format


    1. Click the Security Options disclosure triangle to password-protect the PDF.





    MacBook Pro (13-inch, Mid 2012), OS X Mountain Lion (10.8.3)


More Like This

  • Retrieving data ...

Bookmarked By (0)


  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. 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 Apple Support Communities Terms of Use.