Format or Remove Borders from a Slicer or Timeline in Excel
Changing the formatting, or removing completely, the borders from Excel Slicers and Timelines isn’t obvious – read on to find out how
One of my favourite features introduced with Excel 2010 was the ability to use Slicers against Pivot Tables & Pivot Charts.
With Excel 2013, Microsoft expanded upon this by allowing them to be connected to Tables of data, and also introduced Timeline Slicers.
These nifty slicers are basically a time-based slicer, but presents it as an expandable timeline.
I’ll do a separate write up on timeline slicers at some point in the near future, but one thing I noticed is that unlike other objects in Excel, such as Charts, it’s not immediately obvious how you format or remove borders and other elements of the slicers.
Formatting for these objects is controlled by ‘Styles’. When you select the Slicer or Timeline, you’ll get the ‘Slicer Tools’ or ‘Timeline Tools’ tab appear, and you’ll see a choice of Slicer Styles to pick from. The available styles give you some flexibility over basic colour schemes, so it can fit in with the data you’re presenting.
However, you may find there’s nothing there that quite suits what you’re after – and you certainly won’t find one which gets rid of the borders – but you can create your own style, and define this yourself – and it’s far simpler that you might think.
Start by finding a Style which closely meets your needs colour wise. I’ve gone for Timeline Style Light 1.
It so happens I want to remove some of the ‘furniture’ from the Timeline for a cleaner look. These can be turned off from the OPTIONS tab, SHOW group (This differs for Slicers).
Not to get rid of that border.
Back in the Styles group, right-click on the Style you’ve selected, and select ‘Duplicate’
From here, you can modify all visual formatting of the slicer / timeline. The exact options will differ between Slicers & Timelines, but it’s the same layout and approach.
Give your modified Style a name. Then select the ‘Whole Timeline’ option, and ‘Format’.
Head to the ‘Border’ tab, and select the ‘None’ option – or change them to whatever style / colour you wish.
Select OK to close the Format window, and OK again to close the Modify Style window.
Now back in the OPTIONS tab, expand the list of Styles, and you should see your new style listed under a new heading ‘Custom’.
Select it, and it should then apply the style to your Timeline/Slicer
And there you have it – a borderless Slicer / Timeline for your data presentation.
Thank you ever so much.
Keep up the good work – keep sharing.
Knowledge is free for the yearning.
Hello and thank you, I hope to be able to use this formatting! However, when I add a slicer (Ex 2013), it is not appearing – only an outline of the slicer box is. The buttons inside still work though! Aware of what I’ve chosen for the slicer I can still filter my data. Any idea why I am not seeing any of the buttons?