Home tab in Sheets

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).

Was this article helpful?

0 out of 0 found this helpful