| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
change excel row height without showing hidden rows
I have a large Excel worksheet with numerous hidden rows. When I try to
change the height of all rows in the spreadsheet the hidden ones reappear. Can this be avoided? Is there a way to delete these rows without having to highlight each one? |
|
#2
|
|||
|
|||
|
LL,
Select all your rows, use Edit | Go To Special Visible Cells only, then change the height of your rows. HTH, Bernie MS Excel MVP "LL" wrote in message ... I have a large Excel worksheet with numerous hidden rows. When I try to change the height of all rows in the spreadsheet the hidden ones reappear. Can this be avoided? Is there a way to delete these rows without having to highlight each one? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| set row height upon opening excel | Excel Discussion (Misc queries) | |||
| EXCEL Workbook tab format options: change color or font | Excel Discussion (Misc queries) | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| Change height of row | Excel Discussion (Misc queries) | |||
Hybrid Mode
