kemas

Junior Member

Posts: 1

Quote:

Originally Posted by texasdata

I need to freeze the first column and first row of a worksheet. It will only allow me to freeze one or the other as far as I can tell.

Is there any way to freeze both at the same time?

if u want to freeze row5 an column 2
select c6
and choose freeze from view tab in excel 2007

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Freezing column and sorting	BobW	Excel Discussion (Misc queries)	2	October 6th 08 05:33 PM
Freezing headers and first column?	flint	Excel Worksheet Functions	3	May 7th 07 11:36 AM
Freezing Date/Time after data entry.	Shadyhosta	New Users to Excel	2	January 31st 07 06:24 AM
Freezing column headings	csamms	Excel Worksheet Functions	2	September 12th 06 11:00 PM
how do I convert a date and time column to a time column	thdorsky2	Excel Worksheet Functions	1	March 4th 05 08:49 PM

All times are GMT +1. The time now is 05:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us