Forum Discussion

ckeenan2691275's avatar
ckeenan2691275
Copper Contributor
Dec 20, 2023

@ sign and more in Excel

I have used @sum since that was used in Lotus123...suddenly now I have to use = sign... does it have to be that way? Also, I toggle between screens with alt tab, but now that toggles but it also br...
excel
Rodrigo_'s avatar
Rodrigo_
Iron Contributor
Dec 21, 2023

Hello ckeenan2691275,

 

Let's address you concerns one by one:

  1. Excel Formulas (@sum vs =sum): In Excel, formulas traditionally start with the equal sign (=). The use of the at sign (@) as the formula initiator is not a standard or officially supported feature in Excel. If you were able to use the @ sign to start formulas in the past, it might have been due to specific settings, configurations, or perhaps a third-party add-in or customization that allowed for such behavior. However, this is not part of the default behavior in standard Excel installations. So, it’s recommended to use the equal sign (=) to start formulas in Excel.
    You have a same question here:  Re: @SUM not working - Microsoft Community Hub
  2. Alt-Tab Issue: The issue you’re experiencing with Alt-Tab could be due to a variety of reasons, such as incompatible display settings, outdated GPU drivers, misconfigured display settings, too many programs running at the same time.
    You can refer on this site: Fixed: Black Screen After Pressing Alt + Tab Windows 11/10 - MiniTool
  3. Clipboard History: If you want to disable the clipboard history feature in Windows, you can do so by following these steps:
    1. Open Settings.
    2. Click on System.
    3. Click on Clipboard.
    4. Turn off the “Clipboard history” toggle switch.

Resources