openoffice excel how to add another column

What are your Excel skills? Are you a pro user or just learning the ropes? Let us know in the comments section below. Adding new rows, formatting cells, deleting, and hiding items is the foundation for becoming proficient in Excel.

If you selected a cell, to begin with, an Insert Dialogue Box will appear. Right click and select the Insert option from the drop down menu. It’s easy to lose track of all the rows and columns, so pinning down these basics will go a long way towards getting your spreadsheets formatted just right. Following are the steps to insert a column in Excel : Select the complete column C by clicking on the header C. Mastering the Excel BasicsĪn experienced Excel guru might not even think twice when adding a new column or a new row in Excel, but navigating through it can be more than a challenge for Excel novices. For example, if you select three columns at once and tap on “Insert Columns,” Excel will create three new columns.

Note: When using Excel mobile app on any device, you can also add multiple columns simultaneously. Select the “Insert & Delete” option followed by “Insert Columns.”.Tap on the small upward arrow at the bottom right corner of the screen.The other method is to tap select the column and then: Then, tap on the “Insert” option from the menu bar that has appeared.Tap on the letter of a single column and select it.

Openoffice excel how to add another column