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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
ms excel training - forms

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

ms excel training - Forms

ResolvedVersion Standard

Dan has attended:
Excel Advanced course
Access Intermediate course

Forms

How does one protect formulae from cut and paste action between sheets

RE: Forms

Hi Dan

You can protect cells from being cut and paste by using the Protection feature.

Go to Tools - Protection - Protect Sheet.

You can choose to enter a password to remove protection from the sheet (advisable) then click OK.

Amanda

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

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.