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?

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?

I know I can freeze columns and rows across the top but, for this spreadsheet
M-P looks better on the right side. I do have the zoom on 75% and works
fine. Again, I would like to just freeze M1 through P17.


"JLatham" wrote:

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?

Another option is the Worksheet Watch Window.
Select your Cells M1:P1

In Excel 2007, go to the Formula Tab, and under "Formula Auditing", select
"Watch Window."
Click "Add Watch..." and add the selection.

--
HTH
Dana DeLouis



"twb111" wrote in message
...
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?

I'll have to check that out - that's a feature I haven't used in such a
fashion. Sounds like a good idea.

"Dana DeLouis" wrote:

Another option is the Worksheet Watch Window.
Select your Cells M1:P1

In Excel 2007, go to the Formula Tab, and under "Formula Auditing", select
"Watch Window."
Click "Add Watch..." and add the selection.

--
HTH
Dana DeLouis



"twb111" wrote in message
...
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?

I'll second that.

Same in Excel 2003 under ToolsFormula AuditingShow Watch WindowAdd Watch


Gord

On Sun, 2 Mar 2008 14:49:01 -0800, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

I'll have to check that out - that's a feature I haven't used in such a
fashion. Sounds like a good idea.

"Dana DeLouis" wrote:

Another option is the Worksheet Watch Window.
Select your Cells M1:P1

In Excel 2007, go to the Formula Tab, and under "Formula Auditing", select
"Watch Window."
Click "Add Watch..." and add the selection.

--
HTH
Dana DeLouis



"twb111" wrote in message
...
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?

Interesting approach! Im using Excel 2003 which also has the watch window.
The problem in €˜03 is the watch window list each cell on a different row and
that makes it harder to read.

"Dana DeLouis" wrote:

Another option is the Worksheet Watch Window.
Select your Cells M1:P1

In Excel 2007, go to the Formula Tab, and under "Formula Auditing", select
"Watch Window."
Click "Add Watch..." and add the selection.

--
HTH
Dana DeLouis



"twb111" wrote in message
...
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?

Another possibility is to use a linked picture. Copy the range M1:P17, then
while holding down SHIFT, click Edit Paste Picture Link. That'll give you
a picture of the reference range which you could format/resize to suit, then
locate it within say, a frozen top left corner on the sheet.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

"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?

Another option if reference info is static,
is to use the input msg feature of data validation

Eg select entire cols A-L,
then click Data Validation Input Message tab

Copy/paste/enter the details in M1:P1
for the title/msg such as:

Title, eg: References
Input Message, eg:
M1: xxx
N1: zzz
O1: vvv
P1: bbb

Click OK

The "floater reference info" will appear
when any cell in cols A-L is selected
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Another possibility is to click Window/Split on Excel's menu bar and then
drag the split-bars and scroll the right-hand panes so that M1:P1 are
showing in the top-right pane. Click back in the bottom-left pane and do all
your work there.

Rick


"twb111" wrote in message
...
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?

To keep or float the reference codes in columns M1 through P1 always in view on the right side of the spreadsheet, you can use the

1. Select the cell in column Q1, which is the first cell to the right of the reference codes.
2. Click on the View tab in the ribbon at the top of the Excel window.
3. In the Window group, click on the Freeze Panes dropdown menu.
4. Select the option "Freeze Panes" from the dropdown menu.
5. You should now see a horizontal line appear just above row 1 and a vertical line appear just to the left of column Q. This indicates that the rows above and columns to the left of the selected cell are frozen.
6. Scroll down and to the right to confirm that the reference codes in columns M1 through P1 are now always in view on the right side of the spreadsheet.

That's it! Now you can work with your large spreadsheet and always have the reference codes in view on the right side.