Shulou(Shulou.com)05/31 Report--

The editor today takes you to understand what are the Excel tips that are very easy to use, and the knowledge points in the article are introduced in great detail. Friends who feel helpful can follow the editor to browse the content of the article, hoping to help more friends who want to solve this problem to find the answer to the problem. Follow the editor to learn more about "what are the very useful Excel tips?"

The forms are in a mess, and you want a raise? How can we make our forms quickly and well? Today, the editor will introduce some Excel tips that are very easy to use, and the boss likes them very much.

Tip 1: the method of making two-column oblique meter head

Technique 2: the method of making three-column oblique meter head

Tip 3: the method of printing the title

Tip 4: the way to make a drop-down menu

Tip 5: the way to change the content of the text.

Tip 6: the method of adding text suffixes.

Other computer shortcuts:

Insert a new worksheet Shift+F11 or Alt+Shift+F1

Move to the next worksheet in the workbook Ctrl+PageDown

Move to the previous worksheet Ctrl+PageUp in the workbook

Select current worksheet and next worksheet Shift+Ctrl+PageDown

Deselect multiple worksheets Ctrl+ PageDown

Select another worksheet Ctrl+PageUp

Select the current worksheet and the previous worksheet Shift+Ctrl+PageUp

Rename Alt+O HR to the current worksheet

Move or copy the current worksheet Alt+E M

Delete the current worksheet Alt+E L

Shortcut keys for moving and scrolling within an Excel worksheet

Move one cell arrow key up, down, left, or right

Move to the edge of the current data area Ctrl+ arrow key

Move to the beginning of the line Home

Move to the beginning of the worksheet Ctrl+Home

Move to the last cell of the worksheet, in the lowest row of the rightmost column of the data Ctrl+End

Move down one screen of PageDown

Move up one screen of PageUp

Move one screen of Alt+PageDown to the right

Move one screen of Alt+PageUp to the left

Switch to the next pane in the split worksheet, Ctrl+F6

Extends the selection to the beginning of the line Shift+Home

Extends the selection to the beginning of the worksheet Ctrl+Shift+Home

Extends the selection to the last cell used on the worksheet (lower right corner) Ctrl+Shift+End

Expand the selected area down one screen of Shift+PageDown

Expand the selected area up one screen of Shift+PageUp

Extends the selection to the last non-empty cell End+Shift+ arrow key in the same column or row as the active cell

Extends the selection to the last cell used in the worksheet (lower right corner) End+Shift+Home

Extends the selection to the last cell End+Shift+Enter in the current row

Extends the selection to the cell ScrollLock+Shift+Home in the upper-left corner of the window

Thank you for your reading, the above is the whole content of "what are the Excel tips that are very easy to use?" learn friends to hurry up to operate it. I believe that the editor will certainly bring you better quality articles. Thank you for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.