Excell

[Jan W. de-Kulik]

I cannot believe it myself, but I have forgotten how to insert a line under
the headings, so that the date bellow will roll under it.

Can anyone please remind me.

Thank you.

 

[Jan W. de-Kulik]

Sorry, it should read "data" not date

 

[Edward]

Hi, Jan.

A bit like you, I too cannot think how you forgot - if we are on the ame
wavelength, that is.

Highlight the heading and on the tool bar, hit underline. The 'U' with a
line under it!

Good luck,

Ed

 

[Jan W. de-Kulik]

Hi Ed,

Thanks for the try, but this is not what I want. I want a constant line
under all the headings from col.1 to say 12, so that the data under these
columns will roll under it giving me more working cells at the bottom of the
sheet, without loosing my data at the top, which can be recalled by rolling
it down.

 

[Edward]

Hi, Jan.

How about thickening the cell grid line at the bottom only. Highlight the
row of cells 1-12 (just a little confused as columns are A,B,C etc) and just
select a thicker line either from Format/Cells/Borders or the tool bar
button.

If it is rows 1-12, highlight the first cell (Row 1) add a thick grid line
for the bottom, highlight the cell and with the little square at the bottom
right corner, drag to the last cell you want. (Row 12)

These lines, of course, will not effect any of the data.

If I'm still not understanding, try sending me an example.

Best wishes,

Ed

 

[Chip Pearson]

Jan,

Select, for example, cell A2 and choose Freeze Panes from the
Window menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[mrtee]

Chip, it is amazing how many people don't know this. I first learned it when using the spreadsheet program for a TI 99-4a in the 80's. I work in housekeeping at a hospital and see many people working in Excel that keep scrolling to see what the column header is that they are working in. When I show them "freeze panes" they are dumbfounded, no one taught them that in training class!

--
Just my 2¢ worth
Jeff
__________in response to__________
| Jan,
|
| Select, for example, cell A2 and choose Freeze Panes from the
| Window menu.
|
|
| --
| Cordially,
| Chip Pearson
| Microsoft MVP - Excel
| Pearson Software Consulting, LLC
| www.cpearson.com

 

[Jan W. de-Kulik]

I am really very grateful to you for the reply to my question, which I
hasten to say will never be asked again, since I now have the note for this
on my PC.

Regards,

Jan

 

[Edward]

Perhaps you can teach me, Jeff. I run Office 97 and can't find it.

Ed


Chip, it is amazing how many people don't know this. I first learned it
when using the spreadsheet program for a TI 99-4a in the 80's. I work in
housekeeping at a hospital and see many people working in Excel that keep
scrolling to see what the column header is that they are working in. When I
show them "freeze panes" they are dumbfounded, no one taught them that in
training class!

--
Just my 2¢ worth
Jeff
__________in response to__________
| Jan,
|
| Select, for example, cell A2 and choose Freeze Panes from the
| Window menu.
|
|
| --
| Cordially,
| Chip Pearson
| Microsoft MVP - Excel
| Pearson Software Consulting, LLC
| www.cpearson.com

 

[mrtee]

Just as Chip wrote. On the toolbar in Excel click "Window" click "Freeze Pane". If you only want the top row to remain fixed have cell A2 open, to fix the left column have B1 open, to freeze top and left have B2 open.

--
Just my 2¢ worth
Jeff
__________in response to__________
| Perhaps you can teach me, Jeff. I run Office 97 and can't find it.
|
| Ed