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

excel training courses - insert column

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

excel training courses - Insert Column

ResolvedVersion 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:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.