How to Protect the Formula, but Edit the Quantity in Excel : Using Microsoft Excel

Channel:
eHowTech
Subscribers:
513,000
Published on ● Video Link: https://www.youtube.com/watch?v=LbQAfNjvN3A


Category:
Guide
Duration: 4:03
36,778 views
161

Subscribe Now:
http://www.youtube.com/subscription_center?add_user=ehowtech

Watch More:
http://www.youtube.com/ehowtech

When editing the quantity of a cell in Excel, one thing you have to do is protect the formula so the rest of the spreadsheet doesn't get messed up. Protect the formula but edit the quantity in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.

Expert: Edward Russell
Filmmaker: Patrick Russell

Series Description: Microsoft Excel is a lot more than just a basic spreadsheet program - it can be a legitimately terrific way to keep track of nearly every type of information. Use formulas and columns in Microsoft Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video series.



Other Videos By eHowTech


2013-05-17How to Delete Cookies in Google Chrome? : Internet Basics
2013-05-16The CPU Usage for an iTunes Sync : Help With iTunes
2013-05-16How to Make a Grade Sheet in Microsoft Excel : Microsoft Word & Excel
2013-05-16How to Authorize Your Computer for iTunes : iTunes Help
2013-05-16How to Increase Your Max Camera Distance in "WoW" : World of Warcraft Tutorials
2013-05-16How to Edit Weights in "Madden 10" : Madden NFL 10
2013-05-16How to Restore Deleted Items in Microsoft Word : Microsoft Office Software
2013-05-16How to Remove Instant Replay From "Madden 11" : Madden NFL 2010 & 2011
2013-05-16How Do I Wipe My iPhone? : iPhone Tips
2013-05-16How to Create a Background Track on GarageBand : GarageBand Tips
2013-05-16How to Protect the Formula, but Edit the Quantity in Excel : Using Microsoft Excel
2013-05-16How to Convert Diacritics in Java : Java & Other Tech Tips
2013-05-16How Do I Hide, Block, & Share Files On Facebook? : Facebook Tips
2013-05-16How to Delete All Gmail at Once : Internet Basics
2013-05-16How to Upload Church Messages to iTunes : Help With iTunes
2013-05-16How to Add the Temperature Symbol in Microsoft Word : Microsoft Word & Excel
2013-05-16How to Upgrade the iPhone Using iTunes : iTunes Help
2013-05-15How to Kick an Onside Kick in "Madden 10" : Madden NFL 10
2013-05-15How to Get to Stormwind Faster at a Low Level in "WoW" : World of Warcraft Tutorials
2013-05-15How to Create a Microsoft Word Assistant : Microsoft Office Software
2013-05-15How to Clear Salary Penalties on "Madden 2011" : Madden NFL 2010 & 2011


Tags:
shift everything down
creating formulas
editing formulas
birthday formula
formulas
columns
Microsoft Excels