OBINTUSACADEMY
HOME CONTACT SERVICES PRIVACY
COMPUTER BASICS MS-PACKAGES
Excel - Saving Your Workbook

MICROSOFT EXCEL

MODULE ONE

Prerequisite Introduction to Microsoft Excel Getting Started MS Excel Environment Title Bar Quick Access Toolbar Search Account Name Buttons Menu Tab Ribbons Dialog Box Launcher Name Box Insert Function Formula Bar Worksheet Area Worksheet Navigation Creating New Sheet Status Bar Worksheet View Format Zoom Slider MS Excel File Tab Entering Data Saving Your Workbook Opening Saved Workbook Copy, Delete and Hiding Sheet Closing Entire Workbook

MODULE TWO

Cells, Rows and Columns Resizing Rows and Columns Inserting Data Select, Delete and Move Data Copy, Paste and Cut Find and Replace Checking Spellings Inserting TextBox Inserting Symbols Inserting Special Characters Zooming Undoing and Redoing Changes

MODULE THREE

Mini Toolbar Setting Fonts Text Decoration Setting Text Case Text Alignments Text Orientation Increase and Decrease Indentation Wraping Text Merging Cells Cells Borders Cells Shades Copy Formatting Insert and Delete Worksheet Format Worksheet, Cells, Rows and Columns

MODULE FOUR

Insert Tables Insert Pictures Insert Shapes and Smart Art Insert Screenshots Insert Icons Insert 3D-Models Using Add-ins Insert Charts 3D Maps Creating Sparklines Insert WordArt

MODULE FIVE

Addition Subtraction Multiplication Division Using Formulas Using Functions Quick Functions

MODULE SIX

Fill Handling Sorting Filtering References (Relative and Absolute) Conditional Formatting Applying Styles

MODULE SEVEN

Page Themes Page Colors Page Fonts Page Effects Page Header and Footer Page Numbering Page Margins Page Orientation and Size Print Area Page Breaks Setting Background Print Titles Preview and Print Share Workbook Freezing Panes Range Data Validation Excel Templates MS Excel Shortcuts Conclusion

HOW TO

Excel How-To Send Email Separate Text Date and Time Format Macro Thesaurus Insert Comments Password Workbook Count Characters Count Words Add and Remove Hyperlinks Insert PDF in Excel Editing and Formatting Restrictions How to Compare Columns How to Compare Worksheets Add Signature in Worksheet Calculate Age Calculate Mean Calculate Median Calculate Standard Deviation Find the Mode Add and Remove Commas How to Remove Filter Convert Excel to CSV Excel to PDF Excel to Ms-Word Document Excel to Picture Formats Duplicate Rows and Columns Hide and Unhide Rows and Columns Rows and Columns Conversion How to Remove Gridlines Create Graphs Insert Check Box Add and Remove Watermark Logical Operators Logical Functions Text Functions Square Symbol Pi Symbol Selecting Different Columns Creating QR Code Creating Bar Code Insert Bullet Points Generate Random Numbers Combine Two Columns Wrap Text Create Dropdown List

Saving Your Workbook

PREVIOUS NEXT

There is always need save your workbook after entering data. This is important so as not to lose your workbook in case your computer device mistakenly shuts down.

  • STEPS TO SAVE YOUR WORKBOOK
  • Step 1 - Click on File option in the menu tab (This will open your file options page). Then move to Save or Save As and click on it.
    • saving-your-workbook
  • Step 2 - From the second column in the save or save as page, click on the location you want to save your document to. In my own case I am clicking on the Browse location.
    • saving-your-workbook
  • Step 3 - After clicking on the browse option, Excel will open your file explorer.
    Now select the location you want you file to be saved to. Enter your document name in the File Name input field.
    The file type by default will already be in .docx which is the extension name for Ms-word documents.
    Then click on the Save button
    • saving-your-workbook
  • Step 4 - After clicking on the save button, your document will be saved successfully!
    saving-your-workbook
  • ALTERNATIVE METHOD TO SAVE YOUR WORKBOOK
  • Press Ctrl + S on your keyboard.
    This will bring out a dialog box for you to type in your document and select the location you want to save your document from the selection menu box. (By default, your documents folder will be selected)
    • saving-your-workbook
  • After this you can click on the Save button to save your document.
    saving-your-workbook
  • If you click on the link More options it will take you to the save as or save page to select the location you want and proceed to file explorer and save.
note
NOTE:

When saving a New Workbook, Excel uses the placeholder sequence Book1, Book2, ... to set as your default workbook name, that is why you often see a name already filled in your file name input field when you want to save.

To save pre-existing document that you made changes on, press Ctrl + S on your keyboard and it will be saved.
OR, click on File on your menu tab and click on Save and your changes will be saved.

When saving your pre-existing document changes, Excel will not open your file explorer for you to choose location or type in your file name again, your document will just save and remain in your excel window.

tips
TIP:

If you want to make changes to an existing document and save it separately, you will have to use the Save As option following the first method given above.
After saving you will have two separate workbooks: your old workbook without changes and your current workbook with the changes you made.

PREVIOUS NEXT
ADVERTISEMENTS

LEARNING IS A CONTINOUS PROCESS - PRACTICE MAKES PERFECT