I have a spreadsheet that I need multiple users from different desktops to be able to use on a server network. I have formatted a spreadsheet to allow the cursor to move to the right instead of down using the below function:
Click the MS Office Button in the Upper Left
Click the Excel Options button at the bottom of the MS Office Workpane
Go down the list to ADVANCED, click on it
Under Editing Options the VERY FIRST choice, make sure the After pressing Enter, move selection box is CHECKED.
In the Direction Box immediately below, use the drop down list box and choose:RIGHT
This works great, until you open a new spreadsheet, and it wants to use the same logic. Or in my case, every person would have to install the options on thier computer and then turn back when they are done. I want to only have it use this method on this particular spreadsheet - any thoughts on how to do?
thanks!
Bookmarks