Column Headings: Column numbers instead of letters?

When you usually open Microsoft Excel and create a new workbook, you would see your well-known worksheet style: Row numbers on the left and column letters on the top of the cells. But sometimes, you would see something different: Column number instead of letters. What has happend? And how can you change it back?

Sheet Tabs in Excel Missing? How to Get Them Back!

Does your Excel file look something like this? The sheet names at the bottom of the Excel screen are missing? But no problem, you can easily get them back. Admittedly, the option is a little bit hidden. So, let’s see how to restore the sheet tabs!

Can’t select rows / columns to repeat when printing? Easy fix!

As you have come to this site, probably you have just experienced this: Your worksheet spreads over more than one printed page and you want to set rows and columns to repeat. That way, the header row or column will be printed on each page. Large tables are much easier to read. But now you see… Continue reading Can’t select rows / columns to repeat when printing? Easy fix!

Can’t Scroll in Excel? Here Are Reasons and Easy Fixes!

You cannot scroll any longer in your Excel worksheet? Mainly scrolling up- and down, but also sideward does not work? There are actually a number of possible reasons for that. Let’s explore them below and make you scroll again! Reason 1: Frozen panes might prevent you to scroll Are there frozen panes? E.g. the first… Continue reading Can’t Scroll in Excel? Here Are Reasons and Easy Fixes!

Published
Categorized as General Tagged

Headings Missing in Excel: How to Show Row Numbers & Column Letters!

Let us assume the following situation: You have received an Excel file which looks actually quite nice. But you notice something: The rows and column headings missing. That means, the numbers 1, 2, 3 on the left-hand side are gone and the letters A, B, C are also not shown. Here is how to get… Continue reading Headings Missing in Excel: How to Show Row Numbers & Column Letters!