I have a macro that fires on the 'Worksheet_SelectionChange' event. The macro validate data of one column, it changes the background color of the cell if its wrong. Learn how to save your Excel data as a read-only file in Adobe PDF format. You can save and send the file as an email attachment or create a PDF file that.
How to Use Undo and Redo Functions Excel 2. We all make mistakes from time- to- time andof course working with Excel is no exception. Let's imagine maybe we're going to make a serious mistake here. We want to get rid of these numbers and maybe we've just got row 2 selected andaren't thinking so clearly.
Excel Save Shortcut Keys. This Excel tip covers how to quickly save data using a shortcut keys on the keyboard in Excel. The key combination that can be. This is about Excel object model reference, where we open and save excel file using vbscript programming. This concept is included in qtp, a tool to. Excel Spreadsheet. Microsoft Excel is an electronic spreadsheet. As with a paper spreadsheet, you can use Excel to organize your data into rows and columns and to. Microsoft Word Training. Our free online Microsoft Word training can develop your Microsoft Word skills. It covers text entry, formatting, spell check.
I have a lot of Excel sheets for all sorts of things - but none has ever acted up like this one here: This used to be a totally normal Excel 2007 sheet which I was. How to Recover an Excel File That Was Saved Over. It happens to everyone. You pause to save a file only to realize to your horror that you just saved over the wrong file. Show more Using Save or Save As provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2013 Essential Training show less.
Cell A, too, might look like it's not part of the mix here. So, you might go to Delete here, maybe you're exploring the commands, you're notfamiliar with how they work, you happen to click this and you realize that dida lot more than you wanted it to do. So, you'd like to reconsider all of that. In the Quick Access Toolbar- -unless you've removed the button and I stronglysuggest that you probably didn't and hope you didn't- -the Undo button is right here and it's followed by the word representing whatyou last did, the last action you took- -in this case "Delete".
Recognize also the keystroke shortcut for undo, Ctrl+Z. So, we're going to pressthis Undo button and bring back the row that we destroyed there by mistake.
Now, not only can we undo our last action, but possibly the ones before that as well. With a little drop arrow to the right of undo- -if you click it- -shows us up toas many as a hundred different actions. Now, maybe I just opened the file, I've done some other formatting, so this oneonly goes back 1. I think rarely do you want to go back that far, but you can consider undoing awhole series of steps, but you can only undo a consecutive set.
Using Undo and Redo provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2013 Essential Training.
So, if I wanted to go back and undo some of the other things that I've beendoing in the meantime- -maybe I was working with data in other cells- -if I want to undo some of those actions but only a consecutive set of them, if Iwere to click right now for example, I would undo the last seven actions. Now, let's take a few actions on the screen here and maybe again we're novices,we're experimenting here, we've heard that you might be able to add color. So, we drag across this. This is covered in a later movie, but we're going to click this button righthere and make everything yellow. We sort of like that maybe for a while. Here's some button here it says "Font Color", so let's hit the drop arrow andwe'll try something here maybe, something that's going to show up, maybe that. Maybe we like Bold, there's B, we'll try that too.
So, we're experimenting with some formatting features here. Maybe we use this for a while and we say, "I'm not sure if I like that".
Now, we might have done other thing things in the meantime. Maybe we put in some data down here.
Maybe put in some numbers. Now, if we want to go back and undo some of the formatting that we did, if we goback to the drop arrow just to the right of undo, it also includes the recenttyping that we just did. Now, if it's okay to get rid of those, we will, if we want to get rid of Bold,well, maybe we do and the font color we made in the format. The point is we have the choice of deleting these, but only theconsecutive actions. So, if we go back this far, we will still be leaving the font color in the background. If we include the font, then we will be getting rid of that font color inaddition to our two typing entries in the Bold. So, let's say we do that.
Now, anytime you undo actions, whether it's one or many, the actions that youundid are stored in a different category called "redo". There's another arrow over here called Redo. It's got a keystroke shortcut of Ctrl+Y. So, if we click drop arrow here, we willsee the features that we just undid and maybe we undid more than we wanted to.
So, to undo the undo, it's called "redo". Maybe we want to bring back the font color and the Bold that we had applied, so we'll do that. Now, part of this is being set up just, for example purposes, but I think youcan sense how sometimes you use undo, because you really made a serious mistakeand you want to undo it. At other times you might even want to kind of toggle back and forth between changes. This is not the best example of it, but we might, for example using- -Ctrl+Z- -nowand that take us back to here; I'll press again, takes us back to this look. What if I change my mind?
I'll press Ctrl+Y, sort of reverse stream. So, you might try that for example, if you're working with certain charts, youcan toggle back and forth with the Ctrl+ Z and Ctrl+Y. The main capability thoughhere is this idea that when you make a serious mistake- -when you perhaps deletedata you didn't want or made a change- -that you can undo it. Now, the feature is not universal, particularly when it comes to changes thatyou make to Sheet Tabs. If you've never used these, you might not have seen that if you right- clickone of the Sheet Tabs, you'll see quite a few choices here, nearly all ofthese you cannot undo. So, don't ever assume that if you delete a sheet, you'll be able to get it back.
So, you want to be careful with undo. It is a great feature, no question about that, but don't assume that everysingle thing you do can be undone; but it's a real lifesaver at times. Keep in mind too, sometimes when you're experimenting with data, it might makesense to go through the cycle of undoing- -Ctrl+Z and then redo with Ctrl+Y tocompare two different appearances on your screen.