Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
danlinksman
 
Posts: n/a
Default Copying cells downward on sheet

Is there a way to copy rows and colums down and keep the row height and width
the same?
  #2   Report Post  
 
Posts: n/a
Default

no, you can paste column widths but no row heights.
you can paste just about anything else but not row heights.

-----Original Message-----
Is there a way to copy rows and colums down and keep the

row height and width
the same?
.

  #3   Report Post  
Rob van Gelder
 
Posts: n/a
Default

If you want to retain the destination row / column size, select Paste
Special | Values from the Edit menu.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"danlinksman" wrote in message
...
Is there a way to copy rows and colums down and keep the row height and
width
the same?



  #4   Report Post  
RagDyer
 
Posts: n/a
Default

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!
==============================================

"danlinksman" wrote in message
...
Is there a way to copy rows and colums down and keep the row height and
width
the same?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM
Automatic copying of data cells DaleM Excel Discussion (Misc queries) 2 December 29th 04 08:07 PM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 08:43 AM
how can i select all the cells with same color on a sheet if there are multipale colors by vba code uobt Charts and Charting in Excel 1 December 15th 04 06:27 PM


All times are GMT +1. The time now is 08:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"