Master Productivity Guide – MS Word, MS Excel, Google Forms, Windows Shortcuts & More

1) Typing in Hindi without installing fonts (English) / बिना फ़ॉन्ट इंस्टॉल किए हिंदी टाइपिंग

Use Google Input Tools (Online):
Select Hindi → Type in English (e.g., namaste) → Pick the Hindi word (नमस्ते) → Copy where needed.

हिंदी में: Google Input Tools खोलें → भाषा में Hindi चुनें → अंग्रेज़ी उच्चारण से टाइप करें (जैसे namaste) → सुझाए गए हिंदी शब्द (नमस्ते) चुनें → कॉपी करें।

2) MS Excel – Productivity Boosters (English + हिंदी)

• Alt + H + O + I → Auto-fit column width / कॉलम चौड़ाई फिट
• Alt + H + O + A → Auto-fit row height / रो ऊँचाई फिट
• Ctrl + T → Convert range into Table / टेबल बनाएं
• Ctrl + Shift + L → Toggle Filter / फ़िल्टर ऑन/ऑफ
• Ctrl + ; → Today’s date, Ctrl + Shift + : → Current time
• Advanced: Pivot Table, Data Validation (Dropdown), Conditional Formatting

How to Display the Full File Path in Excel Using a Simple Formula

When working with multiple files on your computer, it often becomes difficult to remember where a particular Excel file is saved. Excel provides a very easy formula that instantly shows the complete file path, folder location, and sheet name.

✔️ Formula to Use

=CELL("filename")

📝 How to Insert the Formula Step-by-Step

1. Click on any blank cell in your Excel sheet.
2. Type the formula:

   =CELL("filename")
       

   You can also type =CELL( and choose “filename” from the dropdown list that appears.

3. Press Enter.
4. Excel will immediately display the complete path where your current file is saved.

📁 What Information Does This Formula Show?

After pressing Enter, you will see something like:

C:\Users\YourName\Documents\Accounts\MyFile.xlsx]Sheet1

This displays:

• Drive (C:)
• Folders (Users → YourName → Documents → Accounts)
• File Name (MyFile.xlsx)
• Sheet Name (Sheet1)

💡 Why This Is Useful

• Helps you quickly locate the exact folder where the file is stored.
• Useful when working with many files saved in different locations.
• Helpful for documentation, audits, or file management systems.
• Ensures you always know the correct file location without searching manually.

3) MS Word – Smart Tips (English + हिंदी)

• Real-time collaboration via OneDrive / OneDrive से एक साथ एडिटिंग
• Developer Tab → Fillable forms (Text fields, Checkboxes, Date pickers)
• Review → Translate / त्वरित अनुवाद, Home → Dictate / बोलकर टाइप
• References → Table of Contents / स्वत: विषय-सूची
• Shortcuts: Ctrl + K (Hyperlink), Shift + F3 (Change Case), Alt + Shift + D (Date), Alt + Shift + P (Page #)

How to Print the File Path in a Microsoft Word Document

Sometimes we need to show the exact folder location of a Word file—especially for documentation, audits, or reference purposes. MS Word provides easy built-in options to display and print the file path automatically.

✔️ Method 1: Insert File Path Using Field Code

This is the simplest method.

1. Open your Word document.
2. Place the cursor where you want to show the file path.
3. Go to Insert → Quick Parts → Field.
4. From the list, choose FileName.
5. Check the option Add path to filename.
6. Click OK.

Now the complete file path will appear, for example:

C:\Users\YourName\Documents\Project Files\Report.docx

This text will also be included when you print the document.

✔️ Method 2: Insert File Path in Header or Footer (Recommended for Printing)

If you want the file path printed on every page of your document:

1. Go to Insert → Header or Footer.
2. Click Edit Header (or Edit Footer).
3. Go to Insert → Quick Parts → Field.
4. Select FileName from the list.
5. Tick Add path to file name.
6. Click OK.
7. Close Header/Footer.

Now the file path will print on every page automatically.

✔️ Method 3: Print Document Properties Automatically

If you prefer Word to print the file path automatically without inserting it in the document:

1. Go to File → Options.
2. Select Display.
3. Under “Printing options,” tick:
   ✔ Print document properties
4. Click OK.

This will include the file path in the printed properties page.

⭐ Best Method to Use

4) Create Google Forms Faster using Form Builder (English + हिंदी)

Why: Perfect for quizzes, registrations, feedback; imports questions from Sheets/Excel; reuses blocks; saves a lot of time.

English – Steps

1. Open Google Sheets.
2. Go to Extensions → Add-ons → Get add-ons.
3. Search for Form Builder and install it (follow prompts).
4. Open it via Extensions → Form Builder.
5. Prepare your questions in the sheet (Columns like: Section, Question, Type, Options, Required).
6. Use Form Builder to import questions from the sheet and build a Google Form in one go.
7. Customize theme (palette icon), then Send (link, email, or QR).
8. (Optional) For quizzes: Settings → Make this a quiz, assign points & answer key.

हिंदी – चरण

1. Google Sheets खोलें।
2. Extensions → Add-ons → Get add-ons पर जाएँ।
3. Form Builder खोजकर इंस्टॉल करें।
4. Extensions → Form Builder से ऐड-ऑन खोलें।
5. शीट में अपने प्रश्न तैयार रखें (जैसे कॉलम: Section, Question, Type, Options, Required)।
6. Form Builder से शीट से प्रश्न Import करें और एक ही बार में Google Form Create करें।
7. थीम/रंग (Palette) बदलें, फिर Send से लिंक/ईमेल/QR साझा करें।
8. (वैकल्पिक) क्विज़ के लिए: Settings → Make this a quiz, अंक और Answer key सेट करें।

5) Windows Run Commands (Quick Access) / रन कमांड्स

Open Run with Win + R, then type a command:

6) Image Creation & Visual Tools (English + हिंदी)

• Canva – Fast graphics, infographics, blog banners. / आसान डिज़ाइनिंग
• PowerPoint / Google Slides – Quick layouts → Export as PNG/JPG.
• Snipping Tool / Win + Shift + S – Region screenshots for tutorials.
• Google Input Tools – Type Hindi phonetically and paste into images/captions.
• Reduce the PNG Image Size : https://imageresizer.com/png-compressor

7) Final Note

This guide brings together daily-use tools and tips: MS Word, MS Excel, Google Forms with Form Builder,
Windows shortcuts, Hindi typing, and visuals—so your writing, data entry, and publishing stay fast and tidy.
Share it with colleagues, students, and friends.

आप इस गाइड को कभी भी संदर्भ के लिए इस्तेमाल करें और ज़रूरतमंद लोगों तक पहुँचाएँ।

Also Read :
https://moneymattersbynktehri.in/free-smart-file-management-how-to/
https://moneymattersbynktehri.in/excel-formula-master-sheet-beginner/
https://moneymattersbynktehri.in/what-is-mail-merge-full-process/