# Excel
#Accountants
Excel shortcut keys
1_ Ctrl + S
Save the changes in the work folder
2_ Ctrl + W, Alt + F4
Close the current workbook file
3_ Ctrl + ;
To insert the current system date
4_ Ctrl + shift + ;
Enter the current system time
5_ Ctrl + A
Select all cells in a worksheet
6_ Ctrl + Z
undo the previous action
7_Ctrl + Y
Undo command and re-execute the last Rendo command
8_ Ctrl + F
Search for values and limits
9_ Ctrl + H
Replace the contents of cells with other data
10_ Delete, Ctrl + –
Complete deletion of selected cells
11_ Ctrl + C
Copy the contents of the cells
12_ Ctrl + V
Place the contents of the memory in the desired location
13_ Ctrl + X
Transferring the contents of cells to other cells
14_ Shift + Space
Complete selection of a row in which one of its cells is active
15_ Ctrl + Space
Full selection of a column in which one of the cells is active
16_ Ctrl + Shift + =
Insert new cells in a worksheet
17_ Ctrl + Shift + F
Changing the font specifications of the cells
18_ Shift+F3
Access to function names and their use
19_ Ctrl + P
Print all or part of a worksheet or workbook
20_ Ctrl + O
Simultaneous printing of several folders
21_ Ctrl + F2
View the print preview of worksheet information
22_ Alt + F11
Entering the visual environment
23_ shift + F11
Create a new sheet
24_ + Ctrl
Copy the top line (programming trick)
25_ Ctrl + 1
To open the format cell window
26_ Ctrl + F2
Print preview
27_ F12
Save as shortcut
28_ F2
To enter the cell instead of double click
29_ F11
To create a chart on a table
30_ Ctrl + 9
Hide rows
31_ Ctrl + 0
Hide columns
32_ Ctrl + Shift + 9
Show hidden line
33_ Ctrl + Shift + 0
Show hidden column
34_ Alt + F1
To draw an active chart
35_ F4
You can redo what you did last time
36_ Shift + F2
You can leave a comment or note for a cell
37_ F4
To make addressing absolute
38_ Ctrl + D
Copy, Paste operation of the above cell
39_ Alt + D + S
To sort
40_ Ctrl + +
To add the Weston line
41_ Ctrl + –
To remove the Weston row
42_ F11
To draw a separate plot diagram
43_ Ctrl + F3
to open the name manger window
44_ Ctrl + Home
Refer to the first sheet cell
45_ Ctrl + End
Refer to the last cell containing information
46_ Ctrl + PGDOWN
The next sheet activates Excel
47_ Ctrl + Shift + L
Enables the filter tool for Excel sheet data
48_ Ctrl + T
It changes the range you selected in Excel to a table
49_ Ctrl+N
New workbook
50_ Ctrl + B
To thicken the text in the cell
51_ Ctrl + shift + end
It selects from the current cell to the last cell of the sheet
52_ % + ctrl + shift
The format of the selected cells changes to % format
53_ Alt + ==
the act of collecting
54_ ctrl + shift + v
Opens the paste special window.
55_ ctrl + page up
The previous sheet