excel vba courses - intro excel

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 vba courses - Intro to Excel

excel vba courses - Intro to Excel

resolvedResolved · Low Priority · Version Standard

Adenike has attended:
Excel Introduction course
Excel Intermediate course

Intro to Excel

What is editing?
How do I edit in a cell
Whrn do I edit and why should i edit
Please give a brief lesson on editing
When working on the worksheet and i don"t edit at all what happens.

RE: Intro to Excel

Dear Adenike:

Editing is something user does if they want to make any changes or amendments to the existing data without deleting it.

If the cell only has text then you can easily edit it by double clicking on it and when the cursor blinks inside the cell simply start making your necessary changes!!
TIP: you can also use the F2 keyboard short cut to have the cursor blinking inside the cell

If you are trying to edit a cell containing a formula or function then when you double click on the cell you automatically see the different colours of cell range/reference which you can confirm if they are correct. If not then you can delete teh existing range and chnage it to the correct one!!


Hope this helps!!If there is anything specific please post your relevant query!!

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Viewing two Excel 2010 Workbooks at the same time

Did you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth!

1) Open both Excel workbooks
2) Select Window then select Compare Side by Side with (Spreadsheet 2)
3) When you have finished, select Window again and click Close Side by Side

View all Excel hints and tips


Server loaded in 0.09 secs.