Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default lock column size for some rows and resize for other rows.

I am trying to present an analysis that I want to lock the column size for
several rows. Below the analysis, I want to present another analysis that has
different column sizes. Is it possible to lock the column size for the one
presentation and then resize them for the other without changing the original
presentation.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default lock column size for some rows and resize for other rows.

Column widths and row heights are the properties of the entire column and row.

So....short answer is no.

Long answer is take a picture of one of the presentations then paste below or
above the other presentation after formatting column widths of that "other"
presentation.


Gord Dibben MS Excel MVP


On Tue, 20 Nov 2007 14:09:01 -0800, Gorskim
wrote:

I am trying to present an analysis that I want to lock the column size for
several rows. Below the analysis, I want to present another analysis that has
different column sizes. Is it possible to lock the column size for the one
presentation and then resize them for the other without changing the original
presentation.


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
printing issue - want to repeat two rows and also 5 rows in column cliffykat Excel Discussion (Misc queries) 0 August 29th 07 10:36 PM
after selecting 50 rows of a column i can't reference the cells in the rows Bob Salzer New Users to Excel 2 July 21st 06 10:29 PM
How do I resize a worksheet after deleting rows? Jay Jay Excel Discussion (Misc queries) 2 July 25th 05 09:31 PM
What is the trick to make rows resize height automatically? Gumby Excel Discussion (Misc queries) 3 July 13th 05 07:12 PM
How can I resize columns and rows to inches? Max Gough Excel Discussion (Misc queries) 4 June 30th 05 11:44 PM


All times are GMT +1. The time now is 02:12 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"