excel training courses - insert column

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Insert Column

excel training courses - Insert Column

resolvedResolved · Low Priority · Version Standard

Jayne has attended:
Excel Introduction course

Insert Column

How do I insert a new column?

RE: Insert Column

Hi Jayne

Simply right click on the column where you want to enter the new one, and then choose INSERT.

Regards

Richard

Edited on Wed 22 Aug 2007, 23:31

RE: Insert Column

Please note that the new column/s get inserted on the left hand side of the selected column/s

So If you don't like using mouse you can select the column and use the keyboard short cut "CTRL"+"SHIFT"+"+"
OR simply right-click on right hand column

A Quick Tip: If you want more that one column to be inserted at once then you can select a number of columns e.g. four and use any of the above methods to insert new columns and you will observe that four new columns will be inserted on the right hand side of the selected columns


 

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips


Server loaded in 0.08 secs.