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. Now you're wondering why … Continue reading Paste with the Enter Key in Excel
Google Cloud Connect Add-in for Microsoft Office
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 … Continue reading Google Cloud Connect Add-in for Microsoft Office
MS Excel: Format Cells Dialog Box
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" formatting source. From within that one dialog box, we could … Continue reading MS Excel: Format Cells Dialog Box
Pictures and Shapes in MS Office
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 the … Continue reading Pictures and Shapes in MS Office
Preventing File Overwrite in MS Office
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 … Continue reading Preventing File Overwrite in MS Office
MS Excel: Creating Visual Breaks Without Using Cell Borders
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 … Continue reading MS Excel: Creating Visual Breaks Without Using Cell Borders
Copy and Paste Only a Cell Comment in MS Excel
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 the … Continue reading Copy and Paste Only a Cell Comment in MS Excel
Copy Your MS Office Quick Access Toolbar to a Different Computer
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 … Continue reading Copy Your MS Office Quick Access Toolbar to a Different Computer
MS Office 2010: More Help If You’re Migrating From Office 2003
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 … Continue reading MS Office 2010: More Help If You’re Migrating From Office 2003
Creating Macros in MS Excel
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 … Continue reading Creating Macros in MS Excel