If you have worked on Excel files extracted from a database or a system, you probably have encountered cells with leading apostrophes. If you’re like me, you too might have wondered why in the world they’re there. It turns out that the apostrophe (or single quote) (‘) that you see at the beginning of a … Read more
Dollar signs ($) in Excel are great for quickly identifying cells that contain monetary values. There are times, however, that it would be better to remove them. In this article, I’ll show you four different ways to do this. Each approach has its pros and cons, so choose whichever fits your needs. The first two … Read more
Splitting a worksheet into panes or sections is great for keeping certain contents within the sheet (like the headers) to be always on display even when we scroll to other areas in the sheet. Excel allows us to split the worksheet into two or four panes. Once a worksheet is split, you can scroll through … Read more
When we print a document in Word, we don’t usually pay much attention to the page setup. The printed output would nearly always match how we see it on the computer screen. With Excel, however, it’s different. We need to be able to configure the right page settings to be able to print the worksheet … Read more
Decimals, fractions, and percentages are all ways to describe parts of a whole. Percentages, however, are preferred by many over other formats. I guess it’s because whole numbers (with a percent sign at the end) are easier to interpret over decimals and fractions. In this article, I’ll show you ways to convert decimals to percentage … Read more