Home

How to Add a Cell Value to a Formula with a Single Click

S_Rubinstein
Occasional Visitor

Hi,

 

I've been using an old version of Excel on a Mac for years.  I recently downloaded the most recent version from Office 365.

 

In the past I could have a formula like =(C4+C8) and then I could click in the cell that has this formula and then click another cell to add another entry e.g. =(C4+C8+C14).  Now I have to type a '+' before clicking the cell I want to add.  Is there anyway to get the old functionality back?

 

Thanks.


Cheers.

1 Reply
Hi:

I don't have an old MAC with Excel but I do remember when you typed in (in many old spreadsheet) 23+14 and 37 would appear in the cell. Modern spreadsheet require you put an = sign or it will treat the entry as text ie show 23+14 as the result. Apparently your old spreadsheet would assume that the nest cell was to be added to entry but assume that you had a formula =c4+c8-c12 and you added a cell what would you expect to happen: + or - Its ambiguous. explicitly puting the action (+ or - or * or ** or?) solves that problem. It took me a while to get used to putting the = sign and I guess you will need to learn to put the + sign in. Sorry
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies