Loading
Excel.Tips.Net ExcelTips (Menu Interface)

Row Formatting

Rows are central to your worksheet in Excel and as such, can be formatted as a unit to change how they are displayed. Use the following articles about Excel's row formatting capabilities to make your columns appear just right.

Tips, Tricks, and Answers

The following articles are available for the 'Row Formatting' topic. Click the article's title (shown in bold) to see the associated article.

Adjusting Row Height for a Number of Worksheets
Adjusting the height of a row or range of rows is relatively easy in Excel. How do you adjust the height of those same rows on a number of different worksheets? Here's how!

Automatic Row Height For Merged Cells with Text Wrap
When you have text wrap turned on in a cell, Excel expands the height of the row as you add more text to the cell. When you merge two cells that have text wrap turned on, Excel won't adjust the row height to accommodate the text in the cell. This can, of course, cause problems. How you deal with this situation is described in this tip.

Automatic Row Height for Wrapped Text
When you format a cell so that the information within it can wrap to multiple lines, you may be surprised if Excel doesn't adjust the row height to display all those lines. Here's why this can happen and what you can do about it.

Detecting Hidden Rows
Excel allows you to easily hide rows in a worksheet, so their contents are not visible. Figuring out how to detect where those hidden rows can be a very manual process—unless you use some of the ideas in this tip.

Hiding and Unhiding Rows
When building a worksheet, you may need to hide some of the rows or unhide other, previously hidden, rows. It's easy to do; here's how.

Hiding Rows Based on Two Values
It's easy to use filtering to hide rows based on the value in a cell, but how do you hide rows based on the values in two cells? Here are a couple of ideas on how you can pare down your data.

Setting Row Height
When you enter information into a row on a worksheet, Excel automatically adjusts the height of the row based on what you enter. If you want to override the height that Excel chooses, apply one of the techniques described in this tip.

 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.