How to Return the Column Letter (Not Number) With Excel Function

There are a few cases in Excel when you need to return the column letter from an Excel cell. For example, when you use the INDIRECT function. Retrieving the number of a cell is quite simple using the =COLUMN() function. But the letter? Here is how to do that! Summary In a hurry? Copy and… Continue reading How to Return the Column Letter (Not Number) With Excel Function

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?

Convert Table to One Column in Excel: 4 Easy Methods to Copy All Columns underneath Each Other

Convert Table to Column in Excel

Say, you have an Excel table and want to copy all column underneath each other so that you only have one column. For example, you have a table 2 rows by 4 columns like in the screenshot on the right-hand side. You want to copy and paste this table to one column. You often need… Continue reading Convert Table to One Column in Excel: 4 Easy Methods to Copy All Columns underneath Each Other

Adjust Rows and Columns in Excel: The 4 Easy Ways!

Do you spend a lot of time changing the column width in Excel? On the one hand, you’d like to see as many columns as possible for having a good overview, but on the other hand, you want to see as much content as possible within a column. In the worst case, you’d only see ### instead of values.

How To Hide And Group Rows And Columns In Excel

You got an Excel table with some unimportant rows, but you don’t want to delete them. In such case, you might want to “hide” them. There are two options of hiding rows (and columns): Either right-click on the row (or column) number and click on “Hide” or use the group function.

Before you leave: Boost your Excel skills!Join thousands of Excel users & subscribe to the newsletter!
  • The best Excel tips, tricks and tutorials.
  • 1x per month.
  • No spam. Promised.
Welcome gift: Save a lot of time with my huge keyboard shortcut package.

Learn more