Copied From Above
Here’s a super quick copy trick for MS Excel!
Have you ever needed an exact copy of a cell’s contents?
And I do mean exact. Even cell references won’t be changed in your formulas.
Well, here’s the trick: simply select the cell directly below the item to be copied and use the Ctrl + ‘ (Ctrl + apostrophe) key combination.
Yep, that’s all there is to it!… Continue reading
Breaking Up Isn’t So Hard to Do
If you tried the tip from the other day, where you imported data from the Web into Excel 2007, you may have found that not all data appearing to be a table is actually a table. Am I right?
I found that many things I imported were actually just text, so it came into Excel in a single column.
So, now what?
Hassle Free Web Data in Excel 2007
So, you have data on a Web page and you need to move it into an MS Excel worksheet.
What are you planning to do?
Copy/paste each piece of data? Re-enter the data?
Well, I vote you import the data directly from the Web and avoid all the transfer time.
If you’re on board with that idea, let’s take a look!
The Long Formula
Do you work in MS Excel a lot?
Ever have a really long formula that would expand the formula bar in the older versions of Excel? Did it become bothersome when it began to cover the cells in the first few rows?
Well, if that’s the case for you and you now use Excel 2007, you may be happy to know that you have some other options… Continue reading
Special Data Formatting: The Easy Way
Do you enter a lot of special data into MS Excel, such as zip codes, phone numbers or social security numbers?
Ever find yourself wishing the parenthesis and/or dashes would just fill themselves into the correct locations? I mean, wouldn’t it be faster if you could just key 5551234567 in for a phone number and have (555) 123-4567 appear in the cell after you… Continue reading
Page Layout View for Excel?
Yep, you read that right! If you’re using Excel 2007, you’ll find that it also has a page layout view.
Just like the view you’ve used in MS Word for years, you can now choose to view your worksheet in pages, complete with headers, page breaks, rulers and all.
Take a look:
As you can see
Get the Info Quick
Do you use the Research feature found under the Review tab on the ribbon in MS Word 2007? You know, the handy function that provides a definition, translation and thesaurus information all in one concise location.
Yes?
How do you access it?
Do you go to the Review tab, click on the Research button and then enter a word or phrase into the Research pane?… Continue reading
The Case of the Missing Labels
Have you used MS Excel 2007 to make a chart lately?
Did you feel like you missed a step or something?
I mean, you highlighted your data, used the Insert tab on the ribbon to select a chart type and poof! A chart appeared in your worksheet.
Sounds nice and fast, but wait just a minute. What about all the details the older versions… Continue reading
Painting by the Rows?
Or, if you please, by the columns!
I don’t know about you, but I just love the MS Office Format Painter button.
That amazing little feature can quickly transfer formatting aspects to other locations in your file, without changing the actual text or data. Marvelous!
Much to my amazement, despite the frequency of which I use the
Page Setup in Excel 2007
Are you using Excel 2007?
Having trouble locating the Page Setup options you frequently use?
I’m sure by now you’ve found many things under the Page Layout tab on the ribbon.
You’ve probably noticed that a lot of the options are there as separate buttons, allowing you to quickly set one aspect, without the need for the old Page Setup dialogue window.
That can be… Continue reading
Excel Sorting: The Basics
In MS Excel, you often have a database of information that needs to be ordered in a certain way (whether it’s alphabetical, by date or whatever).
The first step to sorting data is to tell Excel what database it’s going to be sorting. To accomplish that, select a cell in the database.
If you’re sorting only one field, you can use the Sort Ascending and Sort
One More Filter Discussion: For Excel 2007
As you can see, I’m not quite done with the AutoFilter discussion for MS Excel 2007! For those of you who have been working with it, you have probably noticed that your filter down arrow gave you several more choices than the older versions ever showed.
So, as a result, I thought you might be up for a quick exploration of those extra… Continue reading
Print Some or Print All
Today’s tip comes from a reader who wanted to know how to print an entire MS Excel workbook all at once.
That’s a good question. After all, it’s a royal pain to print each worksheet individually.
So, how exactly can you print an entire workbook at one time?
The answer takes you back to the Print dialogue window (Ctrl + P).
Once again, you’re looking… Continue reading
I Need a Little Help Here!
I don’t know about you, but I sometimes find myself guessing what arguments are needed in an MS Excel function.
If it’s something I haven’t used in awhile, I may not be able to come up with the exact components that actually go into the parenthesis.
At that point, I stop everything and go in search of the Function Wizard. With that, I’m able… Continue reading
Do you set print areas in MS Excel to quickly print the cells that are only needed time and time again?
Ever have times when you want to print a different range of cells, without resetting the print area?
Yes? Then you need to give this a try!
First, highlight the cells you want to print.… Continue reading
Find It Where?
Did you know that when you do a Find/Replace in MS Excel, you can control how much of the file is searched?
Yep, that’s right! You can choose to work on a single worksheet or the entire workbook. It’s all up to you. You just have to know where to look for the setting.
To begin, you need to run the Find/Replace function as usual (Edit menu… Continue reading
Paste an Exact Match
Do you often use the same formula in multiple places in your MS Excel worksheets? I’m talking about the exact same formula. You know, no cell reference changes on the paste.
If so, have you ever tried to copy that formula from one cell to another?
Yeah, I know, all the cell references change in the pasted version relative to its new location. Not what you… Continue reading
See Titles and Totals Simultaneously
If you frequently work with large amounts of data in MS Excel you may find yourself frustrated as you try to see both the column titles (at the top) and the column totals (at the bottom) at the same time.
You have probably tried to freeze the titles and then split the screen, thinking you could keep the totals in view in the bottom half… Continue reading
Keep Your Formatting
Did you try yesterday’s Paste Special trick in MS Excel? If so, did you find that the formatting of the cells, where the paste occurred, was gone?
If you did, I’m sure you’d like a way to prevent that transformation while the Paste Special does its thing, right?
Assuming that’s the case, I’m here to show you a small change you can easily accomplish while making your… Continue reading
Multiply Many At Once
When you’re working in MS Excel, do you ever have the need to multiply, add, subtract or divide several cells by the same value?
If so, please tell me you didn’t go through and make all of those changes individually!
Well, I hope not, because that can be very time consuming and Excel offers a much more efficient method that is available right within the Paste… Continue reading
Same Information, Many Cells
Have you ever had the same information to enter in multiple cells in MS Excel?
What did you do?
Did you type the data into one cell and then copy and paste it everywhere else in the worksheet?
That was a bit of a pain, wasn’t it?
How would you like a way to get the data into all of those cells simultaneously? You know, a… Continue reading
Just the Comment and Nothing But the Comment
Have a lot of comments in your MS Excel files?
Ever find yourself entering duplicate comments as you work your way through a file?
Tired of all the repetitive typing?
If so, how would you like a way to copy and paste just the comment?
No problem!
The next time you need a comment from a cell, and nothing else, just follow… Continue reading
Tell Excel to Leave You Alone!
Yesterday’s topic of formulas linked one workbook to another and as you may recall, in the end, MS Excel kept asking if you wanted to update the information. That’s not necessarily a bad thing, but if you control both workbooks and you know there’s no security problem, it can get somewhat annoying.
So, you must be asking, “Can I get Excel to stop asking… Continue reading
When a Name Box Isn’t a Name Box
Did you know that MS Excel’s Name box isn’t always the Name box (the box to the left of the Formula bar?)
I know it sounds crazy, but it’s true!
Pay attention when you type in an equal sign (=) to start a formula.
Did you see what happened?
Sum It Up With Two Keys
I’m sure many of you are familiar with the AutoSum button in MS Excel, right?
It’s a handy little feature that, with a single click, inserts the formula for the sum of a column of data located just above whatever cell you currently have selected.
Now, those of you who prefer to use the keyboard for everything may be wondering if there’s an… Continue reading
Insert Many Where There Are None
Do you do a lot of copy/paste or cut/paste moves in MS Excel? If so, are you tired of shifting cells around to make space for the stuff you need inserted into the middle of your current data set?
How would you like a way to get Excel to do the data shift for you? That’s right! Excel can shift data at the same… Continue reading
Check Them All
Did you know that when you run the Spell Check in MS Excel, it only checks the current worksheet and not the entire workbook?
Want to check the whole thing at once?
If so, simply select all the worksheets before you run the Spell Check.
Looking for a quick way to select all the worksheets in the workbook? Good idea! To do that, simply right click on
