Saving and opening workbooks

Hello students, welcome to Kwickprep. You typed marks for fifty students, and the power went off. Is all that work gone? It depends on one small habit: saving. Today we will learn how to save a workbook, save a copy, and open it again later.

First, two words you must know. A workbook is the complete file you create in a spreadsheet program like Microsoft Excel. A worksheet is one page of rows and columns inside that workbook. You see each worksheet as a tab at the bottom, like Sheet 1 and Sheet 2. Saving copies the workbook from the computer's temporary memory to a disk or a cloud drive, so it stays safe after you close it.

Why is saving so important? While you type, your work sits in RAM, which is temporary memory that is wiped when the power goes. A saved file is stored on the disk, which keeps it even when the computer is off. So a good data entry operator saves early, and then saves again every few minutes.

Excel gives you two commands in the File menu. Save, or Ctrl+S, updates the same file with your latest changes. Save As, or the F12 key, lets you choose a new name, a new folder or a new file type. When a workbook has never been saved, even Ctrl+S opens the Save As window, because Excel needs a name first.

Let us follow the steps for saving a new workbook. Click the File tab, then Save As, or press F12. Choose the folder, such as Documents or a folder named Class Records. Type a clear file name, for example Attendance July. Check the Save as type box, which is usually Excel Workbook. Click Save, and the new name appears in the title bar at the top.

The file type is shown by the extension, the letters after the dot in a file name. Dot xlsx is the normal Excel workbook, used since Excel 2007. Dot xls is the older format, for Excel 97 to 2003. Dot xlsm is a workbook that can store macros, which are small recorded programs. Dot csv keeps only plain data, so formatting, formulas and extra sheets are lost. Dot ods is the OpenDocument format, used by the free program LibreOffice Calc.

A good file name tells you what is inside without opening it. For example, Fees underscore Class 11 underscore 2026 is short and clear. Windows does not allow some symbols in file names, such as the slash, colon, star, question mark, quotes, angle brackets and the pipe sign. When you keep copies, add a date or a version number, so you never overwrite the wrong one. Keep related files together in one folder, so they are easy to find.

Now pause and predict. You saved a new workbook named Book 1 as Stock dot xlsx. Later you change one price and press Ctrl+S. Will Excel ask for the name again? No, it will not, because the file already has a name, so Ctrl+S quietly updates Stock dot xlsx.

Excel also has two safety features. AutoSave is a switch at the top left in Microsoft 365. It saves every change as you type, when the file is on OneDrive or SharePoint, Microsoft's cloud drives. AutoRecover saves a hidden backup copy every few minutes, ten minutes by default. If Excel closes suddenly, open it again and look at the Document Recovery panel. But these are only safety nets, so still press Ctrl+S yourself.

To work on a saved file again, you open it. Press Ctrl+O, or click File and then Open. The Recent list shows the workbooks you used lately, so one click opens them. You can also find the file in File Explorer and double-click it. Browse, or Ctrl+F12, opens the classic window where you choose the exact folder and file.

Sometimes Excel shows a message bar when a file opens. Protected View appears when the file came from the internet or an email, and editing is switched off to keep your computer safe. Click Enable Editing only if you trust the sender. Compatibility Mode means you opened an old dot xls file, and some new features are turned off. Read-only means you can look but not save changes to that file, often because someone else has it open.

Two more shortcuts complete the cycle. Ctrl+N creates a new blank workbook. Ctrl+W closes the workbook you are working on. If there are unsaved changes, Excel asks you to choose Save, Don't Save or Cancel, so read it carefully before you click.

Let us revise what we learned today. A workbook is the whole file, and a worksheet is one sheet inside it. Ctrl+S saves the same file, and F12 opens Save As for a new name, place or type. Dot xlsx is the normal type, while dot csv keeps only plain data. Ctrl+O opens a workbook, and the Recent list is the quickest way back. AutoSave and AutoRecover are safety nets, but the best habit is to save often yourself.