Cambiar fuente de Segmentación de datos

%3CLINGO-SUB%20id%3D%22lingo-sub-3004696%22%20slang%3D%22es-ES%22%3EChange%20Slicement%20Source%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3004696%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20morning%20to%20the%20whole%20Community%2C%3C%2FP%3E%3CP%3EI%20would%20appreciate%20it%20if%20you%20would%20help%20me%20with%20this%20issue.%20I%20am%20writing%20an%20EXCEL%20and%20have%20created%20a%20%3CEM%3Eslicement%3C%2FEM%3E%20in%20it.%3C%2FP%3E%3CP%3EI%20would%20like%20the%20segmentation%20to%20have%20the%20%3CSTRONG%3ETimes%20New%20Roman%20font%2C%20%3C%2FSTRONG%3Ehowever%20the%20%3CEM%3ECalibri%3C%2FEM%3E%20font%20always%20appears%20and%20for%20now%20I%20have%20not%20been%20able%20to%20find%20the%20solution.%3C%2FP%3E%3CP%3E%3CSTRONG%3ECan%20I%20modify%20the%20font%20and%20font%20size%20in%20a%20slicement%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3004696%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3007738%22%20slang%3D%22en-US%22%3ERe%3A%20Cambiar%20fuente%20de%20Segmentaci%C3%B3n%20de%20datos%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3007738%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1229373%22%20target%3D%22_blank%22%3E%40Marchal1979%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyes%2C%20you%20can.%20First%2C%20you%20have%20to%20duplicate%20one%20of%20the%20slicer%20layouts%2C%20then%20you%20can%20change%20the%20font.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Select%20the%20slicer%2C%20then%20do%20a%20right-click%20on%20the%20desired%20layout%20und%20select%20%22Duplicate...%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DTE_0-1637914449477.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329646iA3EDD8C5B35DD4F8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DTE_0-1637914449477.png%22%20alt%3D%22DTE_0-1637914449477.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E2.%20In%20the%20next%20window%2C%20select%20the%20element%20you%20want%20to%20change.%20For%20example%2C%20select%20%22Whole%20Slicer%22%20to%20change%20the%20font%20in%20all%20elements.%20Then%20click%20on%20%22Format%22-button%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DTE_1-1637914559502.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329647i4C1AEA37CCB1E842%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DTE_1-1637914559502.png%22%20alt%3D%22DTE_1-1637914559502.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E3.%20Make%20the%20adjustments%20to%20the%20font%20as%20you%20like%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DTE_4-1637914812192.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329650i817225FDB1366898%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DTE_4-1637914812192.png%22%20alt%3D%22DTE_4-1637914812192.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20close%20these%20setting%20windows%3C%2FP%3E%3CP%3E4.%20Your%20slicer%20still%20uses%20the%20old%20settings%2C%20so%20you%20have%20to%20select%20the%20new%20duplicated%20layout%2C%20which%20is%20shown%20as%20%22Custom%22%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DTE_3-1637914753734.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329649i2656E55050057A70%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DTE_3-1637914753734.png%22%20alt%3D%22DTE_3-1637914753734.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ENow%20the%20slicer%20is%20using%20the%20new%20font%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DTE_5-1637914887809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329651iCB1A7F824390FF03%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DTE_5-1637914887809.png%22%20alt%3D%22DTE_5-1637914887809.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3008308%22%20slang%3D%22es-ES%22%3ERe%3A%20Change%20Slicement%20Source%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3008308%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20morning%20dear%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F48469%22%20target%3D%22_blank%22%3E%40DTE%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20your%20answer!%20I%20have%20completed%20all%20the%20steps%20but%20have%20not%20been%20able%20to%20make%20such%20a%20modification%20and%20let%20me%20explain%20why%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.-%20I%20have%20selected%20the%20%3CEM%3Edata%20segmentation%3C%2FEM%3E%20and%20I%20have%20right-clicked%20on%20its%20format%20to%20select%20DUPLICATE.%3C%2FP%3E%3CP%3E2.-%20I%20have%20selected%20%3CSTRONG%3EThe%20Entire%20Table%20%3C%2FSTRONG%3Eand%20then%20I%20have%20clicked%20on%20format%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Captura%20de%20pantalla%202021-11-26%20a%20las%2011.48.20.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329674iFE7DE06A8487C757%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Captura%20de%20pantalla%202021-11-26%20a%20las%2011.48.20.png%22%20alt%3D%22Screenshot%202021-11-26%20at%2011.48.20.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E3.-%20How%20you%20can%20see%2C%20when%20accessing%20the%20following%20window%20the%20%3CEM%3Efonts%20appear%20in%20gray%2C%20I%20can%20not%20select%20them%20and%20the%20default%20font%20is%20calibri%3A%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Captura%20de%20pantalla%202021-11-26%20a%20las%2011.48.54.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329675i0FCEEA6DA987AFC7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Captura%20de%20pantalla%202021-11-26%20a%20las%2011.48.54.png%22%20alt%3D%22Screenshot%202021-11-26%20at%2011.48.54.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20know%20what%20that%20might%20be%20due%20to%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Buenos días a toda la Comunidad,

Les agradecería que me ayudaran con este tema. Estoy redactando un EXCEL y he creado una segmentación de datos en el mismo.

Me gustaría que la segmentación de datos tuviese la fuente Times New Roman, sin embargo siempre aparece la fuente Calibri y por ahora no he conseguido encontrar la solución.

¿Se puede modificar la fuente y el tamaño de la misma en una segmentación de datos?

Gracias de antemano.

3 Replies

Hi @Marchal1979 

 

yes, you can. First, you have to duplicate one of the slicer layouts, then you can change the font.

 

1. Select the slicer, then do a right-click on the desired layout und select "Duplicate..."

 

DTE_0-1637914449477.png

2. In the next window, select the element you want to change. For example, select "Whole Slicer" to change the font in all elements. Then click on "Format"-button:

DTE_1-1637914559502.png

3. Make the adjustments to the font as you like:

DTE_4-1637914812192.png

 

Then close these setting windows

4. Your slicer still uses the old settings, so you have to select the new duplicated layout, which is shown as "Custom":

DTE_3-1637914753734.png

Now the slicer is using the new font:

DTE_5-1637914887809.png

 

 

Buenos días estimado @DTE,

 

Muchas Gracias por su contestación!! He realizado todos los pasos pero no he podido realizar dicha modificación y permítame explicarle por qué:

 

1.- He seleccionado la segmentación de datos y he dado clic derecho a su formato para seleccionar DUPLICAR.

2.- He seleccionado Toda la Tabla y luego he clicado en formato:

Captura de pantalla 2021-11-26 a las 11.48.20.png

3.- Cómo podrá observar, al acceder a la siguiente ventana las fuentes me aparecen en gris, no las puedo seleccionar y la fuente por omisión es la CALIBRI:

Captura de pantalla 2021-11-26 a las 11.48.54.png

 

¿Sabe usted a qué podría ser debido?

 

Gracias de antemano

 

 

Hi @Marchal1979 

 

yes, that looks strange. What Excel version do you use? Is it Excel for Mac? Maybe you cannot change the font in Excel for Mac, but I do not know.