Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Applying a Border Around Sets of Data
Is it possible to apply a border around groups of data.
For example, give the the sample sheet below, a border would surround the groups of fruit. Borders would highlight the Apple, Orange, and Pear sections. A B C ==================== Apple 12 13 Apple 13 2 Apple 4 5 Orange 40 12 Pear 45 13 Pear 4 11 Is thier a simple way to have this automatically applied or must it be done programmatically. The data within the sheet is refreshed daily. In lieue of setting the borders manually, I'd like to have a more automated approach. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Applying a Border Around Sets of Data
Check out your response in programming. Please do not double post. Check out
this link... http://www.cpearson.com/excel/newposte.htm -- HTH... Jim Thomlinson "Orlanzo" wrote: Is it possible to apply a border around groups of data. For example, give the the sample sheet below, a border would surround the groups of fruit. Borders would highlight the Apple, Orange, and Pear sections. A B C ==================== Apple 12 13 Apple 13 2 Apple 4 5 Orange 40 12 Pear 45 13 Pear 4 11 Is thier a simple way to have this automatically applied or must it be done programmatically. The data within the sheet is refreshed daily. In lieue of setting the borders manually, I'd like to have a more automated approach. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Applying a Border Around Sets of Data
Sorry Jim,
I wasn't quite sure where the post belonged. I'll do my best to adhere to the rules in the future. "Jim Thomlinson" wrote: Check out your response in programming. Please do not double post. Check out this link... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying formulas to filtered data | Excel Discussion (Misc queries) | |||
applying st. dev. of a data set to a trendline forcast | Charts and Charting in Excel | |||
Applying data to a spreadsheet..help please | Excel Worksheet Functions | |||
Applying data as a line over an area chart | Charts and Charting in Excel | |||
Applying formulas only to the subtotals of a data list | Excel Discussion (Misc queries) |