Overview
New Sheets are purpose-built for speed, flexibility, and modern Excel-like functionality. This brings additional features to your sheets, including:
Drag-to-fill
Bulk copy-paste
Auto-row heights
Custom row heights
Faster load times
And more!
Enable New Sheets
Enable or disable New Sheets by using the toggle at the top-right of your sheet.
Set sheets preference
Set a preference for your default sheets experience in your user settings. Instead of choosing each time, this setting will enable or disable new sheets automatically when opening sheets.
Add rows
Insert one or more rows above or below the current row from the settings menu:
Move rows
To move a row:
Hover over the handle
on a row's left margin until your cursor becomes a 4-way arrow 
.Drag and drop the row to move it to a new location.
Keyboard shortcuts
In New Sheets, you can use keyboard shortcuts to navigate, select cells, and more. New Sheets has some new keyboard shortcuts in addition to the ones previously available in Standard Sheets.
Action | Keyboard shortcut (New Sheets) |
Move one cell down, up, left, or right |
|
Extend the selection of cells by one cell |
|
Extend the selection of cells to the end of this column or row |
|
Clear the selected cells |
|
Windows: Arrow key
Mac: Arrow key
Drag-to-fill
Drag a cell value down to populate the cells underneath it with the same value.
Click a cell and hover your cursor over the bottom-right corner until you see a ➕ icon.
Click and hold while dragging your cursor down to the row you want to fill up to.
Bulk copy-paste
Copy multiple cells to your clipboard and paste them into other cells.
Click a cell and hold while dragging your cursor to select a group of cells. Press Ctrl + C to copy to your clipboard.
Click a blank cell to paste data into. Press Ctrl + V to paste.
Use Ctrl + Z to undo a bulk paste.
Set row height
Rows are sized automatically by default. To set a custom row height:
Hover your cursor over the bottom of a row's left margin until you see an arrow icon
.Click and hold while dragging your cursor to the desired height.
To set a row back to the default height:
Hover your cursor over the bottom of a row's left margin until you see an arrow icon
.Double-click.
Pin columns
Pin (AKA freeze), show/hide, reorder, and remove columns all in one central place.
To pin a column:
Right-click on the column header and click Pin column. If a column is already pinned, you can unpin it here.
Use the Manage Columns menu to drag to pin or unpin multiple columns at once.
Add a column aggregation
Add an aggregation to a column to calculate a sum, count, average, or another calculation.
To add an aggregation:
Open the 3-dots menu on the column header and click Edit Column.
Turn on the Aggregate totals toggle and select an aggregation type from the dropdown menu.
The aggregation will be displayed at the bottom of each section header.
Sample sheets
New Sheets now supports sample sheets. See below for more information on how to use sampling feature in New Sheets.
Rename or delete a sample by clicking on the sample name.
Replace a sample by clicking the
button, where you can choose to manually select or randomly reselect a sample.
Link a request by clicking the
button.
Cell and row highlights
You can use highlights to color a row or cell on your sheet to convey status or mark an area to return to.
Add a highlight
Highlight a Cell: Right-click on a cell and choose a color. Bulk selection is also supported via right-click:
Highlight a Row: Use the three-dot menu in the row action menu:
Remove a highlight
Highlighted cells and rows can be removed by selecting the white fill color. This can be done individually or via bulk selection.
Column filters
New Sheets includes the ability to filter columns on multiple values. You can:
Apply Excel-like multi-attribute filters with AND/OR logic.
Use familiar text filters from our standard sheets experience (contains, not contains, etc.).
Filter by list values for even more flexibility.
Use the new Filter Overview button to view all active filters across the sheet, see saved and unsaved filters, clear filters in one place, and filter by unique rows.
Shared columns
When a sheet is sharing columns to another sheet, you can see which other row(s) are linked to a row by opening the linked rows menu 
next to the row key.
Supported features
Some features aren’t yet available in New Sheets. Toggle off New Sheets to access these features in Standard Sheets mode.
Share your feedback
We'd love to hear your thoughts! Submit your feedback about New Sheets in our feedback portal.