Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Creating smaller and larger cells on the same sheet

In Excel, it it possible on one sheet to have a row of cells on the upper
part of the sheet one size and the lower rows another width. I'm making a
template for out track team where I'm putting scores for each event at the
top of the page so I need smaller cells. At the bottom of the paige I'm
typing in athletes' names which means the cells need to be wider. it's almost
like I'm trying to two different formats onto one page. Any suggestions?
Thanks,
Matt P.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default Creating smaller and larger cells on the same sheet

Column Width is a function of the column, not cells, so all cells in a
column will be the same width.

one suggestion would be to make the cells the appropriate width for the
top, then just leave a cell blank between the name and the first data
cell at the bottom. The name will, as long as wrap text isn't set, spill
over into the next cell to the right. If you hide gridlines (use cell
borders if you want to see *some* lines), you won't be able to tell the
difference.

I don't recommend you merge cells, simply because that screws up
copy/paste, sort, etc. and is nearly always more trouble than its worth.


In article ,
Matt P. <Matt wrote:

In Excel, it it possible on one sheet to have a row of cells on the upper
part of the sheet one size and the lower rows another width. I'm making a
template for out track team where I'm putting scores for each event at the
top of the page so I need smaller cells. At the bottom of the paige I'm
typing in athletes' names which means the cells need to be wider. it's almost
like I'm trying to two different formats onto one page. Any suggestions?
Thanks,
Matt P.

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 are the sheet tabs made larger MAXAIRA Excel Worksheet Functions 1 December 3rd 07 08:12 PM
Creating smaller files from one worksheet maryjom Excel Discussion (Misc queries) 2 November 10th 07 04:31 AM
Creating seperate sheet lists from larger list macquarl Excel Discussion (Misc queries) 1 October 19th 05 10:17 PM
Huge sheet into smaller sheets Mia Excel Discussion (Misc queries) 2 January 28th 05 11:36 PM
Huge sheet into smaller sheets Mia Links and Linking in Excel 1 January 28th 05 07:40 AM


All times are GMT +1. The time now is 04:19 PM.

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"