Drive and Photo Service:Online editing

Multi-user collaboration

1. Multi-user editing: Multiple users can edit the same document simultaneously. When co-editing a spreadsheet, the avatars of online collaborators appear in the upper-right corner. You can use features such as Comment on the Collaboration tab.

2. Protected range: You can restrict editing to specific ranges in a spreadsheet, which is useful for managing project progress, regional data, or inventory. On the Collaboration tab, click Protected Range to open the Range Permissions panel. You can protect a worksheet to make it view-only for other users, and then click + Add an editable range to specify which ranges they can edit.

3. Collaboration record: You can view the collaboration time, collaborators, and actions performed in the spreadsheet. Click the collaboration icon in the upper-right corner to open the Collaboration Record panel, which displays each user's operation history, including the time, user, action type, and corresponding cell.

Synchronous filtering

1. Enable synchronous filtering: The filter state remains consistent for all collaborators. You can also configure SUBTOTAL to ignore rows hidden by the filter. To enable this feature, click the Filter icon in the toolbar, then enable the Filter visible to all switch. This synchronizes filtering for all collaborators.

2. Disable synchronous filtering: Each collaborator can filter data independently without affecting others' views. This is controlled by the Filter visible to all switch in the filter pop-up window.

Interlaced marking

1. You can apply alternating colors to rows in a table to improve readability. This feature is only available in collaborative documents. To apply alternating colors, select View > Alternating Colors from the menu bar.

Smart fill

1. Smart fill analyzes data in the active cell's column and adjacent columns to quickly complete data entry. This is useful for tasks such as extracting personal information. On the Data tab, click Smart Fill (shortcut: Ctrl+E).

Drop-down lists

1. You can insert a drop-down list into a cell, which is useful for project management, data collection, and other scenarios. On the Insert tab, click Drop-down List to add one to the selected cell.

Comments

1. You can add a comment to a selected range of cells. A colored indicator appears in the corner of a cell with a comment. The comment is hidden until you select the cell. From the top menu bar, click Collaboration and then Comment. The drop-down menu provides the Insert Comment, All Comments, Previous, and Next options. After inserting a comment, a panel appears on the right displaying the cell reference, collaborator, time, and comment content. The input box at the bottom lets you reply and @mention other users.

Folder structure

1. The continuous page view prevents text, tables, and images from being split across page breaks. This is ideal for documents such as lists, schedules, and project plans. To enable this view, on the View tab, click Continuous.

Comments

1. You can select text to add a review comment, which appears on the right side of the document. On the Review tab, click Comment. The drop-down menu includes Insert Comment, Show Comment Box, and Show Comment Pane. If you select Show Comment Box, comment bubbles appear on the right side of the document.

Collaboration records

1. You can view the document's collaboration history, including the time, collaborator, and actions performed. On the Review tab, click Collaboration Record to open the panel on the right. The panel displays collaborative actions grouped by date, such as Joined collaboration, Inserted comment, and Marked comment as resolved. Each record shows the time and the user who performed the action.

Master view

1. In master view, any properties you set or content you insert are applied to all slides that use that master. To open master view, on the menu bar, click View > Master View.

Comments

1. You can add review comments to individual slides and view a history of comments, including the time, author, and content. This is useful for internal team reviews. On the Review tab, click Comment (shortcut: Ctrl+Alt+M) to add a comment. The comment panel on the right shows the list of comments for the current slide and lets you reply.

Collaboration records

1. You can view the time, collaborator, and actions performed on the slides. The Collaboration Record panel displays the file's collaboration history, including the collaborator's name, the action type (such as commenting on an object), and the time of the action.