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.
MS Excel: Paste Once vs. Paste Multiple Times
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
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
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
MS Office: Stop Losing the Original File
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
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
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?
