Ask Your Question
1

How to create keyboard shortcut for Cell Styles? [closed]

asked 2013-03-10 14:20:14 +0200

froz gravatar image

updated 2015-10-26 15:59:13 +0200

Alex Kemp gravatar image

Hi, in LibreOffice v4.0.1.2 on Windows XP sp3 I did the following: 1. Format | Styles and Formatting 2. In default Cell Styles I have created several cell styles that I need.

How to associate keyboard shortcut to each of cell style? Regards

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-26 15:59:24.762996

2 Answers

Sort by » oldest newest most voted
1

answered 2013-03-10 15:10:59 +0200

m.a.riosv gravatar image

Menu/Tools/Customize
image description

edit flag offensive delete link more

Comments

Excellent this works fine.

froz gravatar imagefroz ( 2013-03-12 14:56:02 +0200 )edit
1

answered 2013-03-10 16:13:14 +0200

w_whalley gravatar image

Now that you have your custom cell styles, how about a custom cell formatting toolbar instead of hard-to-remember keyboard shortcuts?

Here's an outline of what to do

Record a macro that sets a cell to a given style and give the macro a distinctive name. The cell style name will be in one of the macro statements.

Copy the macro and paste a copy for each cell style, changing the cell style name in the copies.

Construct a custom toolbar, e.g. CellFormat, and assign the cell-formatting macros to the toolbar Save the toolbar either with the spreadsheet or in Libreoffice Calc.

Save the spreadsheet as a template (first changing all cell formats back to Default). You can choose that template as the default spreadsheet template if you wish.

Then select your cells, click on the toolbar cell format name. Done.

You can even assign custom icons to the CellFormat toolbar entries.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-03-10 14:20:14 +0200

Seen: 3,312 times

Last updated: Mar 10 '13