You are now free to begin adding data.A new column.Marissa Perino/Business InsiderĦ. You will now have an empty column of cells directly before the one you clicked on. Click "Insert" from the menu.Right-click to insert a column.Marissa Perino/Business Insiderĥ. (Excel will insert the new column directly in front of it.) Select an entire column by clicking on its letter name at the top.Ĥ.
Select the column to the right of where you want a new column. Open Microsoft Excel on your PC or Mac computer.Ģ.
How to use microsoft excel formulas likeengineers do how to#
Check out the products mentioned in this article: Microsoft Office (From $139.99 at Best Buy) MacBook Pro (From $1,299.99 at Best Buy) Lenovo IdeaPad 130 (From $299.99 at Best Buy) How to add a column in Excel by right-clickingġ. To add multiple columns, highlight the desired number of columns before clicking "Insert." You can also insert cells from the "Home" tab in your spreadsheet. You can simply right-click on an existing column to add another column immediately before it. Visit Business Insider's homepage for more stories.Ĭolumns organize data in Excel, and are often used as categories with headers to sort cells.These features are helpful for quickly inserting a space for new data as you work within a spreadsheet.You can add a column in Excel by right-clicking or using the "Insert" option in the "Home" tab.You can add a column in an Excel spreadsheet in a few steps.Porrakij/Shutterstock