View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Scroll specific columns only

You don't say in which direction you want to scroll, so the answer to your
two questions might be No and Yes (in that order). If you are talking about
scrolling horizontally, you can freeze the first 4 columns so they don't
move while the other columns are scrolled into view, but you can only freeze
the first so many columns on the left. To do this, in Row 1, click on the
first column you want to allow to scroll (for your example, you would click
into cell E1), then click on Window/Split or Window/FreezePanes on Excel's
menu bar. Now when you scroll the columns, the first four columns will not
scroll.

--
Rick (MVP - Excel)


"Kashyap" wrote in message
...
Hi, is there a way to scroll specific columns only..?

may be scroll first 4 columns only?
or
scroll columns other than first 4?