5 Excel techniques -Easy work speed up

There are various jobs, such as sales, accounting, general affairs, manufacturing, and sales, but one of the applications used by most people will be spreadsheets.It is used to aggregate various data, such as budget, daily reports, and performance reports.So, here are some useful techniques to know about "Microsoft Excel", which is the most used spreadsheet.

Create a new shortcut menu

In the initial state, three shortcuts are displayed on the top menu: Save, Return input, and [Repeat input].It is possible to display other shortcuts, such as copies and cuts.

To do this, on the screen that is displayed by selecting [File]- [Options]- [Quick Access Toolbar], add the item that you want to make a shortcut from the left column to the right side and save it.

Delete the blank cells at once

Isn't it possible to delete the blank cells formed for some reason one by one?In Excel, you can delete blank cells with one click.

To do so, select the scope of the cell containing the blank cell you want to delete, display a dialog box called [Jump], and click Cell Select.As a result, select [Blank Sel] from the displayed [Select option].In that state, [Delete] may be executed.

Replace the line and columns

Excel has a line and a line, but after the data entry is over, there may be times when you want to change from a line to a column.When you re -enter the data, you will be distant.In Excel, you can replace rows and columns with simple operations.

The first method is to copy the data.First, select the data you want to replace the line and columns and copy them.If you select the cell you want to place a new data, right-click, and select [Started Options]-[Swap in Ring/Row/Column], the line and column will be replaced.

The second method may be to select [Select and paste the format] when fixing the data, and select [Replace row/column].

The third method is to use the Transpose function.For example, let's say that the rows of data from A1 to E5 are replaced as follows.In this case, select the cell on the table after replacing the line and column, enter "= transpose (A1: E5)" in the formula bar, and "Ctrl" key, "Shift" key, and "Enter".Press the key.

Add the total value without using the SUM function

Usually, you will use a SUM function when giving the total data.However, the total value can be quickly obtained without using the SUM function.

To do so, click the first value you want to add, press the Ctrl key, and move to the cell you want to get the total value.Then, the total value is displayed at the bottom of the status bar.

By the way, the numbers displayed in the status bar can be customized.The numerical value displayed in the status bar can be selected from the menu displayed by right -clicking the status bar.

Master the Ctrl key+ shift key

Excel can use a variety of shortcuts, but the most convenient is [Ctrl + Shift], which selects data.Remembering this shortcut key rises at a stretch.

First, if ":" is added to [Ctrl + Shift], the entire table can be selected.Next, if you add an arrow key, you can select from the selected cell to the end of the direction of the arrow.By adding the Tab key, you can move to the previous book.In addition, if you add the END key, you can select the last cell after the data, or add the * (asterisk) key, you can select the entire table containing the selected cell.

In addition to these, there is a function of the [Ctrl + Shift] shortcut key, so if you are interested, please check it out.

There was an error in the explanation of how to use the Transpose function.To be correct, select the cell in the table with the line and columns, enter "= transpose (A1: E5)" in the formula bar, and "Ctrl" key, "Shift" key and "Enter" key.Press it. "We deeply apologize to the readers who have caused the inconvenience.