programming4us
programming4us
MOBILE

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

- How To Install Windows Server 2012 On VirtualBox
- How To Bypass Torrent Connection Blocking By Your ISP
- How To Install Actual Facebook App On Kindle Fire
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.

Image
Image

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

Image

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.

Image

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.

Image

Formatting Ranges

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

Other  
 
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
REVIEW
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
programming4us programming4us
programming4us
 
 
programming4us