How many Method To save Excel file? | Excel Ki File Kaise Save Kare | How to save Excel File? | Microsoft Office Excel | Excel Mastering | Mastering Excel: Save Like a Pro!

 Mastering Excel: Save Like a Pro!

There are several methods to save an Excel file, depending on the version of Excel you are using and your preferred workflow. Here are the common methods:

1. Using the Ribbon (Menu Options)

  • Excel 2016, 2019, 2021, and Microsoft 365:
    Click File > Save (to save with the same name and location).
    Click File > Save As (to save with a new name, location, or format).
    Excel 2013 and earlier: Similar steps apply.

     

  • 2. Using Keyboard Shortcuts

    • Save (Same File):
      Windows: Ctrl + S
      Mac: Command (⌘) + S
      Save As (New File):
      Windows: F12 (opens "Save As" dialog) 
      Mac: Command (⌘) + Shift + S

      • 3. Quick Access Toolbar (QAT)

        • Click the Save icon (💾) in the Quick Access Toolbar (usually at the top-left corner).

        4. Right-Click Method (Windows File Explorer)

        • If the file is open, you can right-click the Excel tab and choose Save or Save As.

        5. AutoSave (Microsoft 365 & OneDrive/SharePoint)

        • If AutoSave is turned on (for cloud-stored files in OneDrive or SharePoint), Excel automatically saves changes.

        6. Using VBA (Macro)

        • You can use VBA code to save files programmatically:

          • vba
            Copy
            ActiveWorkbook.Save 'Saves the current file
            ActiveWorkbook.SaveAs "C:\Path\Filename.xlsx" 'Saves with a new name/location

          7. Exporting to Different Formats

          • File > Save As > Choose a format (e.g., .xlsx.xls.csv.pdf).

          8. Command Line (for Automation)

          • Use PowerShell or CMD to save Excel files via scripting (requires Excel COM object).


Post a Comment

0 Comments

COUNTIF से डेटा कैसे काउंट करें? || How to Count Data Using COUNTIF in Excel? | How do I count data in Excel Countif? | How do I use countif in Excel for multiple criteria?