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

basic training excel - excel

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

basic training excel - Excel

ResolvedVersion Standard

Pamela has attended:
Excel Introduction course

Excel

Unable to add a column ? Why ?

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

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?

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

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.