#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Locking Cells

I'm trying to keep the first several rows from re-sizing when I size the rows
below. Does anyone know how to do that? Thanks.
--
RT
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 563
Default Locking Cells

You can adjust the height of each row individually by right clicking the row
header (the number on the far left) and selecting Row High.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"RTaylor" wrote in message
...
I'm trying to keep the first several rows from re-sizing when I size the
rows
below. Does anyone know how to do that? Thanks.
--
RT


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 563
Default Locking Cells

Or did you mean you want to freeze the top few rows when you scroll the rest
of the worksheet?
Windows | Freeze in pre-2007 versions of Excel and View Freeze in XL2007+
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"RTaylor" wrote in message
...
I'm trying to keep the first several rows from re-sizing when I size the
rows
below. Does anyone know how to do that? Thanks.
--
RT


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
Locking certain cells Beverly Darvill[_2_] Excel Discussion (Misc queries) 3 June 11th 08 05:10 PM
locking formula in cells in without locking whole sheet SuziQ Excel Discussion (Misc queries) 1 July 21st 06 03:58 PM
Locking certain cells Scott Excel Discussion (Misc queries) 1 September 20th 05 03:26 PM
Locking Cells rob8278 Excel Worksheet Functions 0 May 12th 05 07:56 PM
Help on locking cells B Excel Discussion (Misc queries) 1 January 28th 05 04:17 AM


All times are GMT +1. The time now is 03:20 AM.

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

About Us

"It's about Microsoft Excel"