Forum Discussion

AlexProfile's avatar
AlexProfile
Copper Contributor
Mar 18, 2023

Shortcut Key for Converting Value In Cell to Absolute Value

In Office Home & Student 2021, I need an absolute value shortcut key(s) to change many possibly negative numbers in a spreadsheet to absolute values.  A general search has yielded shortcuts, but they...
Formulas and Functions
AlexProfile's avatar
AlexProfile
Copper Contributor
Mar 18, 2023

HansVogelaar 

Hi,

Thanks for the help.  I'm surprised they eliminated shortcuts for this, which apparently existed in earlier versions of Excel.

thanks again,

Alex Phillips

 

HansVogelaar's avatar
HansVogelaar
MVP
Mar 18, 2023

AlexProfile 

As far as I know, there has never been a built-in shortcut for this. I've been using Excel since 1986.

  • AlexProfile's avatar
    AlexProfile
    Copper Contributor
    Mar 18, 2023
    Thanks for telling me so I give up the eternal search for one.

    Alex
    I will try your macro either today or tomorrow.

Resources