Sheets
Spreadsheets and formulas.
Get started with SheetsOpen and create spreadsheets in Eigen, enter data in the grid, and let Sheets save your work automatically.Create and edit a spreadsheetCreate a new spreadsheet in Sheets, enter data, and use the menus and keyboard shortcuts to edit it.Find and replace textSearch the document you have open, step through the matches, and replace them one at a time or all at once.Enter and edit dataType into cells, edit their contents, and clear them in Sheets.Use formulas and functionsWrite formulas in cells, use built-in functions, and get help from the autocomplete and function browser.Set up data validationRestrict what can be entered in a cell by adding a dropdown list or a rule that checks the value before it is accepted.Add tick boxes to cellsTurn cells into tick boxes you can click, and read the TRUE or FALSE value each one holds.Format cells and numbersChange the appearance of cells in Sheets: text style, number format, alignment, borders, and more.Apply conditional formattingColor cells automatically based on their values by adding conditional formatting rules in Sheets.Insert, delete, and resize rows and columnsAdd, remove, and resize rows and columns in a Sheets spreadsheet.Freeze rows and columnsKeep header rows or columns visible while you scroll through a large spreadsheet.Work with multiple sheet tabsAdd, rename, reorder, and switch between sheet tabs to organize your spreadsheet into separate sections.Import an Excel fileBring an .xlsx spreadsheet into Eigen Sheets: add its sheets to a spreadsheet, replace a spreadsheet with it, or convert a file already in Drive.Share a spreadsheet and comment on cellsGive other people access to a spreadsheet in Sheets, control what they can do, and add comments to individual cells.Sort and filter dataReorder rows by the values in a column, or add filters to hide the rows you don't need.Split text into columnsSplit one column of text into several columns, using a separator such as a comma, a space, or a character you choose.Put a link in a cellLink a cell to a web page, to a range of cells, or to another sheet tab, then edit or remove that link.Add an image to a spreadsheetInsert a picture into a spreadsheet, move, resize and rotate it on the grid, and set its exact size in the image panel.Add a chart to a spreadsheetTurn a range of cells into a column, bar, line, or pie chart that updates when the cells change.Download a spreadsheetSave a copy of your spreadsheet to your computer as an Excel workbook, a PDF, or a web page.