ms excel training - forms

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

ms excel training - Forms

resolvedResolved · Low Priority · Version 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:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.

=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips


Server loaded in 0.09 secs.