ms excel

The default behavior of the Enter key in MS Excel drives some folks crazy. When you click on Enter, some people would prefer that the cursor move to the next cell on the right, while others prefer the cursor move downward. Fortunately, MS Excel can ... accommodate these preferences and more. To change the way MS Excel reacts after you click Enter, follow the steps below: Click on Tools | Options. Click on the Edit tab. Click the Move Selection After Enter check box to activate the direction drop-down list. In the drop-down list, select from the following options: Down Right Up Left If you prefer ... (view more)

MS Excel formats date and time values in a way that is meaningful to us, such as 12/01/08; December 1, 2008, 2:15 p.m., 12/01/08, 14:15, etc. With just a quick glance, we know precisely what the date and time string represents, but internally MS ... Excel uses a serial value, not the formatted value that we see. When working with time and date values, it can be very beneficial to know the serial value and Excel makes it easy for us to have a quick look and see. Follow the steps below to learn how: Enter some date and time values: Click CTRL + ; to enter the current date. Click CTRL + Shift + ; to ... (view more)

My son-in-law came to me recently with a problem he was experiencing in MS Excel. He is a director in his company and is charged with keeping track of his employees' time. He wanted to be able to display a negative time in his MS Excel spreadsheet. ... I have to tell you -- I had a time figuring out this one. After doing some research and digging around a bit, I found that the easiest solution to this problem is to simply change the date system used by the workbook. I agree that it sounds a bit strange, but it works. The default date system for Windows versions of MS Excel is 1900 and if you are ... (view more)

You don't always have to use a formula in MS Excel. That's right, sometimes you can just utilize the Status Bar for your calculations. The far end of the Status Bar in MS Excel will show you calculations, displaying the results for average, count, ... number of numbers, maximum/minimum value, and the sum of any given range of numbers. Follow along below: Open a new page in MS Excel. In Column A, key in numbers, one below another. Highlight the numbers. If you look at the right-hand of the Status Bar at the bottom of your screen, you will see the result. Now here is the really cool part: Right- ... (view more)

It can be daunting and more than a bit frustrating when the CEO of your company dumps a ton of data on your desk and expects you to hastily turn it into an MS Excel database. But it doesn't have to be daunting any longer -- it can even be easy using ... the Data Entry Form in MS Excel. This handy feature will allow you to enter an entire row of date all at one time, rather than entering each little bit of data one at a time. Sounds a lot better already doesn't it? So we have now established that data entry forms in MS Excel definitely bear investigating eh? Follow the steps below to learn how. To ... (view more)

I have had situations when I was using an MS Excel spreadsheet and had a column of data and then wanted to increase the value of a range of cells by, perhaps, 10%. No doubt, you have also experienced this when using MS Excel. If so, I am sure that ... this meant keying in the new values, or using a hidden column and formulas, or by making all of the cells formula-based when you created the worksheet. Well now I am going to tell you how to do it the easy way -- the way in which you save time and keystrokes! That's what I'm talking about! Follow the steps below to learn how: Open your spreadsheet ... (view more)

You have created the perfect table in MS Word and now you have to put it into MS Excel. You have tried copying and pasting but all of the pretty formatting is gone and it doesn't fit right and it really looks a mess! What do you do now? Well, this ... quick and easy resolution will make you look like a star. Simply paste your text into MS Excel as a picture! Hmmm...how do do that... Copy your text or table in MS Word. In MS Excel, click on Edit | Paste Special. In Excel 2007, the latest version, go to the Home ribbon and click the down arrow on the Paste button and select Paste Special from the ... (view more)

Not everyone who uses MS Excel is a 'Power User'. Everyone has to start someplace, though, and sometimes all those icons on the toolbar are a bit overwhelming. Sometimes you will find that you have been using MS Excel for months and it has never ... occurred to you to see what those icons do so I am going to tell you about a couple today that can prove to be very, very useful to you. Follow along with the steps below: Launch MS Excel if it is not already open. Look at your Formatting toolbar. In MS Excel 2007, look on the Home ribbon. Find the button with the zeros and arrows. The button on the ... (view more)

Your boss has just dropped a memo on your desk with a note attached asking you to analyze information contained in a company database and create a report for him to use at the annual meeting later in the week. Only problem is, the report is an ... Access database and you don't have MS Access installed on your computer! Now what?? You don't want to tell your boss that he will have to ask someone else to take care of this, right? I have the answer for you! You don't have to own MS Access; MS Excel can step in and take care of this problem for you. That's right, you can use MS Excel to open the ... (view more)