New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Can you help me with my Excel for Mac?


Post Reply New Thread Subscribe

 
Thread Tools
Ladylee33

 
Member Since: Apr 02, 2010
Posts: 1
Ladylee33 is on a distinguished road

Ladylee33 is offline
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?
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,497
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
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.
QUOTE Thanks
Wonderboynyc

 
Member Since: May 02, 2010
Posts: 1
Wonderboynyc is on a distinguished road

Wonderboynyc is offline
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
QUOTE Thanks
shades

 
Member Since: May 20, 2004
Posts: 243
shades is a jewel in the roughshades is a jewel in the rough
Mac Specs: iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB

shades is offline
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.

Quote:
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
QUOTE Thanks

Post Reply New Thread Subscribe


« QuickBooks Users | Online articles to "Read it later"! »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Excel - quits automatically and gives error report I don't understand aprildentist OS X - Apps and Games 1 09-28-2009 01:21 PM
how to copy a row of excel to firefox chidambaram OS X - Apps and Games 0 06-04-2009 03:26 AM
Updating Excel document over a network? Garnon OS X - Apps and Games 3 05-26-2009 03:41 AM
Best setup for gaming & advanced excel chssvl Running Windows (or anything else) on your Mac 4 04-14-2009 03:58 PM
Changing serial for Excel for Mac pegasus OS X - Apps and Games 1 04-08-2008 09:27 AM

All times are GMT -4. The time now is 02:08 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?