Here's a super-helpful MS Excel tip that will teach you the painless way to insert and paste rows and columns.
MS Excel: Customizing Error Checking
I'm sure you've noticed by now the Error button that pops up whenever Excel's Error Checking feature thinks that there may be something wrong with a cell's contents. Well, what if there are no errors?
MS Excel: Text to Numbers in Just 2 Clicks
Unfortunately it happens way too often - we receive a worksheet containing numbers but the cells were formatted as text. Too bad we need them as numbers! Thankfully, there's a quick and easy solution!
MS Excel: It’s All About the Right and Left of the Thing
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!
MS Excel: Print One Sheet, All Sheets or Maybe Just Some Sheets
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!
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 Office: Add Your Locations to the My Places Bar
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 … Continue reading MS Office: Add Your Locations to the My Places Bar
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