Insert or delete rows and columns - Microsoft Support
To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same number of columns to the right of where you want to add new ones.
Change the column width or row height in Excel
You can manually adjust the column width or row height or automatically resize columns and rows to fit the data.
Use calculated columns in an Excel table - Microsoft Support
Calculated columns in Excel tables are a fantastic tool for entering formulas efficiently. They allow you to enter a single formula in one cell, and then that formula will automatically expand to the rest of the column by itself. There’s no need to use the Fill or Copy commands.
Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Change the column width and row height - Microsoft Support
How to change the column width and row height, including how to use the AutoFit feature, in your Excel worksheet.
Adjust the column size to see everything - Microsoft Support
You can adjust column widths in Excel so that every cell is wide enough to display its information, and so that you don't see the ##### sheet error.
Split data into multiple columns - Microsoft Support
Sometimes, data is consolidated into one column, such as first name and last name. But you might want separate columns for each. So, you can split the Sales Rep first name and last name into two columns. Select the "Sales Rep" column, and …
Transpose (rotate) data from rows to columns or vice versa
How to use Transpose in Excel to rotate columns and rows to rearrange your worksheet data.
Lock or unlock specific areas of a protected worksheet
How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit.
Create a column from an example - Microsoft Support
Select Add Column > Column From Example > From Selection, and then type "January". If you prefer the suggestion, press Enter and then select OK . Power Query automatically renames the column to "month name".