Forum Discussion
ckeenan2691275
Dec 20, 2023Copper Contributor
@ 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 brings up black boxes that have to be cleared with escape each time? Can that be changed back to just toggle?
Finally, text keeps getting saved to clipboard, even thought I don't use clipboard is there a way to turn this off?
thank you
1 Reply
Sort By
- Rodrigo_Steel Contributor
Hello ckeenan2691275,
Let's address you concerns one by one:
- 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 - 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 - Clipboard History: If you want to disable the clipboard history feature in Windows, you can do so by following these steps:
- Open Settings.
- Click on System.
- Click on Clipboard.
- Turn off the “Clipboard history” toggle switch.
- 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.