change grid line spacing excel 2016 for mac

The following scatterplot will automatically be created:īy default, Excel will choose a scale for the x-axis and y-axis that ranges roughly from the minimum to maximum values in each column. Then click the Insert tab along the top ribbon and then click the Scatter option within the Charts group: Next, highlight the cells in the range A2:B16. Step 1: Enter the Dataįirst, let’s enter a simple dataset into Excel: To set the amount of space for the option you chose, click the arrows to the right of the pop-up menu.This tutorial provides a step-by-step example of how to change the x-axis and y-axis scales on plots in Excel. By contrast, double-spacing doubles the height of each line. The distance from one line to the next is never less than the value you set, but it may be larger for larger fonts to prevent overlapping text lines.Įxactly: The value sets the precise distance between text baselines, which may result in some overlap.īetween: The value you set increases the space between the lines, instead of increasing the height of the lines. The space between lines is proportional to the font size.Īt least: The distance between lines stays fixed (but lines don’t overlap if the text gets large). Lines: The distance between ascenders (parts of letters that extend to the top of the line) and descenders (parts of letters that extend below the line) stays the same. In the Format sidebar, click the Text tab, then click the Style button near the top of the sidebar.Ĭlick the disclosure arrow next to Spacing (to open it), click the pop-up menu below Spacing, then choose an option: You can't adjust line spacing for text in a table cell. Select the text, or click the text box or shape with the text you want to change.

Restore an earlier version of a spreadsheet.

Save a large spreadsheet as a package file.

See the latest activity in a shared spreadsheet.

Place objects inside a text box or shape.

Format Chinese, Japanese, or Korean text.

Use a keyboard shortcut to apply a style.

Create, rename, or delete paragraph styles.

Bold, italic, underline, and strikethrough.

Format a spreadsheet for another language.

Select text and place the insertion point.

Change the look of chart text and labels.Add a legend, gridlines, and other markings.Add column, bar, line, area, pie, donut, and radar charts.Calculate values using data in table cells.Quickly calculate a sum, average, and more.View the source data for a pivot table value.Change how pivot table data is sorted, grouped, and more.Add calculations to summarize group data.

Add checkboxes and other controls to cells.Use VoiceOver to create formulas and autofill cells.Intro to images, charts, and other objects.

Change grid line spacing excel 2016 for mac