Copying cells downward on sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to copy rows and colums down and keep the row height and width
the same?
 
no, you can paste column widths but no row heights.
you can paste just about anything else but not row heights.
 
If you want to retain the destination row / column size, select Paste
Special | Values from the Edit menu.
 
To copy the row formats (height) with the data, you must select the *entire*
row(s) by clicking in the row number labels, *not* just the cells
themselves.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is there a way to copy rows and colums down and keep the row height and
width
the same?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying everything 4
copy worksheet 2
rows & columns height & width 1
Excel Help to copy information from one row at a time to another sheet 1
need to dbl row height without changing height of cell next to it 1
making a cell resize itself to accommodate data 1
formatting all worksheets in a workbook identical 5
Row height AutoFit help 1

Back
Top