博客
面向 Google Docs、Sheets、Slides 和 Forms 的指南、工作流和实用技巧。
其中 60 篇文章仅提供英文版本。
精选
Google Forms™阅读约 2 分钟
Why Google Forms Says It Is Not Accepting Responses
Check the published form status, close-date rules, response limits, storage, and shared-drive file-upload restrictions when a form suddenly closes.
Google Forms™阅读约 3 分钟
Why Google Form Responses Are Not Showing in Your Sheet
If responses appear in Google Forms but the linked Sheet is blank or stale, unlink the response destination and connect it again safely.
Google Sheets™阅读约 3 分钟
How to Fix “Array Result Was Not Expanded” in Google Sheets
Clear the cells blocking a spilled formula, then check for invisible spaces, merged cells, and formulas that occupy the output range.
Google Sheets™阅读约 2 分钟
How to Fix a Circular Dependency in Google Sheets
Find the formula that reads its own output, move the calculation to a separate range, and avoid enabling iterative calculation as a shortcut.
全部文章
81 篇文章中的 81 篇
Google Forms™阅读约 2 分钟
Why Google Forms Says It Is Not Accepting Responses
Check the published form status, close-date rules, response limits, storage, and shared-drive file-upload restrictions when a form suddenly closes.
Google Forms™阅读约 3 分钟
Why Google Form Responses Are Not Showing in Your Sheet
If responses appear in Google Forms but the linked Sheet is blank or stale, unlink the response destination and connect it again safely.
Google Sheets™阅读约 3 分钟
How to Fix “Array Result Was Not Expanded” in Google Sheets
Clear the cells blocking a spilled formula, then check for invisible spaces, merged cells, and formulas that occupy the output range.
Google Sheets™阅读约 2 分钟
How to Fix a Circular Dependency in Google Sheets
Find the formula that reads its own output, move the calculation to a separate range, and avoid enabling iterative calculation as a shortcut.
Google Sheets™阅读约 2 分钟
Why a Google Sheets Filter Misses New Rows
Recreate the filter over the full data range when new rows are excluded, and use Filter views when several collaborators need independent filters.
Google Sheets™阅读约 2 分钟
How to Select Multiple Options in a Google Sheets Dropdown
Turn on Allow multiple selections for a chip-format dropdown, avoid whitespace issues, and understand why the feature is desktop-only.
Google Sheets™阅读约 2 分钟
Why Google Sheets Shows the Wrong Date Format
Fix day-and-month swaps, text dates, and unexpected serial numbers by setting the sheet locale before applying a date format.
Google Slides™阅读约 3 分钟
Why Google Slides Audio Does Not Start Automatically
Set the audio object to start automatically, test in Present mode, and check the Drive file permission when a published deck stays silent.
Google Docs™阅读约 2 分钟
How to Keep Word Count Visible in Google Docs
Turn on Display word count while typing, understand what Docs counts, and know why the setting may need to be enabled again after reopening a file.
阅读约 4 分钟
Hide the "Browser No Longer Supported" Bar in Google Drive
Updating your browser removes Google's "browser version is no longer supported" bar. Stuck on Windows 7 or 8? One Stylus CSS rule hides it in Drive and Docs.
Google Forms™阅读约 4 分钟
How to Automatically Close a Google Form by Date or Response Limit
Use Google Forms’ built-in close date or response limit, customize the closed-form message, and avoid the response-count edge case.
Google Docs™阅读约 3 分钟
How to Start Page Numbers on a Specific Page in Google Docs
Insert a section break, unlink the new section, and start page numbering exactly where the main document begins.
Google Docs™阅读约 4 分钟
How to Remove an Extra Blank Page in Google Docs
Reveal the hidden break or paragraph creating the page, remove it safely, and check tables, margins, or browser extensions when the page persists.
Google Forms™阅读约 4 分钟
Why Google Forms Is Forcing Respondents to Sign In—and How to Fix It
Find the setting or question that is requiring a Google Account, then decide whether to remove it or keep the sign-in protection.
Google Forms™阅读约 3 分钟
Why File Upload Is Greyed Out in Google Forms
A form stored in a Shared Drive cannot use File upload questions. Move the workflow to My Drive, then share the form and responses with your team.
Google Forms™阅读约 4 分钟
How to Edit a Google Form Response After Submitting
Enable response editing before people submit, help respondents keep their edit link, and recover an existing response link as the form owner when necessary.
Google Docs™阅读约 1 分钟
How to Convert a PDF to an Editable Google Doc (Without Losing the Parts You Need)
Turn a PDF into editable Google Docs text, learn what Google Drive handles well, and use a better workflow for tables, scans, or structured data.
Google Docs™阅读约 1 分钟
How to Extract Text from an Image into Google Docs™
Convert a photo, scan, or screenshot into editable Google Docs text with Google Drive OCR or an in-document extraction workflow.
Google Docs™阅读约 1 分钟
How to Mail Merge Google Docs™ from Google Sheets™
Create personalised Google Docs from spreadsheet rows, preview one result first, then generate a complete batch and export it to PDF.
Google Docs™阅读约 2 分钟
How to Merge Multiple Google Docs™ into One Document
Combine content from several Google Docs into one editable document, with a manual method for small jobs and a guided option for up to five source files.
Google Docs™阅读约 1 分钟
How to Merge Google Docs™ Tabs into One Document
Turn selected tabs from one Google Doc into a new, continuous editable document without manually copying each section.
Google Docs™阅读约 2 分钟
How to Format a Table in Google Docs™ So It Looks Professional
Make a Google Docs table easier to read with better spacing, alignment, borders, and consistent styles—without formatting every cell one by one.
Google Forms™阅读约 3 分钟
Turn Any PDF into a Google Forms™ Quiz in Minutes (AI Quiz Generator)
Stop retyping questions from worksheets and readings. The free Text To Table Converter add-on reads your PDF pages and builds a graded Google Forms™ quiz — with answer keys, points, and source citations you can verify before anything touches your form.
Google Docs™阅读约 3 分钟
How to Write LaTeX Math Equations in Google Docs™, Slides™, and Sheets™
The built-in Docs™ equation tool is clunky — and Slides™ and Sheets™ have nothing at all. Here's how to write LaTeX once and insert crisp, re-editable equations in all three, with chemistry notation and equation numbering included.
Google Sheets™阅读约 3 分钟
Extract Line Items from Invoices and Receipts into Google Sheets™ (AI, No Retyping)
Point the Text To Table Converter add-on at a receipt or invoice and get clean spreadsheet rows — one row per line item, with the vendor, date, and receipt number filled in on every row, ready for pivot tables.
Google Docs™阅读约 3 分钟
Why ChatGPT Output Looks Broken When You Paste It into Google Docs™ (and How to Fix It)
Pasted a ChatGPT, Gemini, or Claude answer into Google Docs™ and got hashtags, asterisks, and pipe characters instead of clean formatting? Here's why it happens — and every way to fix it in Docs™, Sheets™, and Slides™.
Google Docs™阅读约 2 分钟
How to Paste a ChatGPT Table into Google Docs™ (Without the Pipes and Dashes)
ChatGPT tables turn into a mess of | pipes and --- dashes when pasted into Google Docs™. Learn three ways to get a real, formatted table instead — including the built-in 'Paste from Markdown' command.
Google Sheets™阅读约 2 分钟
How to Paste a ChatGPT Table into Google Sheets™
Google Sheets™ has no 'Paste from Markdown', so ChatGPT tables land in a single column full of pipe characters. Here are two reliable ways to turn them into proper rows and columns.
Google Slides™阅读约 2 分钟
How to Paste a ChatGPT Table into Google Slides™
Google Slides™ has no Markdown support at all, so ChatGPT tables paste as raw pipe characters. Learn how to turn them into a real presentation table in a few clicks.
Google Docs™阅读约 2 分钟
Google Docs™ Has No 'Convert Text to Table' — Here Are 3 Ways to Do It
Microsoft Word has a built-in 'Convert Text to Table' command. Google Docs™ doesn't. Here are three practical ways to turn a plain text list into a real table in Google Docs™.
Google Docs™阅读约 2 分钟
How to Convert a Table Back to Text in Google Docs™
Need to flatten a Google Docs™ table into plain text or a list? Docs™ has no 'Convert table to text' command, but there are two quick ways to do it.
Google Docs™阅读约 2 分钟
Turn a Comma- or Tab-Separated List into a Table in Google Docs™
Got CSV-style text — values separated by commas or tabs — sitting in a Google Doc? Here's how to turn it into a proper table, with or without an add-on.
Google Docs™阅读约 2 分钟
How to Merge and Split Cells in a Google Docs™ Table
Merge table cells for headers that span columns, split cells back apart, and avoid the common pitfalls — a quick guide to cell merging and splitting in Google Docs™.
Google Docs™阅读约 2 分钟
How to Sort a Table in Google Docs™ (and Keep the Header Row in Place)
Sort a Google Docs™ table alphabetically or numerically with two clicks — and pin your header rows first so they don't get sorted into the data.
Google Docs™阅读约 2 分钟
How to Split, Move, and Copy Tables in Google Docs™
Google Docs™ has no 'Split table' button, but you can break a table in two with cut and paste, drag rows between tables, and move or duplicate whole tables safely. Here's how.
Google Docs™阅读约 2 分钟
Copy a Table from Word or Excel into Google Docs™ Without Losing Formatting
Tables pasted from Microsoft Word or Excel into Google Docs™ often arrive with shifted columns, lost borders, or broken merged cells. Here's the reliable way to bring them across.
Google Docs™阅读约 2 分钟
How to Copy a Table from a Website into Google Docs™ or Sheets™
Copying a table from a web page sometimes just works — and sometimes falls apart completely. Learn when a plain paste is enough, how IMPORTHTML pulls web tables straight into Google Sheets™, and how to fix a broken paste.
Google Sheets™阅读约 2 分钟
Extract a Table from a Screenshot or Image into Google Sheets™ or Docs™
The data you need is trapped in a screenshot, photo, or scanned page. Here's how to turn an image of a table into a real, editable table in Google Sheets™, Docs™, or Slides™ — without retyping it.
Google Sheets阅读约 5 分钟
Stop Exporting CSVs. Your Spreadsheet Can Pull Live Data Now.
API Import for Google Sheets lets you describe what you want in plain English — the AI configures the full API request and writes results directly into your sheet. No API docs, no code, no developer needed. Free on Google Workspace Marketplace.
阅读约 8 分钟
2026 年 iPhone 和 Android 办公最佳 7 款 AI 应用
对比 ChatGPT、Claude、Gemini、Microsoft 365 Copilot、Perplexity、Grok 和 DeepSeek 在写作、检索、文档处理和移动办公方面的表现。
Google Docs阅读约 3 分钟
使用手机相机将手写会议笔记转换为整洁的 Google Docs™ 文本
拍摄手写会议笔记照片，使用 Text To Table Converter 插件将其加载到 Google Docs™ 中，并通过 OCR 转换为可编辑文本。
Google Slides阅读约 2 分钟
如何在 Google Slides™ 中直接渲染 Mermaid 图表
使用 Text To Table Converter 插件中的 Mermaid 语法，把流程图和其他图表转换为 Google Slides™ 中可编辑的可视化内容。
Google Slides阅读约 2 分钟
如何在 Google Docs™ 或 Google Slides™ 中将视频转换为 GIF
将短视频片段转换为适用于 Google Docs™ 或 Google Slides™ 的动画 GIF，这样您就可以插入循环视觉内容，而无需使用完整的视频播放器。
Google Docs阅读约 3 分钟
在 Google 文档™ 中批量生成 PDF 销售发票
了解如何在 Google 文档™ 中使用内置的 Sales Invoice 示例和 Mail Merge & Variables，生成全部发票文档，并将整批结果转换为 PDF。
Google Docs阅读约 3 分钟
在 Google 文档™ 中批量生成 PDF 销售报价单
了解如何在 Google 文档™ 中使用内置的 Sales Quotation 示例和 Mail Merge & Variables，生成全部报价单文档，并将整批结果转换为 PDF。
Google Docs阅读约 3 分钟
在 Google 文档™ 中批量生成 PDF 学生成绩单
了解如何在 Google 文档™ 中使用内置的 Report Card 示例和 Mail Merge & Variables，生成全部成绩单文档，并将整批结果转换为 PDF。
Google Docs阅读约 3 分钟
在 Google 文档™ 中批量生成 PDF 培训证书
了解如何在 Google 文档™ 中使用内置的 Training Certificate 示例和 Mail Merge & Variables，生成全部证书文档，并将整批结果转换为 PDF。
Google Forms阅读约 3 分钟
如何分享 Google Forms 二维码（快速方法）
了解如何为你的 Google 表单生成二维码，将其下载用于传单，或直接插入表单中用于现场演示。
Google Docs阅读约 1 分钟
如何在 Google 文档™ 中添加二维码
使用 Text To Table Converter 插件，几秒钟即可在任何 Google 文档™ 文件中添加可扫码二维码。
Google Sheets阅读约 1 分钟
如何在 Google 表格™ 中添加二维码
在 Google 表格™ 中插入二维码，通过一次扫码分享仪表板、表单和参考资料。
Google Slides阅读约 1 分钟
如何在 Google 幻灯片™ 中添加二维码
在 Google 幻灯片™ 中添加二维码，让观众在演示时即可快速打开链接。
阅读约 2 分钟
为 Google 文档添加带视频链接的二维码（教师指南）
添加一个能打开 YouTube 课程视频的二维码，让学生直接在讲义上复习概念。
阅读约 1 分钟
在讲义上添加二维码，学生就不会丢失文档（教师指南）
在讲义顶部放一个二维码，学生丢了纸也能快速打开原始文档。
阅读约 2 分钟
How to Hide Gemini and the Upgrade Button in Google Sheets™
Hide the new Try Gemini sparkle and Google Workspace Upgrade button in Google Sheets™ with a current, backward-compatible Stylus CSS snippet.
Google Docs阅读约 2 分钟
Create an Automatic, Clickable Table of Contents in Google Docs™
Stop manually creating a table of contents. This step-by-step guide shows you how to generate a dynamic, clickable TOC in Google Docs™ that updates automatically.
阅读约 3 分钟
How to Hide the AI Advertisement, Gemini, and Upgrade Button in Google Slides™
Stop the new AI getting-started advertisement from appearing when Google Slides™ opens, and hide the Try Gemini sparkle and Upgrade button with Stylus CSS.
Google Docs阅读约 2 分钟
别再在每个新的 Google Doc™ 里重复设置文本样式了
是否厌倦了反复重设字体和颜色？这篇指南会告诉你如何把自定义文本样式保存为 Google Docs™ 的永久默认值。设置一次，长期使用。
Google Docs阅读约 3 分钟
如何在 Google Docs™ 中制作 ATS 友好的简历（并通过 AI 筛选）
了解为什么大多数简历会被 AI 拒绝。本指南会告诉你如何避免常见错误，并使用 Google Docs™ 自带的免费模板通过 Applicant Tracking System (ATS)。
阅读约 3 分钟
How to Hide Gemini, Upgrade, Refine, and Floating Buttons in Google Docs™
Hide the new “Try Gemini” sparkle, the Upgrade button, Gemini bottom bar, Refine suggestions, and floating comment buttons in Google Docs™ with one Stylus CSS snippet.
Google Docs阅读约 1 分钟
Move Text Up & Down in Google Docs™
Tired of cutting and pasting? Learn the super quick keyboard shortcut to move list items and paragraphs in Google Docs™.
Google Docs™阅读约 2 分钟
How to Convert a Employee Name List to a Table in Google Docs™, Slides™ or Sheets™ - The Easy Way
Quickly convert badly formatted text lists of names into tables in Google Docs™, Sheets™, and Slides™ using our free Add-On.
阅读约 3 分钟
如何在 Google Docs™ 中关闭 Google Gemini™ 和 AI 功能？
关闭 Google Docs™ 中的 Gemini：先在 Docs 内隐藏新的底部工具条，再到 Gmail™ 关闭两个智能功能开关——已更新的分步指南。
阅读约 3 分钟
How can I turn off Google Gemini™ and AI features in Gmail™?
Turn off Gemini in Gmail™: uncheck "Smart features in Gmail, Chat, and Meet," plus the separate Workspace toggle — updated steps and the trade-offs to know.
Google Sheets™阅读约 2 分钟
How to Convert Markdown Text to a Table in Google Sheets™
Google Sheets™ doesn't natively convert Markdown tables. Use the Text To Table Converter Add-On to create tables from Markdown in your spreadsheets.
Google Slides™阅读约 2 分钟
How to Convert Markdown Text to a Table in Google Slides™
Google Slides™ lacks native Markdown table conversion. Learn how to use the Text To Table Converter Add-On to create tables from Markdown in your presentations.
Google Docs™阅读约 2 分钟
How to Convert Markdown Text to a Table in Google Docs™
Learn two ways to convert Markdown-formatted text into tables within Google Docs™ using the built-in 'Paste from Markdown' feature or the Text To Table Converter Add-On.
阅读约 1 分钟
How to copy a PDF table to Google Sheets™ - The Easy Way
Copying tables from PDFs to Google Sheets™ often breaks formatting. Learn how to easily convert PDF table data into a clean Google Sheets™ table using the Text To Table Converter Add-On.
阅读约 1 分钟
How to copy a PDF table to Google Slides™ - The Easy Way
Copying tables from PDFs to Google Slides™ often breaks formatting. Learn how to easily convert PDF table data into a clean Google Slides™ table using the Text To Table Converter Add-On.
阅读约 1 分钟
How to copy a PDF table to Google Docs™ - The Easy Way
Copying tables from PDFs to Google Docs™ often breaks formatting. Learn how to easily convert PDF table data into a clean Google Docs table using the Text To Table Converter Add-On.
阅读约 2 分钟
如何在手机上为 Google Docs™ 创建文档标签？
Google Docs™ 中的文档标签有助于整理文件，但能在手机上创建吗？了解当前移动应用的限制，以及使用桌面版网站的替代方法。
Google Sheets阅读约 4 分钟
如何将 CSV 数据导入 Google Sheets™（以 CoinGecko 数据为例）
了解如何使用 Text To Table Converter 插件在 Google Sheets™ 中将原始 CSV 文本转换为结构化表格，并通过复杂数据示例展示其相比原生工具的优势。
阅读约 1 分钟
How to Change Google Docs Pageless Width
Struggling to adjust the width in Google Docs' pageless format? The setting isn't in Page Setup like you'd expect. Learn the quick fix using the View menu.
Google Docs阅读约 1 分钟
Share Google Docs Anonymously
Want to share a Google Doc™ without revealing your identity? Since Google Docs™ doesn't have a direct anonymous share feature, explore two workarounds - publishing to the web for read-only anonymity or using a separate generic Google account for collaborative sharing.
Google Docs阅读约 2 分钟
Google Docs Tabs Download All Tabs as PDF
Struggling to download your entire Google Docs™ file with tabs? Learn the common pitfalls and the definitive solution for creating a clean, single PDF without unwanted title pages.
阅读约 2 分钟
Enable Dark Mode in Google Docs™ (only Google Chrome)
Staring at bright screens can cause eye strain. Google Docs™ lacks a built-in dark mode, but Chrome users can force it for all Google apps. Learn how to enable dark mode for Google Docs™, Sheets™, and Slides™ easily.
阅读约 2 分钟
Accidently deleted text in Google Docs™? Here is how to restore it
Accidentally deleted text in Google Docs™? Don't panic! Google Docs™ automatically saves versions, so you can easily restore lost content using the version history feature.
阅读约 2 分钟
What are the new Google Docs™ document tabs
Google Docs™ introduces document tabs for better organization within a single file, similar to Google Sheets™. Learn how to use this new feature to manage complex documents more efficiently.
阅读约 1 分钟
用这个快捷方式在几秒钟内创建新的 Google 文档
了解 `docs.new` 这类简单的浏览器快捷方式，让你只需几次按键就能立即创建新的 Google Docs™、Sheets™、Slides™、Forms™、Calendar 事件和 Sites，节省更多时间。
阅读约 2 分钟
Google Docs Not Showing Pages? Here's Why, and How to Fix It
Wondering why your Google Docs document isn't showing page breaks? It's likely in Pageless mode. Learn how to switch back to the standard Pages view, and understand the key differences between the two layouts.
阅读约 1 分钟
如何保存 Google Docs™ 文档
Google Docs™ 会在你输入时自动保存，因此不需要手动保存按钮。了解如何为文档命名、查看版本历史，以及离线修改会如何处理。
Google Docs™阅读约 4 分钟
Using Markdown in Google Docs™ and Slides™ for Text, Lists & Tables (Docs Only)
Learn how to enable and use Markdown for auto-formatting text while typing, pasting blocks, and creating tables (in Google Docs™ only!) directly within your documents and presentations.