Windows Phone 8 : Microsoft Office Mobile - Excel (part 5) - Freezing a Pane, Applying Formatting Options

11/20/2014 3:35:06 AM

Freezing a Pane

Freezing a pane enables you to keep a range of cells onscreen while you scroll the rest of the cells. For example, you might want to keep the spreadsheet’s header rows onscreen while you view data farther down the spreadsheet. You can freeze a portion of the spreadsheet by following these steps:

1. Tap and hold a cell in the column that you want to freeze.

2. Tap Freeze Pane.


3. The thicker line on the Excel grid indicates which column is frozen.


Unfreezing Cells

When you decide to unfreeze the cells, you can do so by tapping and holding a cell above the freeze line and then tapping the Unfreeze Pane option.

Applying Formatting Options

Excel Mobile enables you to apply text effects to cells within your spreadsheet. To modify the text style, follow these steps:

1. Select the cells to which you want to apply a text effect.

2. Tap the Menu icon.

3. Tap Format.


4. To apply standard formatting such as Bold, Italic, or Underline, tap the applicable button.

5. To format a number as a calendar date or time, tap the Date button.

6. To format a number as a form of currency, tap the Currency button.

7. To format a number as a percentage, tap the Percent button.

8. Tap a color in the Font Color group to change the color of the cell’s text.

9. To change the background color of a cell, tap a color in the Fill Color group.


Formatting Ranges

When formatting, you can select a range of cells to which you want to apply these formatting options.

PS4 game trailer XBox One game trailer
WiiU game trailer 3ds game trailer
Top 10 Video Game
-   World of Warships [PC] Open Beta Trailer
-   F1 2015 | Features Trailer
-   Battle Fantasia Revised Edition | Debut Trailer for Steam
-   Victor Vran [PC] Story Trailer
-   Star Wars Battlefront PC Alpha footage
-   Skyforge [PC] Open Beta Gameplay Trailer
-   Armored Warfare [PC] PvE Trailer
-   F1 2015 [PS4/XOne/PC] Features Trailer
-   Act of Aggression [PC] Pre-Order Trailer
-   Sword Coast Legends [PC] Campaign Creation E3 2015 Trailer
-   Sword Coast Legends [PC] Campaign Creation E3 2015 Dungeon Run Trailer
-   Naruto Shippuden: Ultimate Ninja Storm 4 Trailer
-   Danganronpa Another Episode: Ultra Despair Girls Trailer 2
-   Project X Zone 2 Trailer
-   Poly Bridge Early Access Trailer
Game of War | Kate Upton Commercial