How to Delete All Hidden Rows and Columns in Excel

Many Excel users always hide columns and rows that have data they do not need visible. They keep only the columns and rows with useful data visible. In cases where you have lots of these hidden rows and columns, it can be painful and tiresome finding them. The post below will guide you on the … Read more

Trick to Lock Row Height and Column Width in Excel

Consistent formatting when using spreadsheet programs helps organize work and helps to come up with a good, if not excellent, job. Locking up the width of a column or height of a row in a spreadsheet reduces or limits changes to the format. It also allows one to work on a project with other users … Read more

How to convert a column number into an excel column letter

How to convert a column number into an excel column letter

Microsoft Excel has patterns such as A, B, C, AA, BB, CC, AD, AA, AAB, and AAZ. Column 1 is named as A, B as 2, and 27 as AA. Therefore, finding a column letter is easy and possible, given its corresponding column number is easy. To convert a column number to the letter in … Read more

How to combine First and Second Name in Excel

How to combine First and Second Name in Excel

Excel is a cell-based working platform, and therefore it is more convenient to place the first and the second name on each column. However, while working on this data, you may need to merge the first and the second name in one column. This may be possible using the following methods: Method 1: Using the … Read more

How to merge columns without losing data

How to merge columns without losing data

One of the problems that occur when merging is loosing of data. Regardless of the excel version in use, when you merge columns of data in excel, only the left column data is kept and the data in the other columns will be deleted. The guide below is going to help you know how you … Read more