Move and scroll within Excel worksheets

Arrow keys
Move one cell up, down, left, or right.
CTRL+arrow key
Move to the edge of the current data region.
HOME
Move to the beginning of the row.
CTRL+HOME
Move to the beginning of the worksheet.
CTRL+END
Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column.
PAGE DOWN
Move down one screen.
PAGE UP
Move up one screen.
ALT+PAGE DOWN
Move one screen to the right.
ALT+PAGE UP
Move one screen to the left.
F6
Switch to the next pane in a worksheet that has been split (Window menu, Split command).
SHIFT+F6
Switch to the previous pane in a worksheet that has been split.
CTRL+BACKSPACE
Scroll to display the active cell.
F5
Display the Go To dialog box.
SHIFT+F5
Display the Find dialog box.
SHIFT+F4
Repeat the last Find action (same as Find Next).
TAB
Move between unlocked cells on a protected worksheet.

Right Click keyboard shortcut

There is a keyboard shortcut for the mouse right click in Excel.
Try Shift+F10

convert accounting negatives

If you have an extract from SAP or other accounting system and it has the negative sign at the end of the number string, you can use this macro to convert them. Highlight the cells you want converted and run the macro.


Sub Convert_Negative()
Dim cell As Range
For Each cell In Selection
If InStr(cell, "-") > 1 Then
newval = -Left(cell, InStr(cell, "-") - 1)
cell = newval
End If
Next cell

End Sub