Serie | search
Click here to view Serie news from 60+ newspapers.
Bookmark or Share- Freeze panes to lock rows and columns - Microsoft SupportHow to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
- Rename a data series - Microsoft SupportIf you want to rename an existing data series or change the values without changing the data on the worksheet, do the following: Right-click the chart with the data series you want to rename, and click Select Data. In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit.
- Fill data automatically in worksheet cells - Microsoft SupportAutomatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.
- Split data into multiple columns - Microsoft SupportSo, you can split the Sales Rep first name and last name into two columns. Select the "Sales Rep" column, and then select Home > Transform > Split Column. Select Choose the By Delimiter. Select the default Each occurrence of the delimiter option, and then select OK.
- Add a data series to your chart - Microsoft SupportAfter creating a chart, you might need to add an additional data series to the chart. A data series is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits.
More
