The worksheet contains rows of products ordered from various suppliers.
You need to add a column for categories, to identify the various products as dairy, grains, produce, and so on. You want that column to go between two columns of data already in the worksheet.
You want to add the column to the right of the Quantity column, so you click in the Supplier column. Then, on the Home tab, in the Cells group, click the arrow on Insert. On the menu that appears, click Insert Sheet Columns. A new blank column is inserted, and you enter the new data in the column.
Click Play to watch the process of inserting a column in a worksheet.
Now that you've added a column and added data, if you need to adjust the column width to fit the data, in the Cells group, click the arrow on Format, and then in the list that appears click AutoFit Column Width.
In the Format list are all the commands to adjust row height and column width, as well as to hide and unhide rows, columns, and sheets.