Re: Editing Formulas in Excel for the Mac

2020-04-27 Thread Jonathan Cohn
David, I have Excel on my work Mac, but have never opened it. I do use the insider preview so I have the latest version. I believe in the help menu there is a feedback form, so that might be worth it especially if you are willing to use preview versions of Microsoft Office. Best

Re: Editing Formulas in Excel for the Mac

2020-04-20 Thread Phil Halton
Thanks Dave, I think I’ll stick with numbers. I’ve been using it for a couple years and I’m pretty good with it so thanks for all the answers. Sent from my IPhone > On Apr 20, 2020, at 10:55 AM, Dave Carlson wrote: > > Phil, > Don’t know if you can purchase and install Excel by itself. I sig

Re: Editing Formulas in Excel for the Mac

2020-04-20 Thread Dave Carlson
Phil, Don’t know if you can purchase and install Excel by itself. I signed up for the annual Microsoft Office 365. There are pros and cons with each, Numbers and Excel. With Numbers you can assign column and row headers that will speak as you navigate, but you cannot jump quickly from one popul

Re: Editing Formulas in Excel for the Mac

2020-04-20 Thread Phil Halton
From: 'Tim Kilburn' via MacVisionaries > Sent: Monday, 20 April 2020 12:44 PM > To: macvisionaries@googlegroups.com > Subject: Re: Editing Formulas in Excel for the Mac > > Hi Dave, > > no, you did fine. It was my stupidity. > > Have a good one.. >

Re: Editing Formulas in Excel for the Mac

2020-04-20 Thread Dave Carlson
I notice that VO does not play well with Excel. When I do tap F2 to edit a cell, the formula displayed is always the previous one I visited for editing. I consistently need to press Esc and then F2 again to have the current cell formula in the edit field. Dave Carlson Engineer, Pioneer, Farfar

RE: Editing Formulas in Excel for the Mac

2020-04-20 Thread Simon A Fogarty
Hell, tha’ts something you wont hear a lot! From: 'Tim Kilburn' via MacVisionaries Sent: Monday, 20 April 2020 12:44 PM To: macvisionaries@googlegroups.com Subject: Re: Editing Formulas in Excel for the Mac Hi Dave, no, you did fine. It was my stupidity. Have a good one.. Late

RE: Editing Formulas in Excel for the Mac

2020-04-20 Thread Simon A Fogarty
default you to the cell in the row lower than where you were. From: macvisionaries@googlegroups.com On Behalf Of Dave Carlson Sent: Monday, 20 April 2020 4:17 AM To: 'Donna Goodin' via MacVisionaries Subject: Re: Editing Formulas in Excel for the Mac Nope, Option + Return only moved th

Re: Editing Formulas in Excel for the Mac

2020-04-19 Thread 'Tim Kilburn' via MacVisionaries
Hi Dave, no, you did fine. It was my stupidity. Have a good one.. Later... Tim Kilburn Jamf Certified Tech Apple Teacher (with Swift Playgrounds Recognition) Fort McMurray, AB Canada On Apr 19, 2020, at 18:25, Dave Carlson wrote: Tim, I was talking about Excel. Did I fail to mention that?

Re: Editing Formulas in Excel for the Mac

2020-04-19 Thread Dave Carlson
Tim, I was talking about Excel. Did I fail to mention that? Dave Carlson Engineer, Pioneer, Farfar, Woodworker, Musician, and Oregonian -- The following information is important for all members of the Mac Visionaries list. If you have any questions or concerns about the running of this l

Re: Editing Formulas in Excel for the Mac

2020-04-19 Thread 'Tim Kilburn' via MacVisionaries
Hi, Oops, sorry, I guess I didn't properly read the question. I heard the part about being awesome at Excel on Windows, and wrongfully went to Numbers on the Mac. What a dolt. Sorry Dave. Later... Tim Kilburn Jamf Certified Tech Apple Teacher (with Swift Playgrounds Recognition) Fort McMur

Re: Editing Formulas in Excel for the Mac

2020-04-19 Thread Phil Halton
Option return is the keystroke for numbers spreadsheets, but does it work in excel for Mac? That is what Dave is using isn’t it? By the way I’m a big numbers user and I might like to try XL on the Mac. How is it Accessibility wise and is it a lot like XL and windows? What do I have to do to get

Re: Editing Formulas in Excel for the Mac

2020-04-19 Thread 'Tim Kilburn' via MacVisionaries
Hi, I guarantee that option-return works for this. It has been a feature in Numbers forever. I seem to recall that you're using a non-Apple keyboard. Is it possible that you were not using the actual "Option" key to do the action? Later... Tim Kilburn Jamf Certified Tech Apple Teacher (wit

Re: Editing Formulas in Excel for the Mac

2020-04-19 Thread Dave Carlson
Nope, Option + Return only moved the focus to the cell below. What did work was good old F2. It then positioned the cursor to the immediate right of the last character in the cell. but thanks for pushing me in that direction. Dave Carlson Musician, Engineer, Farfar, Oregonian, Woodworker, and P

Re: Editing Formulas in Excel for the Mac

2020-04-19 Thread 'Tim Kilburn' via MacVisionaries
Hi, No. Simply arrow to the cell you wish to edit, press option-return and the cursor is placed at the end of the information within that cell. If it was just data, you could arrow left/right to manipulate it, or press delete to remove portions of it. If it is a formula, then use left/right

Re: Editing Formulas in Excel for the Mac

2020-04-18 Thread Dave Carlson
Tim, That does not work. Do I need to have any specific settings enabled to edit formulas? Dave Carlson Pioneer, Farfar, Oregonian, Woodworker, Engineer, and Musician -- The following information is important for all members of the Mac Visionaries list. If you have any questions or conc

Re: Editing Formulas in Excel for the Mac

2020-04-17 Thread 'Tim Kilburn' via MacVisionaries
Hi Dave, Press option-return on the cell you wish to edit. Later... Tim Kilburn Jamf Certified Tech Apple Teacher (with Swift Playgrounds Recognition) Fort McMurray, AB Canada On Apr 17, 2020, at 09:33, Dave Carlson wrote: I was a power-user with Excel on the PC, but feel like a total idiot