WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • change name of excel file

    1339 results for change name of excel file

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF

    1339 results for change name of excel file

    How to change legend name in excel pie chart

    The legend is a form of graphical representation in which the names of the variables are placed on an axis of the histogram. Each line represents the measurement for a single category, and each vertical bar correspond to one score from that category. The legend helps you see how your categories have been distributed. Changing legend names in excel is no rocket science, but one that could have devastating consequences if done incorrectly. If you change the name of your data series, not ....

    xls Spreadsheet 2.8K views

    How to Change Legend Name in Excel on Mac

    The data in the cell above each column or row of data is used as the legend name when you build a chart in Excel. You can alter legend names by changing the data in those cells, or you can use Select Data to modify the default legend name. The caption for the above graph, which features a bulleted list with the phrase "A Sales" and "B Sales," is situated in the top Centre of the graph. These procedures make it simple to add a legend to an Excel chart that is missing one: Add legend to ....

    xls Spreadsheet 4.1K views

    How to make Excel Defined name in Excel file

    In everyday life, names are widely used to refer to people, objects, and geographical locations. For example, instead of saying "the city lying at latitude 40.7128° N and longitude 74.0059° W, you simply say "New York City". In Excel, you can create and use two types of names: Defined name - a name that refers to a single cell, range of cells, constant value, or formula. For example, when you define a name for a range of cells, it's called a named range, or defined range. How t....

    xls Spreadsheet 1.5K views
    Batch export multiple pictures

    Batch export multiple pictures

    00:54

    Batch export multiple pictures

    If you want to save multiple pictures in a table, a common practice is to save them one by one. It will be very troublesome when there are a large number of pictures. Today, we will learn a quick tip to export pictures in batches. Taking this table as an example, we can see that there are many pictures in the table. First, change the suffix name of this table file in accordance with the suffix of the zip file. Here, we change the .xlsx format to .rar format and then decompress the file....

    Spreadsheet 1.3K views

    How to change properties of excel file on Mac (Step by Step)

    How to change windows file attributes in Excel. In this modern world excel plays a vital role in working for any financial need whether, about company procedures or making data analysis, all work can be done easily on excel. This update of the spreadsheet includes 100 built-in formulas, tables, and many other functions also by which a single person can take thousands of benefits easily it also helps to work smartly like it saves a lot of time rather than handwritten notes and you can e....

    xls Spreadsheet 2.4K views

    Excel Formula: How to Get the Excel File Name from Path

    The excel file name is the file name that you give to it when you save it. It can be very important because the folder where you save your file will store a number of details about it. For example, if you want to save this file again next week and not the week after, or next month and not next week, or just whenever and not at all then knowing how to get thefile name is essential. If you need to know how to get the file name, there are actually many different techniques that you can us....

    xls Spreadsheet 5.1K views

    How to insert and change the name of the slicers

    Slicer is a very useful feature in WPS Spreadsheet. It can only be applied to a Pivot Table and can help users quickly filter various data. To learn more about the pivot table, you can watch some related videos in our WPS Academy.First, we need to create a Pivot Table.1. Open the table in WPS Spreadsheet, click the Insert tab → and click the PivotTable button, then the Create PivotTable interface will pop up.2. Select the cell range of the Pivot Table in the Select a range area.3. Sele....

    xls Spreadsheet 5.2K views

    How to change text in an Excel file

    How to change text in an Excel file -WPS Academy: The SUBSTITUTE function in Excel locates a string in a cell and substitutes a different string for it. The SUBSTITUTE function searches for repetitions of the string in the cell and is case-sensitive and helps to change text in an Excel file. The SUBSTITUTE function lets you specify whether it should apply to just one occurrence of the string or to all instances. This substitutes the new string for all instances of the old one. Change t....

    xls Spreadsheet 1.1K views
    Prev 1 2 3 ... 167 168 Next
    WPS Academy
    Products
    Partners