Excel help

J

jbneedanswer

Is it possible to simultaneously freeze two or more separate columns, rows,
etc.?
 
S

smartin

jbneedanswer said:
Is it possible to simultaneously freeze two or more separate columns, rows,
etc.?
Click to expand...

Place the cursor in the cell below and to the right of the rows/columns
you want to freeze and select Window | Freeze Panes.
 
S

Sheeloo

You can not freeze separate columns (or rows).

Only adjacent columns (and/or rows) can be frozen.
 
S

Sheeloo

You can split Windows and open the same file in both windows to simulate the
effect you want
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Format column widths from one table to a separate table on same page 1
Autonumber field in Excel that behaves the same as Access 0
locking multiple rows in excel 03 2
Merging from an Excel file with graphics 1
Want to freeze 1st and last columns 3
Excel --> Word 4
Unable to freeze panes 15

Top