long question...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am making a spreadsheet and I need to make a legend at the top on each page, the legend has more than the amount allowed for a header. It needs to basically look like this

A:kdjflsakdflsdjflksjf B:sjflkdsjflksjflkjsdflkjsdf C:flsdkfjlskjfklsdjflksd
D:fjsdkljflksdjfkljsdfl C:fjsldkfjlksdfklsdjflsdfkd E:ksfjklsjflksdjflkjsdfk

and then have regular rows and columns starting underneath. It can be a box with the legend information that takes up about 7 rows and all of the columns on the page. I've been trying to do this for hours now! Thanks
 
Hi Tanja

Use a textbox from the Drawing Toolbar
Right click on any toolbar and check the Drawing toolbar

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




Tanja said:
I am making a spreadsheet and I need to make a legend at the top on each page, the legend has more than the amount allowed for
Click to expand...
a header. It needs to basically look like this:
A:kdjflsakdflsdjflksjf B:sjflkdsjflksjflkjsdflkjsdf C:flsdkfjlskjfklsdjflksdj
D:fjsdkljflksdjfkljsdfl C:fjsldkfjlksdfklsdjflsdfkd E:ksfjklsjflksdjflkjsdfkd

and then have regular rows and columns starting underneath. It can be a box with the legend information that takes up about 7
Click to expand...
rows and all of the columns on the page. I've been trying to do this for hours now! Thanks
 
The print header (File - Page Setup - Header/Footer) can be quite large.
You may have to move the margin down a little. Try going into Print
Preview, turn on margins (click the Margins button), then drag the top
margin down. It's below the header margin at the top of the page. Then put
your header stuff in the three boxes in File - Page setup - Header/Footer -
Custom header.

Or you can use "Rows to repeat at top" in the Sheet tab of the same command.
You'll need to have your header stuff in some rows.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Tanja said:
I am making a spreadsheet and I need to make a legend at the top on each
Click to expand...
page, the legend has more than the amount allowed for a header. It needs to
basically look like this:
A:kdjflsakdflsdjflksjf B:sjflkdsjflksjflkjsdflkjsdf C:flsdkfjlskjfklsdjflksdj
D:fjsdkljflksdjfkljsdfl C:fjsldkfjlksdfklsdjflsdfkd E:ksfjklsjflksdjflkjsdfkd

and then have regular rows and columns starting underneath. It can be a
Click to expand...
box with the legend information that takes up about 7 rows and all of the
columns on the page. I've been trying to do this for hours now! Thanks
 
Select the First Row and Format as "Text" and click the "wrap text" option.
Merge the columns in the first row that you need for your heading. This keeps your data columns below the header.
Enter the data, when you reach the end of a line press ALT+RETURN to move onto the next line of input.
Go to File , Page Setup , on the Sheet tab select "rows to repeat" and select row1, this will then repeat the contents of row 1 on each page of the spreadsheet. The merge icon automatically centres text, to left adjust highlight the cell and select the left adjust icon.

Hope this helps.
 
Back
Top