Knowledge Base/hopTo Personal /Excel

Using the Format Toolbar to Edit a Microsoft Excel Document

Shai Simchi
posted this on June 3, 2013, 10:20 AM

This article covers how to use the formatting toolbar when editing an Excel document with hopTo.

To edit a Microsoft Excel document using hopTo, please refer to following article: Editing a Microsoft Excel Document From the hopTo App.

Except for when editing the content of a specific cell, the formatting toolbar is available at the bottom of the screen whenever the Format tab is chosen on the menu bar. In the image below, you can see the toolbar that pops-up with buttons for the supported formatting functions.

 

IMG_0757_2.jpg

 

Selecting the Cell Range for Editing

You can use the toolbar to make changes to single cells, cell blocks, entire rows, or entire columns. To pick a single cell, simply tap the cell once. To designate a cell block, tap the single cell where you would like to start creating the block.

IMG_0757_3.jpg

 

Tap and hold one of the dots on the edges of the cell, drag it, and release to create the block.

IMG_0758.jpg

 

Tap a row number to select an entire row.

IMG_0759.jpg

 

Tap a column letter to select an entire column.

IMG_0760.jpg

 

Changing the Type of a Cell or Block of Cells

There are 3 available cell types:

  • Number
  • Text
  • Date and time

When you highlight a cell by tapping on it, the name in the cell type button on the toolbar shows the cell type. Tap the cell type button to change the data type.
To close the type picker and return to the normal toolbar view, tap the “X” on the right-hand side. You can do the same operation for a block of cells (see above how to select a block, row, or column). Note that when selecting a block of cells with mixed types, the type showing inside the type picker will not represent all cells.

IMG_0761.jpg

 

Changing the Font

The name the font button represents the current font. Tap the button, and the toolbar switches to the font picker. You can swipe right and left to see the available fonts, then tap the one you want. To close the font picker and return to the normal toolbar view, tap the “X” on the right-hand side.

IMG_0762.jpg

 

Bold/Underline/Italics

You can change a single cell or a block of cells to be bold, underlined, or italicized. The buttons become highlighted in white when selected.

 IMG_0763.jpg

 

Adjusting the Font Size

The number in the font size button shows the current font size. Tap the button, and a font size adjuster appears. Use the slider to adjust to your desired font size. To close the font size adjuster and return to the normal toolbar view, tap the “X” on the right-hand side.

IMG_0764.jpg

 

Selecting the Text Alignment

The text alignment indicator shows the current alignment. Tap the button and an alignment picker appears. To close the text alignment picker and return to the normal toolbar view, tap the “X” on the right-hand side.

IMG_0765.jpg

 

Selecting the Text Color

The text color option in the Format toolbar allows you to pick the color for the text in the designated cell range. Tap the button and the color palette will open with the available colors. Tap the color you want for your text - the selected color is surrounded by light blue. You can swipe the palette left and right to view more available colors.

IMG_0766.jpg

 

Selecting the cell Background Color

The cell background color option in the Format toolbar allows you to pick the background color for the selected cell or cell range. Tap the button and the color palette will open with the available colors. Tap the color you want to use - the selected color is surrounded by light blue. You can swipe the palette left and right to view more available colors.

IMG_0767.jpg

 

Comments latest first

User photo
Shai Simchi
hopTo Helpdesk

Hi Peyton,
You can do some of the things you mentioned but some are not yet supported:
merge cells: https://hopto.zendesk.com/support.hopto.com/support.hopto.com/entries/23847137-Merging-and-unmerging-ce...
For centering: See "Selecting the Text Alignment" above on this page
Borders are not yet supported.
Also, there is no current option to select all the cells in an entire spreadsheet.
If you wish to suggest ideas on improvement or new features you would like to see in hopTo please visit our feature request forum at:
http://support.hopto.com/forums/22006882-Feature-Requests

Hope this helps

Thanks,
Shai Simchi
hopTo Support

February 5, 2014, 4:54 PM
User photo
Peyton Rawls

I need to know how to continue formatting.  How do you Merge & Center?  How do you put a border around each cell?  How do you format the entire sheet style?  

February 5, 2014, 3:29 PM