Home tab in Sheets

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.