Reduce the file size of your Excel spreadsheets - Microsoft Support
You can reduce your file size by saving your spreadsheet as a binary workbook (.xslb) instead of the default format (.xslx). The default format is XML based, which is important if you're using your data with third-party programs because XML is an open standard.
Convert numbers stored as text to numbers in Excel
Use a formula to convert from text to numbers. You can use the VALUE function to return just the numeric value of the text. Insert a new column next to the cells with text. In this example, column E contains the text stored as numbers. Column F is the new column.
Turn off picture compression - Microsoft Support
Turn off compression in Word, PowerPoint, or Excel. Click File > Options. In the Options box, click Advanced. In the list at Image Size and Quality, do one of the following. (This example shows the options in Word.) Ignore the drop-down list to select your current document by default.
Change a theme and make it the default in Word or Excel
Document themes make it easy to coordinate colors, fonts, and graphic formatting effects across your Word, Excel, and PowerPoint documents and update them quickly. This video show you how-to change the entire theme, read below to just customize theme fonts, colors, or effects.
Compress a picture - Microsoft Support
Select the picture you want to compress. Click the Picture Tools Format tab, and then click Compress Pictures. To compress your pictures for insertion into a document, under Resolution, click Print. To compress your pictures for publication on a Web page, under Resolution, click Web.
Cloud fonts in Office - Microsoft Support
2024年6月11日 · Use cloud fonts to make sure your slides and documents look the same, no matter where you open them or who else views them. Cloud fonts are fonts hosted in the cloud by Microsoft 365, and are available in the latest versions of Office applications (see the Cloud fonts availability table, below).
Ways to format a worksheet - Microsoft Support
Using styles to quickly format data. Formatting data manually. Using borders and colors to emphasize data. Changing the alignment or orientation of data. Copying an existing format to other data. In Excel, there are many ways to formatt a worksheet, such as applying themes, styles, borders and colors, to name a few.
Show or hide the ribbon in Office - Microsoft Support
The ribbon is a set of toolbars at the top of the window in Office programs designed to help you quickly find the commands that you need to complete a task. Show Ribbon options. At the top-right corner, select the Ribbon Display Options icon . Choose an option for the ribbon:
Add and format a chart legend - Microsoft Support
Format a chart legend. Steps for adding and changing the look of a chart legend in Office 2016 for Windows, including customizing the border, the background of the chart legend, and changing and resizing the font used in a chart legend.
Move or resize a chart - Microsoft Support
You can move a chart to any location on a worksheet or to a new or existing worksheet. You can also change the size of the chart for a better fit. By default, a chart is moved and sized with cells. When you change the size of cells on the worksheet, the size of the chart adjusts accordingly.
Format text in cells - Microsoft Support
Formatting text or numbers can make them appear more visible especially when you have a large worksheet. Changing default formats includes things like changing the font color, style, size, text alignment in a cell, or apply formatting effects. This article shows you how you can apply different formats and also undo them.