Results 1 to 4 of 4
  1. #1
    Can you help me with my Excel for Mac?

    Member Since
    Apr 02, 2010
    Posts
    1
    Can you help me with my Excel for Mac?
    Hello. I have just recently started using Excel as I am taking a computer course at night school. There, we are working on Windows machines. I was taught that if I went into Tools and Options, I could change the direction the cursor moves, when I press the return button, from the cell beneath, to the cell to the right. However, when I tried to do the same thing on my MacBook at home, I don't have the Tools and Options facility. I know I could tab across, but I would much rather press the return button and it move across the page. Could anyone help me please?

  2. #2
    Can you help me with my Excel for Mac?
    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    5,833
    Specs:
    Mac Mini Core 2 Duo
    From Excel Help
    Change which cell is selected when you press RETURN
    To move to a different cell when you press RETURN:
    1. On the Excel menu, click Preferences, and then click Edit.
    2. To move to an adjacent cell, select the Move selection after Return check box, and then select a direction in the Direction box.

  3. #3
    Can you help me with my Excel for Mac?

    Member Since
    May 02, 2010
    Posts
    1
    Unprotecting Excel Worksheet
    Hi, i am having trouble unprotecting a worksheet that i created. When i save the file and then try to execute i get a pop up message requesting the password. I initially password protected the worksheet while it was being created for safety reasons, however, now i need to remove it because it needs to be emailed and viewed by another party. How do i go about disabling the protection so when i email the file it can be executed and viewed without having to enter a password?

    I would also like to know how to protect the cells within so when the file is viewed by a third party they are unable to revise the tables or use it for other purposes. After investing days and nights creating this worksheet i want to make it doesn't get copied or used for other purposes beyond my control.

    I am using Excel 2008 version 12.2.4

    Thank you

  4. #4
    Can you help me with my Excel for Mac?

    Member Since
    May 20, 2004
    Posts
    243
    Specs:
    iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB
    Quote Originally Posted by Wonderboynyc View Post
    Hi, i am having trouble unprotecting a worksheet that i created. When i save the file and then try to execute i get a pop up message requesting the password. I initially password protected the worksheet while it was being created for safety reasons, however, now i need to remove it because it needs to be emailed and viewed by another party. How do i go about disabling the protection so when i email the file it can be executed and viewed without having to enter a password?
    Can;t remember exactly, but I think in Preferences somewhere.

    I would also like to know how to protect the cells within so when the file is viewed by a third party they are unable to revise the tables or use it for other purposes. After investing days and nights creating this worksheet i want to make it doesn't get copied or used for other purposes beyond my control.

    I am using Excel 2008 version 12.2.4

    Thank you
    You can lock individual cells or even just the one worksheet to prevent changes. However, nothing will prevent someone from copying. Once you send it to someone you have no control over how it is used/misused. If VBA were available you could make it a little more difficult, but even then it would take rather extensive director-type programming in VBA to prevent copying.
    Mellel 3, NWP 2, Scrivener 2.3.1, Tinderbox 5.11.2
    LibreOffice 3.6, Accordance 10.0, Adobe CS4, DTP 2.4.3
    OS X 10.8.2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel on Mac
    By keterlina in forum OS X - Apps and Games
    Replies: 5
    Last Post: 08-01-2015, 12:44 PM
  2. Excel for Mac and Excel for Windows
    By newbimac in forum OS X - Apps and Games
    Replies: 2
    Last Post: 02-26-2012, 08:04 PM
  3. MAC excel 08 vs PC excel 07
    By gcookie in forum OS X - Apps and Games
    Replies: 2
    Last Post: 05-30-2010, 11:32 PM
  4. Excel for Mac QM
    By ItchyBone in forum OS X - Apps and Games
    Replies: 0
    Last Post: 10-06-2008, 06:47 PM
  5. Replies: 4
    Last Post: 02-08-2004, 11:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •