Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how are the sheet tabs made larger | Excel Worksheet Functions | |||
Creating smaller files from one worksheet | Excel Discussion (Misc queries) | |||
Creating seperate sheet lists from larger list | Excel Discussion (Misc queries) | |||
Huge sheet into smaller sheets | Excel Discussion (Misc queries) | |||
Huge sheet into smaller sheets | Links and Linking in Excel |