Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic training excel - Excel

basic training excel - Excel

ResolvedVersion Standard

Mon 21 May 2007, 09:50 Delegate Pamela said...

Pamela has attended:
Excel Introduction course

Excel

Unable to add a column ? Why ?

Mon 21 May 2007, 13:34 Trainer Tracy said...

RE: Excel

Hi Pamela,

To add a column simply highlight the column letter, which highlights the entire column, go to the Insert menu and down to column.

That should work, let me know!

Tracy

Fri 1 Jun 2007, 14:00 Delegate Pamela said...

RE: Excel

Hi Tracy
For some reason I cannot add extra columns on one particular spreadsheet. The others are ok, its just on one particular one. Can you help?

Tue 19 Jun 2007, 12:37 Trainer Richard said...

RE: Excel

there may be a corruption in that worksheet. Is the worksheet protected in any way?

If this sheet does not link to any other sheets, you could copy and paste all the data into a new sheet, and then resave.

Richard

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

View all Excel hints and tips

basic training excel - Excel

Excel

RE: Excel

RE: Excel

RE: Excel

Excel articles

Excel tip:

Editing Formulas in Excel Cells