fix first and last column in excel

Microsoft Office excel 2007 home & stude...
May 15, 2010 at 12:24:01
Specs: Macintosh
I'm trying to make a chart to track the workouts of a
group of people over the course of the summer. I
want the first column and the last column to be fixed,
but i want all the columns in the middle to scroll. How
do I fix the last column (their total points) when I don't
know how many columns there will be between now
and the end of the summer? i only want 4 or 5
columns showing between their names and the total
column at the end.

See More: fix first and last column in excel

May 15, 2010 at 13:13:17
Directly from Microsoft Online Help...

"You cannot freeze rows and columns in the middle of the worksheet."

Why not freeze columns A & B for their Names and Points and scroll the rest of the worksheet for the other columns?

Maybe if you gave us some more details as to what you are trying to do with the columns in the middle, we could come up with some other ideas.

Report •

May 15, 2010 at 13:37:22
ok, thanks.

basically, i want the first column to be their names, then
each column is a different day and whatever exercise they
did. i wanted the last column on the right to be the total
number of points, but i guess i can just put the total column
next to their names instead.

is there a way to control how many columns scroll? i tried to
freeze the first column, and then when i scrolled, it kept the
first few frozen. i would like only the names and the total
points to be frozen, then the next scroll right away (so that
the most recent 5 or 6 dates will appear when they open the
file each week).

Report •

May 15, 2010 at 14:33:26
Highlight Column C and click Windows...Freeze panes.

When you scroll, A & B should remain frozen.

How many columns show after that would depend on how wide the columns were and how big the user's monitor is. Different sized monitors will show a different number of columns.

You can also hide columns so that they don't show.

Select the columns you want to Hide by dragging across the Column letter headings, then right-click and choose Hide.

If you want the users to only see a specific set of columns - based on the current date - then you either need to save it that way or use a macro to hide/display columns based on the current date.

Report •
Related Solutions

Ask Question