There’s tons extra you are able to do with Gemini in Google Sheets and the opposite Workspace apps. See “Google Workspace: 7 nice methods to make use of the Gemini AI sidebar” for detailed directions and use instances.
Handle a number of sheets in a spreadsheet
Every web page of your spreadsheet is represented as a tab alongside the underside of the display screen. Clicking considered one of these tabs exhibits you its corresponding sheet on the display screen.
So as to add a brand new, clean sheet to your spreadsheet: Click on the “+” on the lower-left nook.
To delete or rename a sheet: Click on the triangle on the sheet’s tab. From the menu that opens, choose Delete or Rename.
To alter the order of your sheets: Click on-and-hold a sheet’s tab, then drag it left or proper to a different spot within the row of tabs, and launch it.
Use the tab menu to delete, duplicate, copy, rename, or transfer a sheet.
Howard Wen / Foundry
Choose a design theme to your spreadsheet
On the menu bar alongside the highest of the display screen, click on Format > Theme. A panel will open alongside the proper, displaying you many massive thumbnails of themes. Scroll via the checklist and click on the thumbnail for the one that you just wish to use to your spreadsheet. You possibly can apply a theme to a brand new clean spreadsheet or to at least one that already has a design.
Making use of a theme to a spreadsheet.
Howard Wen / Foundry
Get help as you enter information
As you’re coming into formulation into cells, Google Sheets could make corrections to your formulation (if it thinks you’ve made a mistake) or fill in cells with urged changes to your formulation.
For instance, for those who’re coming into the identical formulation cell-by-cell down a column, however altering the formulation to correspond with the row quantity, Sheets could routinely insert your formulation into the cells additional down the column and apply what it predicts can be your succeeding changes to the formulation.
This clever help is on by default, however for those who discover that it will get in your means, you possibly can flip it off: On the menu bar alongside the highest of the display screen, click on Instruments > Suggestion controls and deselect Allow autocomplete, Allow formulation recommendations, and Allow formulation corrections. On this menu, you’ll see switches for different classes, equivalent to desk and information evaluation recommendations, which you could change off.
If Sheets’ formulation recommendations aren’t working for you, you possibly can disable them.
Howard Wen / Foundry
Share your spreadsheet
By way of Google Sheets or Google Drive, you possibly can share a spreadsheet for others to view or edit.
From the Google Sheets display screen the place you’re enhancing your spreadsheet, click on the sunshine blue Share button on the higher proper. Or, from the Google Drive house display screen, right-click the filename of your spreadsheet and choose Share > Share from the menu that opens. Both means, the Share pane opens.
Google permits you to share your spreadsheet privately by inviting particular folks to entry it, or publicly, which suggests anybody with the hyperlink to it might probably open it. Generally, enterprise customers will wish to share their spreadsheets privately with particular colleagues. However there could also be a number of occasions when you might want to share it publicly, equivalent to if you’re looking for public feedback on a spreadsheet.
Setting permissions for a file being shared privately.
Howard Wen / Foundry
Share your spreadsheet privately (solely sure folks can entry it)
On the Share pane, sort within the names or e mail addresses of the folks you wish to collaborate with on the spreadsheet. You can too sort in a quick message to them.
By default, each particular person you add is given Editor entry to your spreadsheet. You possibly can change this by clicking Editor on the proper of their title and deciding on Commenter or Viewer from the dropdown that opens.
Editor means they will change your spreadsheet, add feedback to it, and reshare it with different folks.
Commenter means they will view your spreadsheet and add feedback to it, however they can’t change it.
Viewer means they will view your spreadsheet, however they can’t change it or add feedback to it.
Remember that this setting applies to everybody you’re presently inviting to the spreadsheet.
While you’re completed, click on Ship. Everybody you’ve added will obtain an e mail with a hyperlink they will click on to entry the spreadsheet.
Change, restrict, or revoke permissions
You possibly can change anybody’s permissions for a spreadsheet at any time by reopening the Share pane for the spreadsheet. It is going to checklist everybody who has entry to the spreadsheet. Click on the dropdown subsequent to their title to alter their permission degree or take away their entry completely, then click on Save.
You possibly can change permissions for folks you’ve shared a spreadsheet with on a person foundation.
Howard Wen / Foundry
You can too restrict the general permissions for a spreadsheet considerably by clicking the gear icon within the higher proper of the Share pane:
Uncheck the primary checkbox to forestall others on the Editor degree from resharing the spreadsheet or altering different collaborators’ permission degree.
Uncheck the second to forestall different Editors from downloading, printing, or copying the spreadsheet. Uncheck the third to do the identical for anybody with Viewer or Commenter standing.
Set an expiration date
Beneath a Google Workspace plan, you can even lower off entry to an individual you’ve shared your spreadsheet with beginning on a specified date.
To do that, click on the down arrow to the proper of a collaborator’s title on the Share pane and choose Add expiration. Then, to the proper of “Entry expires…,” click on the pencil icon and choose an expiration date (and time in order for you) on the pop-up calendar; it may be inside one 12 months of the present date. Click on Finished.
You possibly can set an expiration date for a collaborator’s entry to a spreadsheet.
Howard Wen / Foundry
Share your spreadsheet publicly (anybody can entry it)
On the backside of the Share pane is a “Copy hyperlink” button which you could click on to repeat the hyperlink to your spreadsheet. By default, this hyperlink is restricted to these you invite to the spreadsheet.
To alter it to a public hyperlink, click on Restricted and choose Anybody with the hyperlink from the dropdown menu.
Producing a public hyperlink to a spreadsheet.
Howard Wen / Foundry
By default, this hyperlink has Viewer entry assigned to it. To permit folks to touch upon or edit your spreadsheet: Click on the Viewer dropdown to the proper after which choose Commenter or Editor.
After you’ve made your above picks, click on the Copy hyperlink button. Now you can paste this hyperlink to your spreadsheet into an e mail, direct message, or doc, or put up it on a public discussion board or social media. Keep in mind that anybody who sees and clicks this hyperlink will have the ability to entry your spreadsheet.
To show off this publicly accessible hyperlink to your spreadsheet, reopen the Share pane and click on Anybody with the hyperlink. From the dropdown that opens, choose Restricted. Then click on the Finished button.
Standing of your shared spreadsheets
In your Google Drive or Google Sheets house display screen, spreadsheets you’re sharing privately or publicly are marked by an icon of two silhouetted heads. (When you’ve got the house display screen of Google Drive set to “Grid format,” this icon received’t seem with the thumbnail or filename of a shared spreadsheet.)
In file listings, shared spreadsheets present a “shared” icon to the proper.
Howard Wen / Foundry
Collaborate in your spreadsheet
The folks you’ve shared a spreadsheet with can view or work on it similtaneously you, or at different occasions. Keep in mind that individuals who have Editor privileges to your spreadsheet can change all features of it.
Having a number of folks making modifications to a spreadsheet can get complicated and introduce errors. Generally, setting everybody to Commenter is one of the simplest ways to collaborate in Sheets. Folks can connect feedback to particular cells, however their feedback received’t intrude along with your spreadsheet’s information.
So as to add a remark: Click on inside a cell and, on the toolbar above the spreadsheet, click on the Insert remark icon (the speech balloon with a + towards the proper finish of the toolbar — you might need to click on the vertical three-dot icon to see it).
Click on this toolbar button to insert a remark.
Howard Wen / Foundry
A clean remark card along with your title on it opens by the cell. On this card’s entry line, sort a quick remark, and if you’re completed, click on the Remark button.
Typing in a brand new remark.
Howard Wen / Foundry
To attract somebody’s consideration to a remark: As you’re composing the remark, sort the @ image and start typing their title, then choose the particular person from the checklist of urged Google contacts that seems. They’ll obtain an e mail notifying them of the remark and linking to it.
To learn and reply to a remark: A cell that accommodates a remark is denoted by a tiny triangle at its upper-right nook. To learn it, transfer the pointer over the cell; the commenter’s title and their remark will seem subsequent to it.
To answer: Click on the cardboard or cell. The cardboard will broaden to disclose an entry field the place you possibly can add a remark in response. Click on Reply if you’re completed. The remark card will now present the unique remark and your reply to it.
Studying and responding to a remark.
Howard Wen / Foundry
To edit, delete, or resolve a remark: Transfer the pointer over the cell that has a remark. The remark card will open. Transfer the pointer over the cardboard.
Clicking the blue checkmark marks this remark as “resolved” and removes the cardboard from the principle spreadsheet.
Clicking the three-dot icon to the proper of the unique first remark opens a menu that permits you to edit, delete, or get a hyperlink to your remark.
Clicking the three-dot icon to the proper of any reply opens a menu that permits you to edit or delete the reply.
To see all feedback in a spreadsheet: Click on the speech balloon icon that’s towards the higher proper of the Sheets window (it’s to the left of the Share button). The Feedback panel will open alongside the proper of the display screen; it lists all of the remark playing cards in your spreadsheet.
While you click on a remark card on this checklist, the view of your spreadsheet in the principle window will soar to the cell the place the remark is positioned, and the remark card can be opened. You possibly can reply to the remark from throughout the Feedback panel or the remark card on the spreadsheet.
The Feedback pane permits you to shortly overview all feedback and soar to particular ones.
Howard Wen / Foundry
Resolved feedback seem on the high of the Feedback panel. To revive a resolved remark to the spreadsheet, transfer the pointer over its remark card, click on the three-dot icon that seems on it, and choose Re-open from the menu.
For extra particulars about collaborating in your spreadsheet, together with what it’s prefer to collaborate in actual time, see “Learn how to collaborate on a doc” in our Google Drive information.
Get well older variations of a spreadsheet
Errors occur, and it’s possible you’ll wish to undo modifications you or others have made to a spreadsheet. To lookup older variations of an open spreadsheet, click on File > Model historical past > See model historical past. Or, above your spreadsheet, and towards the higher proper, click on the clock icon.
A panel opens on the proper that exhibits a listing of older variations of your spreadsheet, organized by date and time. To see what an earlier model of the spreadsheet appears like, click on its date or model title within the checklist. That model will seem in the principle window.
Viewing an earlier model of a spreadsheet with model historical past.
Howard Wen / Foundry
If you wish to use this older model to interchange the present model of your spreadsheet, click on the blue Restore this model button on the upper-left of the display screen. This restored model will then seem on the high of the model historical past checklist.
If you wish to give an older model a singular title, click on its date. You’ll be prompted to sort in phrases to interchange the date. The model’s date and time will then seem in smaller sort beneath its new title.
Obtain and export your spreadsheet to Excel or PDF
You possibly can obtain a spreadsheet and convert it to PDF, .xlsx (if it’s not already an Excel spreadsheet), or one other format equivalent to OpenDocument (.ods), Comma Separated Values (.csv), or Tab Separated Values (.tsv).
With the spreadsheet open, choose File > Obtain within the high menu bar and select a file format. The spreadsheet can be saved to your PC’s storage drive in that format.
Downloading a spreadsheet.
Howard Wen / Foundry
Alternatively, you possibly can choose File > E-mail after which decide both E-mail this file or E-mail collaborators. This motion will open a panel that permits you to e mail your doc as an attachment. PDF is the default, however you possibly can click on the PDF drop-down menu and select Excel or Open Workplace Spreadsheet.
Use the Google Sheets cell app
Except for the Model historical past device, the Google Sheets app (out there for Android, iPhone and iPad) has lots of the identical options described on this information. You in all probability received’t wish to do any heavy spreadsheet enhancing on a telephone display screen, however the cell app is useful for making fast edits, in addition to sharing and commenting on sheets.
Toolbars alongside the highest and backside of the display screen allow you to add feedback and new sheets to your spreadsheet. Tapping a cell brings up high and backside toolbars. The picks on these toolbars allow you to add columns or rows subsequent to the cell, or edit the formulation or textual content inside it.
Faucet the three-dot icon on the proper finish of the highest toolbar to make use of the “Knowledge validation” device or to create named ranges, share your spreadsheet (see our Google Drive information for directions on sharing from the cell app), or export it to a different file format.
Two views of the Google Sheets Android app.
Howard Wen / Foundry
Use keyboard shortcuts
Save time in Sheets through the use of keyboard shortcuts for frequent duties. Beneath are a number of the most helpful to know. For extra, choose Assist > Keyboard shortcuts from the highest menu when you’ve a spreadsheet open or press Ctrl + / (Home windows, Chrome OS) or ⌘ + / (macOS).
Helpful Google Sheets keyboard shortcuts
BASICSActionChrome OS and Home windows shortcutmacOS shortcutSelect columnCtrl + SpaceControl + SpaceSelect rowShift + SpaceShift + SpaceSelect allCtrl + A⌘ + ACopyCtrl + C⌘ + CPasteCtrl + V⌘ + VUndoCtrl + Z⌘ + ZRedoCtrl + Y⌘ + YFindCtrl + F⌘ + FFind and replaceCtrl + H⌘ + Shift + HFill downCtrl + D⌘ + DFill rightCtrl + R⌘ + RFill rangeCtrl + Enter⌘ + EnterInsert commentCtrl + Alt + M⌘ + Possibility + MInsert rows above choice or columns to the left of selectionCtrl + Alt + =⌘ + Possibility + Shift + =Delete chosen rows or columnsCtrl + Alt + –⌘ + Possibility + –USING FORMULASActionChrome OS and Home windows shortcutmacOS shortcutShow all formulation in spreadsheetCtrl + ~ Management + ~Insert array formulaCtrl + Shift + Enter⌘ + Shift + Enter Supply: Google
Able to take Sheets to the subsequent degree? Take a look at “6 fast suggestions for Google Sheets.”
This text was initially revealed in August 2019 and most lately up to date in August 2025.
Extra Google Sheets suggestions: