Keyboard /Mouse Tips for Excel

Intro

Excel tutorials give hints that make the difference between a needy use and flexibility. Here are some examples:

• Copy the highlight to the clipboard: [Ctrl + Ins]
• Paste the clipboard on the current cursor: [Shift + Insert]

Works when right clicking is not available.

• Select a line from the 1st cell left: [Shift + (End and Right Arrow)]
• Select a line from the last cell right: [Shift + (End and Left Arrow)]
• Select a column from the 1st cell high: [Shift + (End, then Down Arrow)]
• Select a column from the last cell low: [Shift + (End, then Up arrow)]
• Select the sheet : Click on the white top left
• Go to top of window (or beginning of text box) :[Ctrl + Home]
• Go to end of window (or end of text box) : [Ctrl + End]
• Copy the screen to the clipboard : [Prt Sc]
• Copy the active window to the clipboard (maybe a seizure outside Excel!) :[Alt + Prt Sc]

Copy along the right of a column continuously full

a formula or a value
Select the cell,
Double-click on the small rectangle at the bottom right of the

an arithmetic progression (eg 1, 2, 3, ...)
Select the cells with the first two terms,
Double-click on the small rectangle at the bottom right of the

Edit the input fields of sets of a graph

Select the graph by clicking above
The series are then delineated by colored boxes


*

• • move this area:

Drag the arrow under the pointer
The mouse, the top of the


*

• • resize this area:

Drag the small rectangle appears
Bottom right of the color


*

• • delete a graph

Selection, then [Delete]

function with different values of x
Enter x in the column
Enter them in a new column,
Even if the same function as before!

Other Shortcuts

Copy selection to clipboard Ctrl + C
Copy selection to clipboard and delete Ctrl + X
Paste the contents of the clipboard Ctrl + V


*

• • Selection of locations on discontinuous

Hold down the Ctrl key
Select different blocks (or columns or in rows)
Copy selection to clipboard Ctrl + C
Release the Ctrl key
Select the destination cell
Paste the contents of the clipboard Ctrl + V

The batch will be pasted blocks of each other.