This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
How can I outline data in a pivot table? e.g. I am showing "Data" as columns. So I have multiple columns within a column. The pivot table quick style "none" places an outline around the "grouped" columns. Essentially this is what I want to duplicate - but none of the other quick styles do this - can't figure out how this is done?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
As stated earlier, you can highlight the columns and choose ‘All border’ option in the 'Font' section of the 'Home' tab.
Let's say I have (3) data columns within a "column". I want to outline (box) the outside of the data columns that are withinn the "column".
This is an app for an end user, so it needs to be delivered format ready.
Do you want to add outline only for the columns or even the data within it?
You can try highlighting the content and then insert a border preferably ‘Outside border’ or ‘all border’.