By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,424 Members | 1,391 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,424 IT Pros & Developers. It's quick & easy.

Almost Done! Need help formatting Excel

P: n/a
JM
Hi

I am almost done my little project. However I need to know how to "centre"
the title/header row. I've already managed to bold and underlined.

Also how would one sort all of the data on the worksheet but not including
the header row??

worksheet.get_Range("A1", "H1").Font.Bold = true;
worksheet.get_Range("A1", "H1").Font.Underline = true;

Range oRng = worksheet.get_Range("A1", "H1");
oRng.EntireColumn.AutoFit();

Nov 16 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
JM
I got how to centre the header / title row

worksheet.get_Range("A1", "H1").HorizontalAlignment = -4108;

Now how does one AutoFilter the Excel spreadsheet??

"JM" wrote:
Hi

I am almost done my little project. However I need to know how to "centre"
the title/header row. I've already managed to bold and underlined.

Also how would one sort all of the data on the worksheet but not including
the header row??

worksheet.get_Range("A1", "H1").Font.Bold = true;
worksheet.get_Range("A1", "H1").Font.Underline = true;

Range oRng = worksheet.get_Range("A1", "H1");
oRng.EntireColumn.AutoFit();

Nov 16 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.