[Excel] I want to work efficiently even if I open a lot of files!Open, line up, and switch multiple books at once with Excel

How to use Excel that can't be heard anymore

July 10, 2019 06:55

When working with multiple books, it is not good to efficient ...

　In many duties that use Excel, you often open multiple books and work.But do you think, "It's troublesome to open multiple books one by one every time ..." "It's a lot of trouble to change the screen one by one when you compare the two books ..."I get frustrated by opening the book and switching the screen to compare the contents, and I get irritated and make mistakes more.This is a vicious cycle.

　This time, I will explain three convenient techniques that can be used to increase the efficiency of work using multiple books.

❶ Select multiple books and open them all at once

　The first technique is to select multiple books and open them all at once.If you know in advance that you need to open multiple books, use this technique to reduce the time it takes to open the book.Let's take a look at the way.

　Open Explorer and move to the folder where the book you want to open.Click the Book you want to open while pressing the [Ctrl] key (①).In this example, the book you want to open is separated, so I select it while holding down the [Ctrl] key, but if the book you want to open is displayed side by side, select the first book and then the [Shift] key.If you press the last book while pressing, you can select the book in the meantime.

　If all the books you want to open are not stored in the same folder, you will not be able to open multiple books in this way.Save the book you want to open together in the same folder.

　Once you have selected all the book you want to open, right -click (②) on one of the selected books.The menu will be displayed. Select [Open] (③).

　Excel starts and two selected books open at the same time.If you match the mouse pointer to the Excel icon displayed in the taskbar, you can display the open book preview (④) and switch the book to be displayed on the screen.

　It's more efficient than opening a book one by one.

❷ Display multiple books side by side

　The second technique is to display multiple books side by side.The two books can be displayed side by side at the same time, so it is very convenient when you want to work while comparing.

　First, open all the two books you want to display side by side (①).

　Click [Display] tab (②) → [Calling] (③) (③) with either of the two books open.

　The Window Randrow dialog box is displayed.In the [Column] column, select how to align the book and display it.Here are two books sideways so that it is easy to compare.Select [Display on the left and right] (④) and click [OK] (⑤).

　The two books were displayed on the left and right (⑥).In this case, when you compare the two books, you don't have to switch the screen one by one, so it's efficient.

❸ Switch multiple books crisp with a shortcut key

　The third technique is to switch multiple books with a shortcut key.When you have multiple books, you can switch the book by clicking the preview of the book displayed by adjusting the mouse pointer to the Excel icon on the taskbar, but if you use a shortcut key, switch more efficiently.I can.

　With multiple books open (①), press [Ctrl] + [Tab] key (②).Here, the book preview is displayed on the screen so that multiple books are open, but it is not necessary to display the book preview when switching the screen with this shortcut key.It is OK if the book is open.

　Another book was displayed (③).Press the [Ctrl] + [Tab] key again to move to another book.

　If you remember this shortcut key, you will be able to switch books much more efficiently!By repeating the [Tab] key while pressing the [Ctrl] key, you can switch the book faster.It can be much faster than switching with a mouse, so please try it when there are many open books.

　By the way, some readers may think of the [Alt] + [Tab] key as a shortcut key to "switch to another book".Certainly, you can switch to another book with the [Alt] + [Tab] key.This [Alt] + [Tab] key is a Windows shortcut key and is a key that switches between all running apps.In other words, in the [Alt] + [Tab] key, not only Excel but also all other applications are switched.If you want to switch the display only between Excel books, you can use the shortcut key described this time.

Tasks that use multiple books can be more efficient with a small technique

　This time, we explained three techniques that help improve the efficiency of operations using multiple books.Each technique itself is not particularly complicated, but when you actually try it, you can see that the operation becomes much more efficient.

　When you open many books at the same time and do your work, please use the techniques described in this article!

When switching Windows 7 machines.The new PC has an increase in Excel work efficiency!

　The end of the support of Windows 7 is approaching.If you want to buy a new one, buy a PC for work efficiency!Check the specifications of personal computers that make work using Excel and PowerPoint at once!

This month's Exceltips