share|improve this answer answered Nov 27 '12 at 16:55 Dale 311 add a comment| up vote 2 down vote I guess you were following this article to change the value. slurpee55, Mar 17, 2010 #4 sailracer Thread Starter Joined: Mar 12, 2010 Messages: 6 Thanx for the reply, slurpee55. Thanx to all who helped on this. He is president of Sharon Parq Associates, a computer and publishing services company. http://culturahq.com/in-excel/excel-sort-greyed-out.html
Important: Remember that some actions, such as clicking commands on the File tab or saving a file, can't be undone, and running a macro in Excel will clear the undo stack, making Subscribe Get tips like this every week in ExcelTips, a free productivity newsletter. NoYes × Voted Successfully! × You can't vote for yourself × You can't choose your own answer × Loading ExcelTips (Menu Interface) This Site Got a version of Excel that uses Join our site today to ask your question. navigate to these guys
You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Increasing Undo Levels. It simply means that you use Undo and Redo to switch back and forth between the result of an action and the state of the worksheet just before that action until To remove it from quick access toolbar, just uncheck the box in front of it.
mona is not in the sudoers file. You can circumvent this problem by disabling the COM Add-in in your SAS Add-in Excel session. As long as I don't click outside the cell being edited the undo button is active and will undo any changes...as long as I don't click on another cell. Can't Undo In Excel Advertisements do not imply our endorsement of that product or service.
When ever you run code in a workbook the undo stack is cleared. Where Is The Undo Button In Excel 2013 By the way, Microsoft Office 2007, 2010, 2013 and 2016 support undo and redo more than 100 actions. Select 2D data in a certain range What is the temperature of the brakes after a typical landing? http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/undo-redo-buttons-constantly-grayed-out-in-excel/84d85228-60eb-4715-ac8d-e3aa5066ca57 The following Knowledge Base article explains how you can make changes to the proper Registry setting in Excel 2000, 2002, and 2003: http://support.microsoft.com/kb/211922 If you are using Excel 97, you can
If you are using a later version (Excel 2007 or later), this tip may not work for you. How To Modify The Number Of Undo Levels In Excel 2010 Actually, this sounds more complicated than it is. http://support.microsoft.com/kb/211922 Was this answer helpful? 00 · 04/16/2012 07:12 Anonymous user Well, don't know if this works for you, but .. Is Area of a circle always irrational Need to change cash to cashier's check without bank account (Just arrived to the US) Count trailing truths How do we assign an initial
Redo an action To redo something you've undone, press Ctrl+Y or F4. (If F4 doesn't seem to work, press the F-Lock key, then F4). Or click Repeat on the Quick Access Toolbar. Excel Undo Button Greyed Out Screen Shot of Classic Menu for Excel Awards More Awards & Reviews Products Brings Back Old Menus to Excel 2007 Brings Back Old Menus to Excel Brings How To Redo In Excel By default, Excel maintains your last 16 actions, but this number of undo levels can be misleading.
sailracer, Apr 24, 2010 #12 Sponsor This thread has been Locked and is not open to further replies. check over here To undo several actions at the same time, click the arrow next to Undo, select the actions in the list that you want to undo, and then click the list. Classic Menu for Office It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013 and 2016. In Windows XP, click the Start button, and then click Run. Undo Not Working In Excel 2013
Providing high-quality answers to be a verified Q&A expert 2. I looked for macros that could be running - though that might be the problem, but there were none. Deselect the SAS COM Add-in, and click OK. http://culturahq.com/in-excel/tab-key-not-working-in-excel.html Advertisement Recent Posts AVG issues possibly connected...
Find the feautre on Classic Menu Click Menus tab, you can get the classic style interface. All rights reserved. If you move an entry to a new part of the worksheet by dragging it, the Undo button's ScreenTip changes to Undo Drag and Drop. Microsoft Word Undo Button Disabled If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.
Toggle navigation Search Submit San Francisco, CA Brr, it´s cold outside Learn by category LiveConsumer ElectronicsFood & DrinkGamesHealthPersonal FinanceHome & GardenPetsRelationshipsSportsReligion LearnArt CenterCraftsEducationLanguagesPhotographyTest Prep WorkSocial MediaSoftwareProgrammingWeb Design & DevelopmentBusinessCareersComputers Online One common reason is that you have AutoSave set up with a very short interval. If you can't undo an action, the Undo command is dimmed. . weblink If you forget to strike when the iron is hot, so to speak -- by using the Undo feature to restore the worksheet to its previous state before you choose another
Excel will then undo this action and all actions that precede it in the list (which are automatically selected).You can undo multiple actions at one time. In the Edit DWORD Value dialog box, click Decimal under Base. Click on that and you will have 1 menu option. Are you looking for the solution to your computer problem?
sailracer, Mar 17, 2010 #3 slurpee55 Joined: Oct 20, 2004 Messages: 7,837 First, try hitting Esc. Or, click Redo in the upper-left corner of the ribbon. (The Redo button only appears after you've undone an action.) Repeat an action To repeat something simple, such as a paste Another possible reason is that the number of undo levels in your installation of Excel has been changed. To undo several actions at the same time, click the arrow next to Undo , select the actions in the list that you want to undo, and then click the list.
The below link explains how to correct the problem. At the far right will be a down arrow. This cannot be done within Excel itself, but can be done in the Windows Registry. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features.
If that doesn't work, at the upper left are 3 dots where you can click onto the toolbar to move it. Similar Threads - Solved Can't Undo Need a simple code I can't seem to get right Farmermg1, Sep 16, 2016, in forum: Business Applications Replies: 1 Views: 202 OBP Sep 17,