14. Protection, Sharing and Printing
14.11 Version History
Steps in Excel
- The file must be on OneDrive/SharePoint (AutoSave On).
- File › Info › Version History (or click the file name at the top › Version History).
- The pane lists saved versions with time and author. Click a version – it opens read-only in a separate window.
- Restore to make it the current version, or copy the needed cells into the current file.
- For local files without OneDrive: File › Info › Manage Workbook › Recover Unsaved Workbooks (depends on AutoRecover settings – may vary by version).
- Review › Changes › Show Changes (Microsoft 365) shows who changed which cell recently.
Worked example. At 4:15 PM IST someone deleted the Nashik rows in Daily_Targets.xlsx. Open Version History, open the 3:30 PM IST version, copy the Nashik rows back (or Restore that version if nothing else changed). Show Changes tells you who deleted them.
Ravindra Bagale's Tip
When they make a mistake, many students panic and press Ctrl + Z many times, or rebuild the file. If the file is on OneDrive, you can find an old version in Version History – don't panic. But before you Restore, remember that other people's changes made after that will also be lost; if needed, copy only the cells you need.
Ravindra Bagale's Tip – मराठी
चूक झाल्यावर बरेच students घाबरतात आणि Ctrl + Z खूप वेळा दाबतात, किंवा file पुन्हा बनवतात. File OneDrive वर असेल तर Version History मध्ये जुनं version सापडतं – घाबरू नका. पण Restore करण्यापूर्वी लक्षात ठेवा की त्यानंतरचे इतरांचे बदल पण जातील; गरज असेल तर फक्त लागणाऱ्या cells copy करा.
Ravindra Bagale's Tip – हिंदी
गलती होने पर बहुत से students घबराकर Ctrl + Z कई बार दबाते हैं, या file दोबारा बनाते हैं. File OneDrive पर हो तो Version History में पुराना version मिल जाता है – घबराओ मत. लेकिन Restore करने से पहले याद रखो कि उसके बाद के दूसरों के बदलाव भी चले जाएँगे; ज़रूरत हो तो सिर्फ़ ज़रूरी cells copy कर लो.
Thodkyaat sangaycha tar (quick recap)
- Aadhi input cells Unlock, mag Protect Sheet. Protect Workbook = sheets chi structure.
- Sheet/structure password = chukanpasun sanrakshan; khari security = Encrypt with Password (aani password visru naka!).
- Print Area, Page Break Preview, Width 1 page, headers/footers aani Print Titles
$1:$1. - PDF: aadhi page setup, mag Export › Options.
- OneDrive/SharePoint = co-authoring, @mention comments aani Version History.
Aata pudhe jaauya – sagla shiklela ekatra vaparun Final Project!
Worked example — version history
Why
Aarti Kulkarni in Pune and Anna Kowalski abroad both need a clear, repeatable way to use version history on a HomeNest Supplies sheet without breaking totals.
What
Version History is the Excel idea this page teaches. We will walk one tiny example end to end.
How
- Open a blank sheet. In A1 type a short label for version history.
- Enter a small made-up value for Aarti Kulkarni using £ where money appears.
- Add a second value for Anna Kowalski using € so you see mixed currencies stay numeric.
- Apply the method from this lesson step by step (menu or formula as shown above).
- Check the result still works inside SUM or a simple check cell.
Formula / action
Follow the formula or ribbon steps shown in this lesson (keep values numeric).Meaning: Once version history is correct on one row, copy the same pattern down the column.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of version history on a blank sheet for NovaCraft Tools.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Sana Sheikh and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for Liam Murphy.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply version history to a 5-row made-up NovaCraft Tools table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with version history.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as NovaCraftTo_practice.xlsx.
Hint: Use a clear file name for class.
Loading practice tasks...
- Input cells to unlock (Easy): How many cells are in the Monthly target column?
- Total target (Easy): Add up the Monthly target column.
- Total actual (Easy): Add up the Actual column.
- Highest target (Easy): What is the largest value in the Monthly target column?
- Overall achievement (Medium): Divide the total Actual by the total Monthly target. Round to 3 decimals.
- Cities below target (Medium): How many cities have a Gap below 0?
- Manager for a city (Medium): Find the Manager for City "Mumbai".
- Pages to print (Medium): If one page holds 4 data rows, how many pages do the rows need?
- Gap for the first city (Medium): For the first row, find Actual minus Monthly target.
- Best performer (Hard): Which City has the largest Actual?
- Status for the first city (Hard): For the first row, return "Hit" if Actual is at least Monthly target, else "Miss".
- Total shortfall (Hard): Add up the Gap column only where it is below 0, and show it as a positive number.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
