If you cannot insert, add or create new cells in worksheets in Microsoft Excel, remove cell protection and unmerge the Rows to begin with.

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

How Do I Reference a Cell in Another Worksheet in Excel?. Learning to use Excel worksheets like relational databases can help you save time, eliminating duplication when managing large projects.

Columns organize data in Excel, and are often used as categories with headers to sort cells. You can simply right-click on an existing column to add another column immediately before it.

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

In such cases, you can add space by indenting the data in one of the columns. You can also increase the space between columns in your Excel chart using the Data Series formatting tool.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.