MS Excel — Sharing Custom Slicers Between Workbooks
How to COPY Slicers Between Two Excel Workbooks
If you use Excel slicers (Microsoft’s name for filter dialog boxes), you may be aware that the default set is a pretty drab selection.
I routinely create custom format slicers — like shown above — for reports and client dashboards that I create.
It’s a tedious process, and until today, I knew of no way to copy these custom format slicers across workbooks.
I decided to figure out if this could be done…
A quick Google search brought me here:
The proposed answer that looked promising was this:
“If you go to your old file, copy the slicer, and paste it to the new file (even though that one doesn’t belong there), your saved style will appear in the new file’s slicer style catalog. You can now delete the slicer.”
So, I gave it a shot.
But, it looks like they give me an alternative…copy the entire table AND Slicers.
So, I decided to COPY the entire worksheet and paste it into a blank workbook.
Select Copy to “new workbook” and the entire worksheet, with Slicers is copied over.
Select a Slicer and let’s take a look at the Slicer Formatting options:
Now, I just delete the worksheet that I brought in and the custom slicer style remains.
That is today’s #learnedsomethingnew that is going to save me a TON of time going forward.
As I think about this, a separate workbook that contains all my custom Slicer styles would be very helpful — that’s the next task… :-)
About Don
“It’s time for DIFFERENT”
Don is passionate about helping professionals and organizations keep up, develop and adapt to the changing business world that we operate in.
