Computer Online Tips
System Security TipsSet Home PageAdd to
Favorites|
|
||||
|
System Security Tips |
Set Home Page |
Add to
Favorites |
||
|
|
Categories
System
Performance TipsComputer
TroubleshootingComputer
Security TipsMS
Office TipsInternet
TroubleshootingSystem
Backup TipsWindows
TricksWindow Registry
Tips
How to use Shrinking and Wrapping features in Excel?
Excel also has feature to fit data in cells by shrinking the data. The data of cell or range of cells is fitted within its column width by reducing its font size. The font size of data of these cells is automatically increased or reduced when column width is changed.
Perform the following steps to shrink data into cells:
First select a cell or range of cells.
You can press shortcut key Ctrl+1 and "Format cells" dialog box will appear.
Select "Shrink to fit" check box. Click ok button to save these setting.
Wrapping data in Cells
Wrapping means, storing data within the specified width of column in multiple lines in the form of paragraph. When "Wrap Text" feature of Excel is applied to a cell or cells, the text automatically shifts to new line in the same cell when the length of text exceeds the width of the column. The cell height increases to accommodate the paragraph or multiple lines.
Perform the following steps to apply wrap text:
First select the cell or range of cells.
Select "Cells" command from "Format" menu or simple use shortcut key Ctrl+1, a new dialog box will appear with the title "Format Cells".
Click on Alignment tab of that dialog box.
Select the "Wrap text" check box.
At the end click on Ok button to save the setting and close it.
How
to apply Conditional Formatting in MS. Excel?
A
formatting that is applied to a cell or multiple cells and activated
only if condition is met is called conditional formatting.
How
to present text in the form of columns?
The text
of word document can be arranged into multiple columns. The number of
columns that can be created in document depends upon the size of paper.
How to
insert a sound or music on a PowerPoint Slide?
MS- Power Point helps
to create and organize presentations very easily and quickly and
presentation is a systematic approach through which ideas are delivered
to others in a will-mannered way.
How to manage the Paragraph and line Spacing? The white spacing before and after the paragraph are called paragraph spacing. Similarly, the white space between adjacent lines is called line spacing.
How to use Shrinking and Wrapping features in Excel? Excel also has feature to fit data in cells by shrinking the data. The data of cell or range of cells is fitted within its column width by reducing its font size.
Subscribe
To Our Weekly Newsletters
Bookmark this page
Email
this to your friend 
|
Home | Disclaimer | Link
to Us | Contact
Us Copyright 2007 www.ComputerOnlineTips.com All rights reserved. |