# Shortcut of Summation Σ [closed]

Dear All, I am searching for a keyboard shortcut of autosum Σ. As there is a shortcut of alt+= in MS Excel, I want same shortcut for Libre Calc. My Libre office version is latest 4.2.2. Any help Please..

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2016-02-20 15:52:53.609064

Sort by » oldest newest most voted

This post is a wiki. Anyone with karma >75 is welcome to improve it.

(I'm using a German GUI, so sry if I make mistakes in the translate the GUI caption)

Click on [Extras] --> [Customize] --> Tab [Keyboard] --> search for alt = and change the shortcut.

At the moment I don't see that the sum is predefined in any shortcut. (if i didn't missed anything)

more

Hello Dennis, thanks, I tried it already but there is no shortcut for summation in any application & category.

( 2014-03-28 08:00:51 +0200 )edit

Oh yeah. there is only a shortcut available for opening the function-wizard/assistant. well I guess you have to use a macro as @mahfiaz described.

( 2014-04-02 17:48:26 +0200 )edit

Not sure if it is the easiest way, but you could create a super simple macro, something like this:

REM  *****  BASIC  *****
Sub Main

End Sub

sub EnterMyName
rem -------------------------------------------------------------
rem define variables
dim document   as object
dim dispatcher as object
rem -------------------------------------------------------------
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

rem -------------------------------------------------------------
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "Text"
args1(0).Value = "Andrew Pitonyak"

dispatcher.executeDispatch(document, ".uno:InsertText", "", 0, args1())
end sub


(shamelessly copied from "Getting strated with macros" document)

Change the Value to be Σ and finally assign it to a keybinding of your liking under Tools → Customize → Keyboard.

To anyone who is using Linux, you could configure e.g your right Ctrl to change to next layout while pressed and have Greek as the second layout. Now having Σ is as easy as pressing RCtrl + Shift + S and σ is RCtrl + S.

more

Hi mahfiaz thanks for ur reply. I followed ur steps, but the macro is not working. I tried to find the ready made macro for summation on google, but i didnt find the same.

( 2014-03-28 07:59:24 +0200 )edit

@Rahul Verma - I did try that macro now and it indeed did work. Unfortunately I don't know where yours went wrong. Will it work if you place your cursor inside the code of that macro and press F5? (F5 - Run BASIC, same as button on toolbar with paper and downwards arrow)

( 2014-03-28 17:18:53 +0200 )edit