ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I copy row height like i copy column width? (https://www.excelbanter.com/excel-discussion-misc-queries/226508-can-i-copy-row-height-like-i-copy-column-width.html)

Markman

Can I copy row height like i copy column width?
 
I would like to copy my row height from the first 50 rows to the next 50 rows
and so on in the same work sheet. This would save alot of time. Thanks

Sheeloo[_5_]

Can I copy row height like i copy column width?
 
Select the source row, press CTRL-C

Select the target range, right-click-Paste Special-Formats...
this will copy ALL the formatting of source to destination...

If you just want to change height then choose Format-Columns and enter the
height desired.


"Markman" wrote:

I would like to copy my row height from the first 50 rows to the next 50 rows
and so on in the same work sheet. This would save alot of time. Thanks



All times are GMT +1. The time now is 01:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com