By using shortcut.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

73 Shortcuts for Excel



Shortcut 27 - Ctrl+F3 - Name Manager


You can bring up the Name Manager Dialog box via Ctrl+F3



Named ranges can make your spreadsheet more
  • Readable
  • Maintainable
  • Less prone to errors

    The formula:
    =A1+A1*B2

    could be rewritten as

    =amount+amount*tax_rate

    Which is easier to understand?


    •    ←Ctrl+` - Toggle Show formulas | →Shift+F2 - Insert Comment | Table of Contents | Send us your feedback | Random | © 2025 All Rights Reserved | Edit