This tip (3145) applies to Microsoft Excel 97, 2000, 2002, and 2003. Due to the size of my workbooks, this row highlighting is very useful. Advertisements do not imply our endorsement of that product or service. Run the Fix It tool for under the Office 2003 sectionin the ...(more) Q:Create Correlation Matrix in excel without add ins and VBA. this content
Undoing edits When you want to reverse your last action in a worksheet, click the Undo button or press Ctrl+Z. Join our site today to ask your question. Anyway, I was able to set the entry to 16 (the normal default value), and I'm back to normal. Click it; you can start the undo action.
You can't undo some actions, such as clicking commands on the File tab or saving a file. Style Default Style Contact Us Help Home Top RSS Terms and Rules Copyright © TechGuy, Inc. If you are using a later version (Excel 2007 or later), this tip may not work for you. I replaced the VB to what you supplied, then replaced the Conditional Formatting to what you provided.
all of a sudden today i can not undo or redo anything in excel. He is president of Sharon Parq Associates, a computer and publishing services company. Please start a New Thread if you're having a similar issue.View our Welcome Guide to learn how to use this site. Undo Not Working In Excel 2013 But I'll take a look at that, too.
In fact, it made it worse. Here are the instructions that I wrote to a help file, created from the video's instructions: Highlight Selected Cell’s Entire Row (Via Macro, in Excel 2010) Source: http://www.youtube.com/watch?v=bGjqDGF7xaM Click on FORMULAS One common reason is that you have AutoSave set up with a very short interval. Output the first position in your program for each input character Review of my T-shirt design Where is the Abbey of the Albertian Order of St.
Unless you can think of anything else? How Many Times Can You Undo In Excel 2013 Commander Keen10-10-2007, 04:48 PMSomething could have been done via another program that modified the registry and changed the saved number of Redo/Undo commands to zero (default is 16, IIRC). Home Products Classic Menu for Office 2007 Classic Menu for Office 2007 Applications --------------------------------------------------------------------------- Classic Menu for Office Classic Menu for Office Enterprise Classic Menu for Office Home and Business Classic A:Let's say your data is the 60 columns A through BH on a sheet called "data".
I accidently discovered if I add the quick print to the Quick Access toolbar and print from that it works OK. No love. How To Modify The Number Of Undo Levels In Excel 2013 I then discovered if I click on the REDO button and carefully highlighted each line, it gave the option of 'undo one action' or undo 'tow (last) actions etc. Change Number Of Undos In Excel 2013 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
Click on that and you get 2 more. news In Windows 10 or Windows 8, right-click the Start button and click Run. How can we improve it? I'll report back in a few moments. Excel 2016 Undo Levels
Join over 733,556 other people just like you! Solved: Can't Undo in Excel 2003 Discussion in 'Business Applications' started by sailracer, Mar 12, 2010. sailracer, Mar 12, 2010 #1 Sponsor Pedro15 Joined: Oct 5, 2008 Messages: 376 Is sheet protected? have a peek at these guys No problem, it was an interesting problem and it's actually quite a neat trick.
Close any Office programs that are running. Can't Undo In Excel 2013 By the way, Microsoft Office 2007, 2010, 2013 and 2016 support undo and redo more than 100 actions. Loading...
What are these boxes mounted inline on each of the 3 phase wires of a high voltage power line in Miami? Register To Reply 07-12-2013,07:42 AM #2 zumbalj View Profile View Forum Posts Forum Contributor Join Date 08-15-2012 Location Ohio MS-Off Ver Excel 2007 Posts 245 Re: Why do some Excel documents ADoubleDot08-20-2010, 05:46 PMIt seems like you bumped a very old thread. Excel Clear Undo Stack First answer posted by NataliaPeterson at 04/16/2012 07:12 Add Your Answer 10~1000 characters in length CAPTCHA: Post without login 4 Answers NataliaPeterson I suspect that what is happening is that you
Please find the Undo icon Â in the quick access toolbar. Brothersoft.comWindows|Mac|Mobile|Games |Message Solve software problem quickly Share experience to help others Improve the ability of solving problem Find answers Ask a question Tags: office tools MS Excel 2007 office toolsÃ— MS View the most recent issue. check my blog Pedro Pedro15, Mar 12, 2010 #2 sailracer Thread Starter Joined: Mar 12, 2010 Messages: 6 Thanx for the reply.
No, create an account now. Right click the sheet tab of the worksheet where this is happening - View code - what do you see on the right hand side? Posts 4,418 Re: Why do some Excel documents NOT allow me to Undo/Redo when using THIS Macro? 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.
In the Edit DWORD Value dialog box, click Decimal under Base. Leave your own comment: *Name: Email: Notify me about new comments ONLY FOR THIS TIP Notify me about new comments ANYWHERE ON THIS SITE Hide my email address *Text: *What So change your conditional formatting to: =if(Cell("row")=row(A1),True,False) and your macro to Please Login or Register to view this content. I come from the world of graphic design so I am used to things like Adobe's History pallets.
The following procedure uses the Registry Editor to change the number of undo levels for Excel, although you can do the same in Word or PowerPoint. Register To Reply 07-12-2013,10:49 AM #6 Sandcastle View Profile View Forum Posts Visit Homepage Forum Contributor Join Date 05-23-2013 Location Mississauga, ON MS-Off Ver Excel 2010 Posts 135 Re: Why do Grab it and move it onto the main screen entirely. For instance, running some macro commands can cause the stack to be cleared, and saving the workbook clears the undo stack.