A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Keep my A column visible



 
 
Thread Tools Display Modes
  #1  
Old June 30th, 2004, 12:12 PM
webbynet
external usenet poster
 
Posts: n/a
Default Keep my A column visible

Hi,

I am trying to keep the A column visible while i scroll right through
the columns. I need to be able to see column A. I have tried freeze but
having some difficulties getting it to work properly.

Thanks

Craig


---
Message posted from http://www.ExcelForum.com/

  #2  
Old June 30th, 2004, 01:09 PM
BrianB
external usenet poster
 
Posts: n/a
Default Keep my A column visible

Click/Drag small bar bottom of screen (it is in line with sheet tabs far
right between scroll arrow and grey box).

Window/Freeze Panes.


---
Message posted from http://www.ExcelForum.com/

  #3  
Old June 30th, 2004, 01:46 PM
Lady Layla
external usenet poster
 
Posts: n/a
Default Keep my A column visible

Put your cursor in B1 and select the cell, go to Windows, Freeze panes


"webbynet " wrote in message
...
: Hi,
:
: I am trying to keep the A column visible while i scroll right through
: the columns. I need to be able to see column A. I have tried freeze but
: having some difficulties getting it to work properly.
:
: Thanks
:
: Craig
:
:
: ---
: Message posted from http://www.ExcelForum.com/
:


  #4  
Old June 30th, 2004, 05:49 PM
Gord Dibben
external usenet poster
 
Posts: n/a
Default Keep my A column visible

WindowFreeze Panes.

Rules are......everything above and left of the selected cell will be frozen.

B1 will freeze column A

B2 will freeze column A and row 1

Gord Dibben Excel MVP

On Wed, 30 Jun 2004 06:12:47 -0500, webbynet
wrote:

Hi,

I am trying to keep the A column visible while i scroll right through
the columns. I need to be able to see column A. I have tried freeze but
having some difficulties getting it to work properly.

Thanks

Craig


---
Message posted from http://www.ExcelForum.com/


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Page Break vs Column Break DreAndre Page Layout 8 June 23rd, 2004 02:02 PM
Display column 4 in combo box AfterUpdate Bradley C. Hammerstrom New Users 2 May 27th, 2004 06:29 PM
Increment column value based on insert string A.W.J. Ales Worksheet Functions 1 April 15th, 2004 02:44 PM
Sum column of numbers based on date in another column Kurt Worksheet Functions 1 March 19th, 2004 11:38 PM
"Matching" column A's values in column B Chris.F Worksheet Functions 0 January 12th, 2004 02:24 PM


All times are GMT +1. The time now is 01:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.