How to delete even pages in excel

create a directory

List all worksheets in the table of contents and enter a link jump.

Merge data and center it.

The elements in the selected area are merged and placed in the center, which is different from the "Merge Center" that comes with EXCEL.

Recoverable merger center

You can restore data at any time after merging regions, and you can use Ctrl+t operation.

Slant heading

You can make two headers and three headers by imitating the tool for making headers in WORD.

Column selection toolbox

Arbitrarily select odd rows or columns, even rows or columns, and support switching between use area and selection area.

Reverse selection

Select the area other than the mouse selection (only select the used area, which is more suitable for the demand).

Select the pictures in the table below.

Just select the picture in the worksheet, skip the rest of the autoshapes, and so on.

Regional positioning tool

It can be located in any character and number area, (enter 60, 100, etc. ) supports wildcards such as "Guo" and "Liu *". ), which is an enhancement of EXCEL's positioning ability.

Instant encryption of multiple worksheets

Instantly encrypt dozens or even hundreds of worksheets.

Reverse encryption of worksheet

In other words, the area outside the mouse selection is encrypted.

Batch labeling superscript

You can subscript any character in the worksheet and finish it immediately.

Worksheet name sorting

Enter 1 for ascending order and 0 for descending order, and rearrange the worksheet names as needed.

Import a picture into a cell

Import 24-bit pictures into the worksheet, purely for entertainment.

Make payroll

Special for finance, headers can be added alternately, and the number of rows can be set freely. The height of that space line can be set freely.

Delete payroll

Delete the title generated by the last tool.

Generate non-repetitive random numbers

Generate non-repetitive random numbers from 1 to the specified number, and easily solve the common problems of the functional version.

Eliminate regional duplicate values

Delete duplicate values in the selection, leaving only unique values. Support multiple rows and single columns and multiple rows and columns.

Create bottom header EXCEL

An extension of the title. You can insert 1 to the bottom line of 6 lines in the footer of each page.

Filter by color

Filter the area by color, first select a cell, and then click this tool to hide other colors.

Create a number with a circle

It makes up for the shortage that EXCEL only creates circled characters within 10.

Calculate the amount of banknotes according to wages.

Calculate the amount of banknotes in various currencies required for each employee's salary, and then collect the corresponding banknotes from the bank according to the calculated amount of banknotes. When the wage bag is packed, it is beneficial to the distribution of paper money. Beware of the lack of change.

Restart the computer

Call the shutdown program of WINDOWS (will ask whether to shut down).

Lock screen

Lock the screen, you need a password to open it (provided that the login password is set).

Lock the mouse

Lock the mouse in the upper left corner of the screen and cannot move (shortcut key Ctrl+Q).

Unlock the mouse

No menu item is provided, only the shortcut key (Ctrl+W) can be used to unlock the mouse. Remember, otherwise, you can't use the mouse.

Check the computer usage time

Check the use time of the computer from boot to now, and pay attention to rest! ! !

View disk space

Circularly report the remaining space of each disk. If there is no optical drive in the optical drive, it will prompt "Disk Not Ready".

View IP and CPU and hard disk ID.

Check your IP address, serial number of drive C in the hard disk and ID number of CPU.

Exquisite calendar

A beautifully made calendar showing the lunar calendar and solar terms (ALT+F4 is off, so don't ask me again).

EXCEL forum collection

Collect the addresses of several large EXCEL forums in China and provide links.

Constituency feature statistics

Count the number of Chinese characters, letters, Arabic numerals and other characters in the selected area, which is consistent with WORD.

One-click recovery of Excel

Restore EXCEL settings to their original state and remove menu and function restrictions.

One-click weight loss workbook

Lose weight in the workbook (the workbook has no extra format and the table remains the same)

Delete hyperlinks with one click.

Delete hyperlinks from all worksheets in the current workbook at once.

One-click simplification

Convert the simplified Chinese of the selected data into traditional Chinese.

One-click complexity becomes simple.

Convert the traditional Chinese characters of the selected data into simplified Chinese characters.

Delete the workbook data link with one click.

Convert data references of all worksheets in a workbook to numerical values, and delete their links to preserve the results.

Export graphics to hard disk with one click.

Convert all graphic objects in the current worksheet into pictures and export them to the hard disk.

Delete the selection comment with one click.

Delete all comments in the selected area immediately.

One-key generation letter sequence

Generate a -IV sequence, so that you can use the mouse to drop down and fill in the letters.

Return to home page

You can immediately return to the table of contents page in any worksheet.

Merge data and copy

Paste multiple cell data into one cell.

Create personalized comments

Create personalized comments to make your comments unique and eye-catching.

Create a picture annotation

Create a comment in a cell and display a picture in the comment.

Batch modify the appearance of comments

Modify the appearance style of all comments in the selection.

Adding the right column in batch is the marked right column.

If the tool is executed in the selected area, the data on the right side of the cell will be added to the comments of the cell, and the discontinuous area can be operated.

Batch modification label

The label of the chart can be modified at will, which is no longer limited to manual modification one by one, especially for advanced charts.

Batch moving label

The label of the chart can be moved at will, which is not limited to moving one by one by hand, and is dedicated to advanced charts.

Chart output as a picture

Convert charts into pictures, supporting JPG and GIF formats. The input folder can be freely selected.

Batch new folder

Create new folders in batches, the number of which is equal to the number of days in the current month, and name them by date. Free choice of storage location.

Create new workbooks in batches

Create new workbooks in batches, the number of which is equal to the number of days in the current month, and name them by date. Free choice of storage location.

Batch new worksheet

Create new worksheets in batches, the number is equal to the number of days in the month plus 1, and the last one is the summary table. The rest of the worksheets are named after dates. At the same time, list and link all worksheets.

Create and copy worksheets in batches

Instantly create and copy 1-255 worksheets, and support the creation and copy of cell data. Tools are located in the right-click menu of the worksheet tab in the lower left corner.

All calculations

Invalid in 2007, this tool is located in the right-click menu of the status bar in the lower right corner.

Generate system icon

The gospel of programmers. Put EXCEL's built-in icons in the toolbar for easy viewing and use in your own programs.

Delete icon toolbar

Delete the toolbar generated by the last tool.

Delete code comment line

Delete lines in the code that are full of comments.

Get all menu ids

Generate the internal menu name, menu ID and chart ID of EXCEL2003 in the worksheet, which need to be borrowed when programming.

Excel2000 classic menu

Get all the menus in Excel, and learn how to generate them.

Create pagination subtotal

At the bottom of each page, establish the current total and the cumulative number of the page. Similar to a footer but more powerful!

Delete pagination subtotal

Delete the subtotal generated by the last tool.