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

excel

ResolvedVersion Standard

Rishpal has attended:
No courses

Excel

How to add cells across a range of tabs in a worksheet

Thanks

Rishpal

RE: Excel

If you select your first worksheet tab, then hold CTRL and click the second tab, like selecting multiple cells, you will be able to edit both sheets at the same time.

So if you insert a Row in the one sheet, it will alos happen in the second sheet you have selected.

Remember to unselect the sheets once you have completed the work you need to do, otherwise you might just corrupt your data.

 

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:

Missing Field handle

If your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked.

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.