How to Remove Leading Apostrophes in Excel (2025)

Example of a column with leading apostrophes in excel

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

How to Remove Panes in Excel [2025]

Double-click on the dividing bar to remove panes

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

How to Center a Worksheet Horizontally in Excel?

Steps to open Page Setup from the File menu to Center Worksheet Horizontally

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

How to Convert Decimal to Percentage in Excel?

Select the cells containing the decimals you want to convert into percentage format.

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