LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,365
Default Float a group of cells so they are always in view

Easiest way would be to move contents of M through P into A through D, then
you could Freeze the Window and always keep them in sight. With them out at
the right edge of things, it's going to be very difficult to do unless you
have a really wide screen and a fairly high resolution setting.

Another option is to reduce the Zoom value on your screen so that M:P are
pulled into view on the right side, but that may make seeing what's on the
sheet difficult, depending on your eyesight and layout/content of the sheet
itself.

"twb111" wrote:

Large spreadsheet with data in columns A-L. Reference codes in columns M1
through P1. How can I keep or float the reference codes so they are always
in view on the right side of the spreadsheet?

 
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
Copy Data from One Group of Cells to Another Group Alan Auerbach Charts and Charting in Excel 2 May 27th 07 04:12 PM
from a group of cells.find average of cells containing values farm Excel Discussion (Misc queries) 1 December 21st 06 08:50 PM
view group and outline with protection on derwood Excel Discussion (Misc queries) 1 February 27th 06 02:01 AM
How do I float cells so others scroll under it? Keith Excel Discussion (Misc queries) 1 July 9th 05 10:09 PM
copy group of cells to another group of cells using "IF" in third Chuckak Excel Worksheet Functions 2 November 10th 04 06:04 PM


All times are GMT +1. The time now is 04:11 PM.

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"