Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 26
Default freezing rows and columns

how do i freeze rows and columns at the same time
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default freezing rows and columns

Suppose you want the top row and column A frozen - you put your cursor
in B2 and then click on Window | Freeze Panes.

So, position cursor one row below and one column to the right of the
areas that you want frozen.

Hope this helps.

Pete

On Apr 28, 10:08*am, duckie wrote:
how do i freeze rows and columns at the same time


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
Macro for removing specific rows and columns, freezing panes..? [email protected] Excel Worksheet Functions 3 April 6th 08 11:51 PM
Macro for removing columns/rows, freezing panes etc? [email protected] New Users to Excel 1 April 3rd 08 12:36 PM
Freezing multiple rows/columns in Excel 2007 Pro gary Excel Worksheet Functions 3 May 2nd 07 07:17 AM
Freezing rows and columns Michael Excel Worksheet Functions 2 August 12th 05 04:02 AM
Freezing rows & columns Michael Excel Worksheet Functions 1 August 12th 05 04:00 AM


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