Add Shortcut For Increasing Decreasing Decimal - Excel Help Forum

Home » Add Decimal Excel Shortcut » Add Shortcut For Increasing Decreasing Decimal - Excel Help Forum

Maybe your like

Excel Help Forum
  • Register
  • Help
  • Forgotten Your Password?
  • Username Password Remember Me?
Excel Help Forum
  • Advanced Search
  • Home
  • Forum
  • Microsoft Office Application Help - Excel Help forum
  • Excel General
  • [SOLVED] add shortcut for increasing decreasing decimal
+ Reply to Thread Results 1 to 9 of 9 add shortcut for increasing decreasing decimal
  • LinkBack
    • LinkBack URL LinkBack URL
    • About LinkBacks About LinkBacks
  • Thread Tools
    • Show Printable Version
    • Subscribe to this Thread…
  • Rate This Thread
    • ‎ Excellent
    • ‎ Good
    • ‎ Average
    • ‎ Bad
    • ‎ Terrible
  • Display
    • Linear Mode
    • Switch to Hybrid Mode
    • Switch to Threaded Mode
  1. 09-21-2015, 01:36 PM #1 ammartino44
    • View Profile
    • View Forum Posts
    ammartino44 is offline Forum Contributor Join Date 08-14-2013 Location LA Baby!! MS-Off Ver Excel 2007 Posts 1,598

    add shortcut for increasing decreasing decimal

    Hello. How can I add a shortcut that will increase/decrease decimals? For examples, cntrl something.
    Reply With QuoteRegister To Reply
  2. 09-21-2015, 01:40 PM #2 FDibbins
    • View Profile
    • View Forum Posts
    FDibbins is offline Administrator FDibbins's Avatar Join Date 12-29-2011 Location Duncansville, PA USA MS-Off Ver Excel 7/10/13/16/365 (PC ver 2310) Posts 53,053

    Re: add shortcut for increasing decreasing decimal

    There are buttons of the ribbon that already do that. why re-invent the wheel?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button) 2. If your question is resolved, mark it SOLVED using the thread tools 3. Click on the star if you think someone helped you Regards Ford
    Reply With QuoteRegister To Reply
  3. 09-21-2015, 01:46 PM #3 MrShorty
    • View Profile
    • View Forum Posts
    MrShorty is offline Forum Guru Join Date 04-13-2005 Location North America MS-Off Ver 2002/XP, 2007, 2024 Posts 16,659

    Re: add shortcut for increasing decreasing decimal

    I added those buttons to the "quick access toolbar" (I'm not sure if you are familiar with this feature). Items on the quick access toolbar can be quickly accessed by alt-#, where the number is chosen by the commands position on the toolbar. In mine, I have the increase decimal button as the 4th item on the quick access toolbar, so alt-4 increases decimal. You can customize the quick access toolbar by clicking on the office symbol (alt-f), selecting Excel Options at the bottom, then "customize" to bring up the customize quick access toolbar menu. Add and remove buttons/commands as desired. You can also use the alt key to access all of the ribbon commands. Press the alt key, and the key to access each ribbon group is displayed. Press that key to access that group and bring up the key sequence for the commands on that ribbon group. For example, the decrease decimal command can be accessed as alt-h (home group) -> 9. Only one more keystroke than putting the command on the quick access toolbar or using VBA to create a macro and assign it to a shortcut key.
    Last edited by MrShorty; 09-21-2015 at 01:49 PM.
    Quote Originally Posted by shg Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  4. 09-21-2015, 01:47 PM #4 MarvinP
    • View Profile
    • View Forum Posts
    MarvinP is offline Forum Guru MarvinP's Avatar Join Date 07-23-2010 Location Woodinville, WA MS-Off Ver Office 365 Posts 16,453

    Re: add shortcut for increasing decreasing decimal

    Is this what you are looking for? https://kb.wisc.edu/helpdesk/page.php?id=1567#Office 2007/2010/2013 or http://help.isu.edu/index.php?action...=66&docid=1025
    One test is worth a thousand opinions. Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  5. 09-21-2015, 01:53 PM #5 daffodil11
    • View Profile
    • View Forum Posts
    daffodil11 is offline Forum Expert daffodil11's Avatar Join Date 07-11-2013 Location Phoenixville, PA MS-Off Ver MS Office 2016 Posts 4,465

    Re: add shortcut for increasing decreasing decimal

    Outside of the standard Alt+H+9 or Alt+H+0, you could write your own macros and hotkey them under options. I put them as Ctrl+Shift+A, and Ctrl+Shift+S. Please Login or Register to view this content. Please Login or Register to view this content.
    Make Mom proud: Add to my reputation if I helped out! Make the Moderators happy: Mark the Thread as Solved if your question was answered!
    Reply With QuoteRegister To Reply
  6. 09-21-2015, 05:11 PM #6 ammartino44
    • View Profile
    • View Forum Posts
    ammartino44 is offline Forum Contributor Join Date 08-14-2013 Location LA Baby!! MS-Off Ver Excel 2007 Posts 1,598

    Re: add shortcut for increasing decreasing decimal

    Oh the alt- for the quick access toolbar is what I'm talking about!!!! Booooooom.
    Reply With QuoteRegister To Reply
  7. 09-21-2015, 06:12 PM #7 ammartino44
    • View Profile
    • View Forum Posts
    ammartino44 is offline Forum Contributor Join Date 08-14-2013 Location LA Baby!! MS-Off Ver Excel 2007 Posts 1,598

    Re: add shortcut for increasing decreasing decimal

    @ daffyduck. Could you please explain your macro code? What does the cstr do?
    Reply With QuoteRegister To Reply
  8. 09-21-2015, 06:19 PM #8 shg
    • View Profile
    • View Forum Posts
    shg is offline Forum Expert shg's Avatar Join Date 06-20-2007 Location The Great State of Texas MS-Off Ver 2010, 2019 Posts 40,689

    Re: add shortcut for increasing decreasing decimal

    .... deleted ....
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  9. 09-22-2015, 01:08 PM #9 daffodil11
    • View Profile
    • View Forum Posts
    daffodil11 is offline Forum Expert daffodil11's Avatar Join Date 07-11-2013 Location Phoenixville, PA MS-Off Ver MS Office 2016 Posts 4,465

    Re: add shortcut for increasing decreasing decimal

    The C functions of VB convert things. ConvertToString (CStr), ConvertToInteger(CInt), ConvertToLong(CLng), etc. that convert from data type to another. It was possibly an unnecessary step, but the aim was to make sure the input of the number format was the string "0.00", "0.000", etc.
    Reply With QuoteRegister To Reply
+ Reply to Thread « Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Determining the increasing, decreasing and local min and max of a dataset
    By istvan60 in forum Excel Formulas & Functions Replies: 0 Last Post: 12-07-2013, 08:01 AM
  2. Finding a decreasing value from a list of increasing numbers
    By Polaris11 in forum Excel Programming / VBA / Macros Replies: 4 Last Post: 10-05-2011, 06:13 PM
  3. Decreasing and Increasing in excel 2007
    By BlessedChild42 in forum Excel - New Users/Basics Replies: 1 Last Post: 12-27-2009, 12:47 AM
  4. Increasing and decreasing depending of column C
    By caldera55 in forum Excel Formulas & Functions Replies: 0 Last Post: 06-25-2008, 06:33 PM
  5. increasing/decreasing by one
    By pagheca in forum Excel General Replies: 2 Last Post: 05-14-2008, 04:57 AM
  6. increasing/decreasing; decreasing rate - problem
    By vasyuta in forum Excel General Replies: 0 Last Post: 08-23-2006, 05:26 PM
  7. increasing and decreasing a value in a cell
    By cwal in forum Excel Formulas & Functions Replies: 6 Last Post: 04-14-2006, 01:55 PM

Bookmarks

Bookmarks
  • Submit to Digg Digg
  • Submit to del.icio.us del.icio.us
  • Submit to StumbleUpon StumbleUpon
  • Submit to Google Google

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  • BB code is On
  • Smilies are On
  • [IMG] code is Off
  • HTML code is Off
  • Trackbacks are Off
  • Pingbacks are Off
  • Refbacks are Off

Forum Rules

-- vB4 Default Style -- Mobile Style Premium -- Lightweight -- Fully Optimized -- Mobile_V1 All times are GMT -4. The time now is 04:52 PM. Search Engine Friendly URLs by vBSEO 3.6.0 RC 1

Tag » Add Decimal Excel Shortcut