Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how do I fix the position of a worksheet in excel?

I am developing a spreadsheet with multiple worksheets within in. The first
two worksheets are summary sheets and rather than keep scrolling back or
using the first sheet button, is it possible to fix the position of one of
the worksheets so that it is readily accessible and visible at all times?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default how do I fix the position of a worksheet in excel?

WindowNew Window.

WindowArrangeVertical works best for me.

Each window can have whatever sheet you wish to view.


Gord Dibben MS Excel MVP

On Fri, 15 Dec 2006 03:55:01 -0800, MartyMac
wrote:

I am developing a spreadsheet with multiple worksheets within in. The first
two worksheets are summary sheets and rather than keep scrolling back or
using the first sheet button, is it possible to fix the position of one of
the worksheets so that it is readily accessible and visible at all times?


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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Prevent changing size when copy&paste into another Excel Worksheet Michelle Excel Worksheet Functions 0 June 26th 06 04:30 PM
how do i save a large amount of data in a worksheet excel 4 Rana Excel Worksheet Functions 1 June 13th 06 10:54 AM
Excel worksheet linking Shiren Excel Worksheet Functions 0 July 6th 05 05:33 PM
Change position of move or copy worksheet option in Excel JesseAviles Excel Discussion (Misc queries) 1 February 22nd 05 10:25 PM


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