Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
mercyboocoo
 
Posts: n/a
Default help! how do i create a table with fixed headings??


I am trying to create a table with a fixed heading so I can keep a
record of all monthly phone bill statements while being able to see and
print out the most recent statements.

I've seen spreadsheets where when you scroll down, the column titles
are fixed and you can scroll up and down through the figures.

How do you format the spreadsheet to do this? HELP Please!!




--
mercyboocoo
------------------------------------------------------------------------
mercyboocoo's Profile: http://www.excelforum.com/member.php...o&userid=33961
View this thread: http://www.excelforum.com/showthread...hreadid=537351

  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default help! how do i create a table with fixed headings??


Select the row immediately below your table headings
<Window<Freeze panes

Is that what you're looking for?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=537351

  #3   Report Post  
Posted to microsoft.public.excel.misc
Elkar
 
Posts: n/a
Default help! how do i create a table with fixed headings??

Select the row below the one(s) you want to freeze. Then from the Window
Menu, select "Freeze Panes"

You can also Freeze columns, but selecting the column to the right of the
one(s) you want frozen. Or both, but secting the single cell that is below
and to the right.

HTH,
Elkar


"mercyboocoo" wrote:


I am trying to create a table with a fixed heading so I can keep a
record of all monthly phone bill statements while being able to see and
print out the most recent statements.

I've seen spreadsheets where when you scroll down, the column titles
are fixed and you can scroll up and down through the figures.

How do you format the spreadsheet to do this? HELP Please!!




--
mercyboocoo
------------------------------------------------------------------------
mercyboocoo's Profile: http://www.excelforum.com/member.php...o&userid=33961
View this thread: http://www.excelforum.com/showthread...hreadid=537351


  #4   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico
 
Posts: n/a
Default help! how do i create a table with fixed headings??

Try Window - Freeze panes. It will keep everything on the top and right of
the cell you had select freeze when you scroll.
In order to print the headers, in File - Page setup - Sheet, there is a
section to repeat rows on top, so they appear in all the printed pages.

"mercyboocoo" wrote:


I am trying to create a table with a fixed heading so I can keep a
record of all monthly phone bill statements while being able to see and
print out the most recent statements.

I've seen spreadsheets where when you scroll down, the column titles
are fixed and you can scroll up and down through the figures.

How do you format the spreadsheet to do this? HELP Please!!




--
mercyboocoo
------------------------------------------------------------------------
mercyboocoo's Profile: http://www.excelforum.com/member.php...o&userid=33961
View this thread: http://www.excelforum.com/showthread...hreadid=537351


  #5   Report Post  
Posted to microsoft.public.excel.misc
mercyboocoo
 
Posts: n/a
Default help! how do i create a table with fixed headings??


THANKS SO MUCH!!!

I knew it was simple. I just couldn't figure it out. :)


--
mercyboocoo
------------------------------------------------------------------------
mercyboocoo's Profile: http://www.excelforum.com/member.php...o&userid=33961
View this thread: http://www.excelforum.com/showthread...hreadid=537351

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do pivot table source fields automatically create tabs Datamonkey Excel Worksheet Functions 0 April 25th 06 06:52 PM
How Do I create a table in excel that shows frequency? petlesbian Charts and Charting in Excel 1 February 9th 06 06:14 PM
How do you create a complicated pivot table graph? Natalia Kozyura Charts and Charting in Excel 1 April 7th 05 02:52 AM
How do I create a pivot table if the pivot table icon or menu ite. Lynn@WS Charts and Charting in Excel 1 December 16th 04 03:36 AM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 10:39 PM


All times are GMT +1. The time now is 10:33 AM.

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

About Us

"It's about Microsoft Excel"