With the release of Excel 2010 we have another quick, easy-to-use and powerful tool to take a graphic look at the trend found in a set of data… Sparklines. Continue reading
By now we’ve all found the Format as Table button on the Home tab of the Ribbon will take a range of selected cells in turn them into an easily and beautifully formatted table, but did you know there’s an easier way? Continue reading
Ever found yourself staring at a column of data trying desperately to figure out how you’re going to peel out the portion of the data in each cell that you actually need? With the right formula anything is possible! Check it out! Continue reading
Be default, when we tell Excel to print we end up with whatever worksheet is currently selected spitting out of the printer.
Usually that’s great since it’s exactly what we want most of the time… but what about the other times?
You know, when you wanted the entire workbook or even multiple worksheets, but not all of them?
Learn how to remedy this problem by reading this tip! Continue reading
MS Excel: A Locked Cell is Not a Cell Protected From Changes
If you’ve ever found yourself nosing around the Protection tab in the Format Cells dialog box then you’ve probably found that the Locked check-box was selected and possibly thought that your worksheet was safe from changes made by others…
Some people have one central location where they open Office files from on a regular basis… but others have several locations, and it’s a bit of a pain to constantly navigate from one location to another.
The more files you open, the bigger that pain becomes until it’s an all out headache.
You’ve got to be
There are certain things that we’d all like to have when we begin a new Excel workbook… such as number of worksheets, font, font size, etc…
For many people, this seems like an elusive process, since there are so many places to investigate looking for the old Default button.
Fortunately for all of us, a few
Richard from San Antonio asks:
I create a large number of tabs in Excel 2007 spreadsheets, each with a distinct title. Is there a way to search for a specific tab within the spreadsheet? Some of the spreadsheets might have 100 or more tabs.
Thanks for the question
MS Word: Using a Spreadsheet Within a Document
On more than one occasion, I’ve found that within a document I’ve needed to present data that really should be set up in Excel.
Don’t get me wrong, Word’s tables are great, but when it comes to calculations and numeric data displays, Excel wins hands down.
If you’re anything like me, you believe that there’s only one option when using the keyboard to paste in MS Excel – Ctrl+V.
While that obviously will paste your copied or cut information as it always has, you do have another option if you’re only looking to paste in one location.
Do you work with a lot of Google Docs documents? Do you have spreadsheets, Word documents, PDF reports, PowerPoint presentations stored in your Google Docs account, and are looking for an easier way to create or manage these documents from Microsoft Office desktop UI?
There are tons of desktop apps available for managing Google Docs documents, but recently Google has released an official add-in which
MS Excel: Finding a Long Lost Friend… the Format Cells Dialog Box
Let’s be honest, there are times when faced with the Ribbon and all its tabs, groups and buttons, that we miss our old friend the Format Cells dialog box.
It was our “one-stop”
MS Office: A Picture of a Different Shape
Today I want to point out a very simple and quick way to change the way pictures and graphics are displayed in your documents, presentations, worksheets, etc…
We’re going to take a look at how the fill of a shape can really make a difference in
We’ve all done it at one time or another… you need to create a new file that’s pretty much identical to another one, so you open the file that you have, make the changes and then save it.
In that very, very short time while you watch the file being saved you are struck speechless with the horrible realization that you just made a
When setting up a worksheet where we need to separate one section of information from another, and present that separation clearly, we often use cell borders to accomplish the job.
Obviously that option is a great way to get the job done, but we tend to use those for everything… so making that visual break between data sections requires a bit of finesse with those borders.
MS Excel: Copy / Paste Only a Cell Comment
When reviewing the contents of a worksheet, do you find that you’ve got the same comment to make over and over again? (The least of which being “Where the heck did that come from?”)
I know that when I go through and start getting into
How much time have you spent customizing the Quick Access Toolbar in your MS Office 2007 programs?
If you’re anything like me then it’s quite a lot…
When you move to a new computer – or maybe decide that you want the one at home to match the one at work – what do you do?
If you’ve recently given up your Microsoft Office 2003 for the “latest, greatest” version, Office 2010, you may be a bit disoriented.
You’ve heard the hype about the new Ribbon User Interface but now you’re faced with actually having to use it…
If it’s not something you’re taking to easily or just feel like you need more guidance, I have a suggestion or two
Microsoft Excel is the one of the most popular spreadsheet programs used worldwide. It has a variety of features such as data storage, creating reports and charts, using mathematical functions, performing statistical analysis, ability to connect to databases, making use of pivot tables, V-lookups etc. One such very useful feature within Microsoft Excel is the ability to make use of “macros”.
What is a Macro?
The other day we talked about a method to copy and paste the OFFICEUI files (which contain all the custom User Interface information for one of the Office 2010 programs). It’s a good method, but it requires you to know where to look for the files.
It’s a great way to save your customizations, in case something happens to your system
MS Excel: Delete Multiple Comments at Once
If you’ve got an Excel worksheet that contains a lot of comments, it can be a bit of a pain to remove them all when you’re done.
Think about it. If the worksheet is a large one and you’ve managed to accumulate quite a few comments, it’s
Do you “undo” a lot in MS PowerPoint?
Ever run out of undo steps and wish for more?
If your response was yes, here’s what you need to know about PowerPoint to get a few (or a lot) more undo steps added to your list.
When you open a file in one of your MS Office programs, do you find that you’re always navigating away from “My Documents” to some other folder?
Ever wish that it would just open up to that location in the first place?
If so, here’s the good news… you can set each program to go directly to whatever location you desire, when you
When you’re in the Options dialog box for one of these newest MS Office programs, have you ever noticed this part of a section header? (You’ll notice that not all section headers have one…)
Even if you did notice it…did you take the time to investigate?
For many people the answers are no…