Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default setting row heights in excel

Anyone!

I have inserted images into my excel spreadsheet. Every time I do a
sort, Excel changes the row height and as a result my images get
squashed and therefore distorted. I want to lock or secure the height
of my rows so that I don't manually have to resize each row each time
I sort.

Any advice?

Thanks much.
RTW

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 40
Default setting row heights in excel

You need to align the objects (your pictures in this case) to grid
first.

To do this, on the Drawing click Draw, and then point to Snap.
To automatically align objects with the cell grid when you move or
draw them, click To Grid.

A quick way to snap the object to the cell grid is by holding down ALT
while you move, draw, or resize a drawing object.

AQIB RIZVI

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
How do I display heights (6' 2") in Excel columns? Chopdawg Excel Discussion (Misc queries) 1 September 10th 06 04:27 PM
Excel: copy grid, widths & heights down page: heights wrong! why? K Excel Discussion (Misc queries) 1 June 24th 06 03:06 AM
Excel 2000 row heights change between computers Steve Excel Discussion (Misc queries) 2 March 20th 06 04:10 PM
copy formats column width & row heights between Excel WORKSHEETS? tccc1219 Excel Discussion (Misc queries) 5 November 8th 05 04:22 PM
Excel will not auto format all row heights Sebastian Excel Discussion (Misc queries) 3 February 4th 05 10:09 PM


All times are GMT +1. The time now is 01:49 PM.

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"