Home tab in Sheets

• Home tab in Sheets Android
• Home tab in Sheets iOS

Home tab in Sheets Android

The Home tab is where you'll find the standard range of tools for adjusting font sizes, colors, and styles; formatting options for individual cells and cell ranges; as well as sum, filter, and sort settings.

Paste – Place cut or copied elements in your document. For further choice on what to paste and what not to you have the following options:

	Keep Formatting – Keep any formatting present on the copied or cut content.
	Text Only – Pastes only text with no formatting.

	Cut – Cut elements from one location, and move them to another via paste.
	Copy – Copy elements from one location to another via paste.
	Format Painter – Copies the formatting and style of the selected text.
Arial	Font Families – Opens the font menu, which lists your available OfficeSuite fonts in their relevant style.
11 pt	Font Size – Adjusts font size from a predefined value.
	Font Color – Specify the text color.
	Bold – Embolden text.
	Italics – Italicize text.
	Underline – Underline text.
	Strikethrough – Add a strikethrough effect to text.
	Cell Border – Provides options for specifying cell borders on cells or cell ranges.
	Highlight Color – Specify the highlight color.
	Align Top – Aligns cell text against the top border.
	Align Middle – Aligns cell text between the top and bottom borders.
	Align Bottom – Aligns cell text against the bottom border.
	Align Left – Aligns text against the left border.
	Align Center – Centers text between both borders.
	Align Right – Aligns text against the right border.
	Wrap Text – Allows text to be wrapped within a cell so that it does not get obscured by the cell boundaries.
	Merge Cells – Groups the contents of multiple cells together, creating a single cell in their place. Note that only the upper-leftmost cell data will be retained.
	Currency – Marks the entered numerical value as currency, in dollars.
	Percentage – Marks the entered numerical value as a percentage.
	Auto Sum – Performs quick calculations of the numbers in a selected cell range and displays the result. Using this with only one cell selected will allow you to enter cell ranges manually.
	Insert – Used to insert either Rows above the currently selected range or a Column left of it.
	Delete – Deletes the selected rows or columns of the spreadsheet, or the currently active sheet.
	Cells – Provides options to place additional cells. Two options are available, Insert empty cells and shift right and Insert empty cells and shift down.
	Find & Replace – Searches for instances of text entered in the Search field, and will replace them with text entered in the Replace field:
	Case sensitive – Will search for exact cases such as capitalized or all lowercase letters. Match entire cell – Will filter out results that have the searched text as a part of a larger cell entry. Search in results of formulas – Will search either through cell values or cell formulas.

Home tab in Sheets iOS

The Home tab is where you'll find the standard range of tools for adjusting font sizes, colors, and styles; formatting options for individual cells and cell ranges; as well as sum, filter, and sort settings.

Arial	Font Families – Opens the font menu, which lists your available OfficeSuite fonts in their relevant style.
12	Font Size – Adjusts font size, in pixels. Can be incremented by using the - and + buttons, or to a predefined value by tapping on the number.
	Bold – Embolden text.
	Italics – Italicize text.
	Underline – Underline text.
	Double Underline – Underlines text with two lines.
	Strikethrough – Add a strikethrough effect to text.
	Align Left – Aligns text against the left margin.
	Align Center – Centers text between both margins.
	Align Right – Aligns text against the right margin.
	Align Top – Aligns cell text against the top border.
	Align Middle – Aligns cell text between the top and bottom borders.
	Align Bottom – Aligns cell text against the bottom border.
	Font Color – Specify the text color.
	Highlight Color – Specify the highlight color.
	Paste – Place cut or copied elements in your document.
	Cut – Cut elements from one location, and move them to another via paste.
	Copy – Copy elements from one location to another via paste.
	Format Painter – Copy the formatting from one text selection to another.
	Wrap Text – Allows text to be wrapped within a cell, so that it does not get obscured by the cell boundaries.
	Merge and Center – Groups the contents of multiple cells together, creating a single cell in their place. Note that only the upper-leftmost cell data will be retained.
	Currency – Marks the entered numerical value as currency, in dollars.
	Percentage – Marks the entered numerical value as a percentage.
	Auto Sum – Performs quick calculations of the numbers in a selected cell range and displays the result:
	Sum – Adds up the numbers in the cell range. Average – Displays the average value of the numbers in the cell range. Count – Counts the number of cells in the range that contain numbers. Max – Displays the largest value of the numbers in the cell range. Min – Displays the smallest value of the numbers in the cell range. Median – Displays the middle number of the numbers in the cell range.
	Insert – Gives you the option to insert cells, rows, columns and worksheets.
	Delete – Deletes the selected rows or columns of the spreadsheet, or the currently active sheet.
	Go to – Useful for large spreadsheets, this field allows you to go directly to a specific cell by entering in its coordinates (RowNumber:ColumnLetter).