Renaming through Explorer works quickly, but is not flexible enough. PowerShell has a lot of flexibility, but for a beginner this method can be intimidating. And if you need a powerful graphical tool, you will have to use a third-party program.

Conductor

Explorer has a rather unobvious way to quickly rename groups of files. First, collect all the necessary files in one folder. Switch to the “Table” view (Details) and sort the files in the required order - Explorer assigns numbers from the list starting from the top.

Select all the files you want to rename, right-click and select Rename. Enter a new name and press .

Explorer will append a number to this name for each file. A convenient way to bring all files to the same denominator, although not very flexible.

Command line

On the command line, you can use the rename or ren command to bulk rename files. You can use the wildcard * to denote multiple files at once.

The easiest way to open a command window in the desired folder is to hold down , right-click on the folder and select “Open command window here”.

Most often, command renaming is used to change the extension of an entire group of files - this cannot be done in Explorer. The command below, for example, turns all .html files into .txt:

ren *.html *.txt

The command itself is not very functional, but it can be used in complex scenarios.

PowerShell

PowerShell offers many more options for renaming files in a command environment. With PowerShell, you can pass the output of one command (cmdlet, as it's called here) to another command, just like in Linux and other UNIX-like systems.

The main commands are Dir to get a list of files in the current folder and Rename-Item to rename an object (in this case a file). Just pass the output of Dir to the Rename-Item command and you're done.

After starting PowerShell, use the cd command to navigate to the folder with the desired files. It is best to put all the files in one folder so as not to accidentally rename unnecessary ones.

Let's say we want to replace spaces in file names with underscores.

The following command lists the files in the current folder and passes it to the Rename-Item command, which replaces all spaces with underscores.

Dir | Rename-Item –NewName ( $_.name –replace “ “,”_” )

You can replace “ “ and “_” with other characters to rename the files differently.

You can learn more about using Rename-Item to perform more complex operations.

Third party utilities

If you need a powerful tool for bulk file renaming, but don’t want to mess around with the command line, you can use third-party utilities, for example. True, the interface of this application is quite confusing, since it provides a lot of capabilities that are usually only achievable using regular expressions and complex commands.

After installing the application, find and select the files to rename.

Probably many people have encountered such a problem when you have a bunch of files, for example, photos that usually have the following name: DSCF9163 or IMG_0065 or some other crap =). Do you want these photos to be called New Year!

What to do?

Rename each photo one at a time?

It’s good if there are 10-20 of them, and if there are 100-1000 or more. You know what I’ll tell you: you’ll get tired of renaming them =)))

Rename a group of files you can do it very quickly, literally in a couple of seconds, well, for students, it will take a matter of minutes!

Since we don’t want to manually rename a large group of files, it means that some program will help us. And this program Total Commander. I think everyone knows what kind of animal this is, and those who don’t know, follow the link, download and get acquainted.

But here I will still say that Total Commander is a file manager with enormous capabilities!

So, let's get started, those who have this program launch it, those who don't - download, install and launch.

To start - select the group of files that we need to rename, if you need to select all the files in the folder, press CTRL + A

A window will appear:

So, we wanted to give all the files the name "New Year". So let's do it. In the “Mask for: file name” field, write the name that we want to see, in this case “New Year” and also add a counter so that we don’t have the same names, to do this, click on the “[C] Counter” button .

Click “Run”, and after execution, close this window.

Hooray! Everything worked out! This method can be used for absolutely any files, but most often it is used to rename images.

Well, now let's look at some basic settings group renaming of files. First, completely clear the “Mask for: file name” field (for clarity). Please note that when you clear the field, the new file name will also become clear, meaning we can clearly see what will happen to the name.

And so the “[N] name” button means inserting the old name into the new name.

You can use this button if you want to use the old one in the new name. Let's go further, “Date” inserts its creation date into the file name.

The “Time” button works similarly to “Date”, only it inserts not the date, but the time the file was created.

"Diap." does not insert the entire old name, like “N”, but only the selected part of it (range). For example, let’s make sure that only the first three letters of the old name remain; to do this, click on “Diapt.”, select the first three characters in the window that appears and click “ok”

We see that in the “Mask for: file name” field it says , which means that the new name uses the first three characters of the old one (that is, from the first to the third character). If you need to use a different range, then simply select it in the “Select characters to insert” window.

Well, now let’s move on to the “[C] Counter” button, in my opinion, it is the most important here. Since the previous buttons individually cannot be used practically, because the names of new files can be the same (except for the time the file was created), we need to use something else to make the names different, in this case numbers will be used.

This counter has some settings (see section “Counter parameters [C]”). In the “Start from” field you specify the number from which the countdown will begin, for example 111

In the “Step” field you can specify how many digits the next number will take, for example 3

In the “Digits” field we indicate the number of digits that we want to see in the number; in this case, for clarity, let’s take more, for example 5

Well, with the last button “[=?] Plugin” you can add additional information to the file name (size, path, attributes, weight). There is a huge amount of information that can be added using this button.

That’s it, it looks like we’ve sorted out all the basic settings. As you can see rename a group of files at once It’s quite simple, and I’m sure it won’t be too difficult for you.

But, if you still have questions, you are welcome to comment! =) Good luck!

You can quickly change custom name fields or elements without displaying options dialogs fields And values. The following procedures do not change original name fields or element.

pivot table report

Go to section Working with Pivot Tables _gt_ analysis and in the group active field click the text box active field .

Job with pivot tables _gt_ Options.

Enter a new name.

Press the key Enter.

Note:

PivotChart report

Click the chart object (such as a bar, line, or column chart) that corresponds to the field or element you want to rename.

Go to section Working with Pivot Tables _gt_ analysis and in the group active field click the text box active field .

If you are using Excel 2007-2010, go to Job with pivot tables _gt_ Options.

Enter a new name.

Press the key Enter.

pivot table report

Click the field or element you want to rename.

On the tab Options in Group active field click the text box Active field .

Enter a new name.

Press ENTER.

Note: When you rename a numeric element, its value changes to text, which is sorted separately from numeric values ​​and cannot be grouped with numeric elements.

additional information

You can always ask a question from the Excel Tech Community, ask for help in the Answers community, or suggest a new feature or improvement to the website

To quickly find files and quickly navigate through them, it is not enough to put everything in the correct folders. It is equally important to give files names that are easy to read and meaningful. Fiddling with each of them separately is counterproductive. Therefore, there are methods for group renaming.

To work with a group of files, it is better to copy them to a separate folder. This will greatly simplify the process.

Using standard Windows tools

Changing file names

Let's consider the simplest case: we have the nth number of images with meaningless names.

Let's bring the names of these files to a visual form Picture (n), Where Picture will be the name, and n- serial number. This can be easily done directly in Explorer.

Select all the pictures that we want to rename. To do this quickly, use the key combination Ctrl + A. Then simply press F2 or right-click on the first file and select “Rename”. Enter the word as the name for the selected image Picture and press Enter.

Windows will automatically assign the same name to all subsequent files and assign all serial numbers.

If necessary, you can cancel mass renaming with the Ctrl + Z key combination.

If you want to rename a group of folders in Explorer, you can do it in the same way.

Changing file extensions

Let's say we have several text documents that, after double-clicking, open in Notepad. But we need them to be opened by the browser by default. To do this, you will have to change their extension from .txt to .html. These types of operations can be quickly performed using the command line.

Press the Windows + R keys and enter in the field that appears cmd and click OK - we see the command line window. Now we insert into it the path to the folder in which our files are located, immediately after the command CD: cd C:\Users\Max Volotsky\Desktop\Docs , and press Enter. Then we use a special command that will change their extensions: rename *.txt *.html, and press Enter again.

The original extension is indicated first in the command, the new one is indicated second. After entering the command, the system instantly makes changes.

To return everything as it was, you need to use the rename command again, swapping the extensions.

Using third party utilities

No built-in tools can match the functionality of special programs designed specifically for batch renaming. You can find many such free utilities on the Internet; just enter bulk file rename in the search.

We will look at renaming using the example of the Bulk Rename Utility program. With its help it is very convenient to change the names of folders and files, as well as the extensions of the latter.

When you first launch it, it may seem that the utility’s interface came straight from hell, and perhaps there is some truth in this. But the user does not need to navigate through numerous tabs and menus: he gets access to all functions from one window.

So, let's say we have a group of audio files that we want to make look pleasing to the eye. In this case, the numbers and the lack of artist name are annoying.

We launch the application and use the built-in file manager to go to the folder we need. Next, use the already familiar Ctrl + A key combination to select all files. We need to remove the first 3 characters at the beginning of each file name and add the artist name at the very beginning. To do this, specify the necessary parameters in the Remove and Add panels, and then click Rename.

Now we’ll make sure that all extensions consist of lowercase characters: in the Extension panel, select the Lower option and click Rename.

As you can see, other panels are available in the program window. For example, Numbering allows you to number documents in different ways, and with Case you can change the case of characters in file names. Thanks to the New Name column in the built-in explorer, which shows the result of the rename before it's applied, you'll easily understand the rest of the Bulk Rename Utility.

The last operation with files and folders performed in the program can be easily undone using the Ctrl + Z key combination.

The user can change the format of the PivotTable, rename fields or items, add new rows or columns, and make other changes to the appearance of the PivotTable.

To change the name of a field or element of a pivot table, you need to select the desired cell and type a new name, which should not repeat the names existing in the source table.

Change cell title text A3 to “Sales Amount”.

· Select cell A3 pivot table.

· Enter a new name using the keyboard.

When you create a PivotTable, the default function used to calculate totals is Summation, which can be changed to any other function.

To create a new pivot table, just change the layout of the existing one.

Create a pivot table reflecting data on sales to purchasing stores and the share of each of them in
total purchase amount.

To do this, you must perform the following steps.

· On the toolbar Pivot tables(if this toolbar is not on the screen, then run the command View|Toolbars|Pivot Tables) press the arrow button Pivot table and select Master.

·Press a button Layout.

· Using the mouse, drag the “Store Name” field (4th from the top) into the area Line, field “Amount” - to the area Data and double-click with the left mouse button on this field. In the window that opens, in the option Name, enter “Sales Amount” from the keyboard and press OK.

· Using the mouse, drag the “Amount” field a second time into the area Data and double-click with the left mouse button on this field. In the window that opens, in the option Name enter “Store share” from the keyboard, in the same window press the button More>>. In option Additional calculations press the down arrow and select Proportion of the total by column. Click OK.

· In the layout window, click OK.

Existing sheet. Press the button Ready.

· View the result (Fig. 66)

Create a pivot table reflecting data on the average amount of store purchases by type of equipment.

The order of actions.

· Place the cursor in any cell of the created pivot table.

· On the toolbar Pivot tables press the arrow button Pivot table and select Master.

·Press a button Layout.

· To clear the layout, drag the fields to any place in the window.

· Using the mouse, drag the “Store Name” field into the area Column, field “Type of product” - to the area Line, field “Amount” - to the area Data and double-click with the left mouse button on this field button. In the window that opens, in the option Operation choose Average and press OK.

· In the layout window, click OK.

·Press a button Options.

· In the window that opens PivotTable Options in option Format remove checkboxes Total by columns And Total amount by lines. Click OK.

· In the window that opens, check that the option is enabled Existing sheet. Press the button Ready.

· View the result (Fig. 67).

Group operations in pivot tables

Create a pivot table with data on the number of sales
goods in certain price ranges.

The order of actions is as follows.

· Place the cursor in any cell of the created pivot table.

· On the toolbar Pivot tables press the arrow button Pivot table and select Master.

·Press a button Layout.

· To clear the layout, drag the fields to any place in the window.

· Using the mouse, drag the “Price” field into the area Line, field “Quantity” - to the area Data and press OK.

· In the window that opens, check that the option is enabled Existing sheet. Press the button Ready.

· Right-click in the “Price” cell of the resulting pivot table.

· In the context menu, select the command Group and structure|Group.

· In the window that opens Grouping in option Step by step enter 300 from the keyboard (the minimum and maximum price of the product - 50 and 800 - is set automatically from the list) and press OK.

· View the result (Fig. 68).