Excel Basics Calculations Special Features
Format Cells Sum, Average, Countif Functions Charts (Graphs)
Worksheets Quick Functions Sort Data
Edit Cells The IF Statement Filter Data
Rows and Columns VLOOKUP Function Conditional Formatting
Find and Replace Excel Formulas Pivot Table
The Fill Handle First Aid
Excel Training
Microsoft Word Training
About
Ask your question here
Guestbook
Excel Course CD

Working with Rows and Columns

Adjusting column width
Adjusting rows height
Adding new rows
Deleting rows
Freeze panes -
       Freezing rows and columns

The spreadsheet is a huge table, consisting of numerous rows and columns, which can be easily manipulated.

You can add or delete rows and columns, one by one, or many simultaneously.
The columns width, as well as the rows height can be adjusted carefully, to fit best your data.

Freezing panes comes to aid you when you scroll a big table, and the headers (titles) row and column have gone outside of the screen, making the table's data incomprehensible. Freezing them on the screen will keep them visible despite the scrolling.



Website Statistics