#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VegasBurger
 
Posts: n/a
Default Format Question

Currently, I am working on a spredsheet to help track business accounts for
my business. Across the top 4 rows, I have columns where people can input the
information regarding the accounts. Anyways, is there a way to have those 4
top rows stay when someone scrolls down the list so it is easier to see the
data for each row 5 and down...?

Thanks!

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Format Question

If you want to freeze the top 4 rows from column A, select A5, then click
window in the menubar and select freeze panes

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"VegasBurger" wrote in message
...
Currently, I am working on a spredsheet to help track business accounts
for
my business. Across the top 4 rows, I have columns where people can input
the
information regarding the accounts. Anyways, is there a way to have those
4
top rows stay when someone scrolls down the list so it is easier to see
the
data for each row 5 and down...?

Thanks!



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom
 
Posts: n/a
Default Format Question

Vegas,
Highlight row 2 on the sheet, then go to WINDOW FREEZE PANES
That will keep row 1 visible when the user scrolls down the sheet.

Regards,
Tom

"VegasBurger" wrote:

Currently, I am working on a spredsheet to help track business accounts for
my business. Across the top 4 rows, I have columns where people can input the
information regarding the accounts. Anyways, is there a way to have those 4
top rows stay when someone scrolls down the list so it is easier to see the
data for each row 5 and down...?

Thanks!

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
Date Format question Aaron Excel Discussion (Misc queries) 3 April 5th 06 01:51 PM
Date format Question Fable Excel Discussion (Misc queries) 1 December 1st 05 01:18 PM
Conditional format question [email protected] Excel Discussion (Misc queries) 7 September 16th 05 04:15 PM
Simple Format Question Ket Excel Worksheet Functions 1 March 2nd 05 04:10 PM
Date Format Question Josh O. Excel Discussion (Misc queries) 1 February 10th 05 09:45 PM


All times are GMT +1. The time now is 03:58 AM.

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

About Us

"It's about Microsoft Excel"