Tuesday, June 28, 2011

How to Copy Paste Row Height in Excel 2007


1. Open an Excel spreadsheet with data.
2. Hover your mouse on the line between two row numbers until you see two black arrows facing in opposite directions appear. Click and drag up or down to adjust the row height.
3. Hover your mouse over the row number you just adjusted until the black arrow pointing to the right appears. Click that row to highlight it.
4. Click the 'Home' tab, and then click the little paintbrush icon in the Clipboard group. Your highlighted row should now have a moving, dashed line around it.
5. Click on a row number to paste the row height.

Blogger news