10 Excel tricks that will improve and speed up your work and with these tricks you can save your time.
Instead of copying and pasting or retyping, hold the Alt button and press the down arrow
A dropdown list of the information entered in the column is displayed in alphabetical order, which you can select with the up and down keys of the keyboard or with the mouse.
This feature is only for letters and does not apply to numbers
In tables, instead of using the freeze top row tool, which displays the first row above, you can convert the information into a table with the ctrl t shortcut keys.
In addition to the beautiful style and various other features, this also fixes the header on top when scrolling.
To scroll horizontally, instead of using this handle, you can hold down the ctrl and shift keys and scroll using the mouse wheel.
For full screen mode, use the shortcut keys ctrl, shift and F1, press the same keys to exit full screen mode.
If for any reason you want to get the information out of the table mode, just press Ctrl and A and right click, then click the convert to range from the table menu.
As you know, to copy a sheet, click on its name and select the move or copy option, select the sheet and check the create a copy option.
But the faster method is to hold down the control key and make a copy of the desired sheet by dragging with the mouse.
As you know, to draw a shape, you must click on the shape option from the insert menu and under the illustration section to select the shape you want and then draw it.
If you use such an option or menu a lot, you can rightclick on it and click Add to quick access toolbar to add it to this section.
From now on, you can access it very easily from this section
There are two practical ways to hide information
First, you must select a range and press the ctrl 1 keys on the keyboard, and from the custom section in the type section, type semicolon 3 time.
And as you can see, the information can be seen from this part.
To return, just select the range again and set the format to general.
And the second method, with this method you can hide a column or a row and unhide it in this way.
0:00 Introduction
0:10 Hold Alt + ↓
0:28 Freeze top row
0:30 Ctrl + T to Convert data to Table
0:44 Scroll Horizontally with Mouse wheel
0:52 Ctrl + Shift + F1 to Full Screen Mode
1:02 Remove Table Mode
1:10 Copy Sheet whit Keyboard Shortcut Key
1:38 Add to quick access toolbar
1:48 2Ways to Hide data
#shortcut_keys
#full_screen_mode
#alphabetical_order
#convert_to_table
#letters_and_numbers
#scroll_horizontally
#table_mode
#move_or_copy_option
#copy_sheet
#duplicate_sheet
#dropdown_list
#ctrl_1
#ctrl_t
#;;;
#hide_cell
% Percent Tutorial