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

excel

ResolvedVersion 2003

Alison has attended:
Excel Intermediate course

Excel

How do you also work on a document when it is locked for someone else editing it?

RE: Excel

Hi Alison

Thank you for your question and welcome to the forum.

You can make the workbook sharable (Tools - Share workbook) and therefore more than one person will be able to edit the workbook at once.

Amanda

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.11 secs.