The most basic classes in Excel are based on basic shortcuts and basic functions.
There is a way to combine it with a slightly complex function.
First, the simplest shortcut is to use Ctrl + Shift + arrow keys to specify the range.
Then, if you want to put "cell format" in the specified range, press Ctrl + 1 (number)
Display format, alignment, font, border, fill, and more.
The most used here is
Specify the border.
Fill the desired area with a fill color.
The display format can be numeric, numeric, date, percentage, or text.
Here's the tip of the honey ~ !!!! You can freely create formats through customization in display format.For example, +10.2 or △ 2.3, 0 - If you want to display this,
"+" ## 0.0; "△" ## 0.0; Where ";" is preceded by a positive number, the middle with a negative number, and the end
with a number 0
It is a definition to show in the following format.
And if you want the number to be right-justified,
"+" ## 0.0 _-; "△" ## 0.0 -; - If you put a "-" after the 0.0 as in -, you will get a space.
Here again, the most commonly used part of the customized horizontal (H) is the "center of the selected area"
It is the part to put in.
If two or more cells are selected and the center of the selection is set, the value will be visible like a cell merge.
So what is different from cell merging?
When sorting directly, it may be difficult to filter the cells in case of cell merging.
But in the custom "middle of choice sales" you can freely put the filter.
Next time, I'll use the Quick Access Toolbar to make shortcuts
Functions.