Use this tip to freely convert any of your Word or Excel files to a PDF document.
Protect Individual Cells from Being Edited in Excel 2007
Ever wonder how to make individual cells locked so you don't mistakenly edit formulas in Excel? Read this tip to find out the easy way how!
Alphabetizing in Open Office
George from Trinidad asks: "Is there a way to put a list of items in alphabetical order in Open Office?", and gets and answer!
MS Office: Calculating Time Difference in Excel
It is possible to calculate time totals in Excel. Here's a quick tutorial to show you how!
How to Password Protect Worksheets in Excel
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... Whew! We're safe - … Continue reading How to Password Protect Worksheets in Excel
MS Excel: Customizing Worksheet Defaults
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 … Continue reading MS Excel: Customizing Worksheet Defaults
Finding Tabs in Spreadsheets
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 Richard. I found a couple answers, but … Continue reading Finding Tabs in Spreadsheets
Using a Spreadsheet within a Word Document
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. Some … Continue reading Using a Spreadsheet within a Word Document
Paste with the Enter Key in Excel
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
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