Sending spreadsheets for review lets users in your workspace view and comment on a particular version of a spreadsheet. When you request a review, your reviewer receives a read-only version of your spreadsheet, allowing them to add comments without altering your original file.
Create a spreadsheet review
You can create a review from the Review tab, History panel, Blacklines panel, or Translate Spreadsheet panel.
To create a review in each of these locations:
- From the Review tab, click Review and select Create a Review from the menu.
- Send a previous revision for review by clicking the arrow next to a revision in the History panel and selecting Send for Review.
- Within the Blacklines panel, select the arrow next to the blackline and choose Send for Review.
- To send a translated spreadsheet for review, navigate to the Translate Spreadsheet panel, select the arrow next to your translation, and choose Send for Review.
傳送試算表以供審閱
Once you create a review from the Review tab or the right-hand panels, you can choose the review settings and send the review.
To send a review:
- Select to send all the sections you have permissions to or to send selected sections. If you want to send specific sections, select the checkbox next to each section you want to include.
Use the Expand and Collapse buttons to open and close sections. - Select Include attachments if you want to have attachments added to the review.
- Select which comment threads to include or exclude.
註解選項 說明 不包括註解對話串 此選項將不包括留在原始檔案或過去審閱上的任何註解對話串。 包括所有註解對話串 This option pulls any comment threads left on the original spreadsheet and on past reviews. Comments from unselected reviews might appear if you opt to send all comments when creating the selected review. 包括過往審閱的註解對話串 此選項僅包括所選過去審閱的註解。如果未選取審閱的註解包括在另一個審閱中,則可能會顯示這些註解。 從即時版本檔案中排除新增至審閱的註解 This option can be marked in addition to one of the comment options above. 對正在傳送的審閱留下的任何註解都不會新增至檔案的即時版本中。 Note: Comment options are not included in Send Translation for Review. You will only have the option to send the entire translation or to send selected sections.
- 在「詳細資訊」下,新增審閱的標題。This title appears in the Reviews panel after you send your request to help you keep track of the review process.
- Add users from your workspace to send the review to. 如果工作區包含「群組」,則可以透過選取群組名稱將審則傳送給所有群組成員。
- Add content for an email notification, including a subject and message. 此內容可用於向審閱者詢問特定意見反應或設定審閱截止日期。
- 按一下「傳送」以傳送您的要求。Your reviewer receives an email with a link to the read-only file.
注意:審閱檔案中的權限設定與原始檔案不同。Requesting a review creates a separate review file and doesn't change the permission set on the source file.
By default, only Owners can send spreadsheets for review. If you'd like to allow Editors or Viewers to send reviews, you can change this setting under Permissions in the Spreadsheet Properties.
使用審閱面板
要求審閱後,有關該要求的資訊將顯示在「審閱」面板中。To access the panel, click the Reviews icon in the right panel. 選取審閱時,您可以查看請求的傳送時間和傳送給誰。
You can also edit or delete a review using the arrow next to a review’s title in the Reviews panel. 要新增更多審閱者或變更審閱名稱,請按一下功能表中的「編輯」。
若要刪除請求,請從功能表中選取「刪除」。Deleting a review automatically deletes the read-only spreadsheet. Clicking the Open Review icon opens the view-only spreadsheet in a new tab. 如果審閱者留下了註解,您可以在此處檢視註解。
審閱檔案
If you receive a request to leave a review, you’ll be taken to a read-only version of the spreadsheet.
如要開始審閱,請按一下要求電子郵件中的「前往審閱」(Go To Review)。
From here, you can add comments to the spreadsheet or sheets. 要新增註解:
- Select the desired cells within the sheet.
- Click Add in the toolbar or within the Comments panel.
- 輸入您的註解,然後按一下「發佈」(Post)。You can reply to comments directly on the sheet or within the Comments panel.
When reviewing all comments, the Comment icon in the outline panel shows the number of comments in each section.
You can also use the Comments panel to jump to the location of each comment thread in the spreadsheet review.
When reviewing the spreadsheet, you can also:
- Export the content to PDF, XHTML, Excel, or CSV.
- Use Find to search for specific words or phrases.