#Assign hotkey macro open office code
#Assign hotkey macro open office plus

#Assign hotkey macro open office code

Later on, it serves as handy storage for code that you don’t need to memorize. Recording a macro is a good way of getting to know the basics of VBA. The main focus of this article is on the former, but recording a macro is so simple and handy, it's worth exploring too. Right now there are 1 comments/reviews for OpenOffice/LibreOffice Custom Hot Keys to Add New Row & Highlight Cells.There are two ways to make a macro: code it or record it. I tested these tips under Apache OpenOffice 3.4.1, but in LibreOffice this method should work as well. In the screen shot below, I've selected SHIFT-F3. Go back up to the Shortcut keys section, and pick your hotkey. On the right, highlight the style you created- in our example it is called 'Highlight Cells in Yellow'. Hotkey to Highlight a Row/Change Background Color of a Row in OpenOffice Calc Spreadsheet Appġ) On the menu bar, go to Format, then pick Styles and Formatting (or simply press F11)Ģ) A small window will pop up- right-click inside of it and select New.ģ) The Cell Style window will appear- go ahead and change the Name field- for instance I called the style 'Highlight Cells in Yellow'.Ĥ) Next, go to the Background tab and pick the highlight color, then click OK to save your custom style.ĥ) Repeat steps 1 and 2 of the insert row hotkey tip.Ħ) Under Category, scroll all the way down until you see Styles. After you press Modify, make sure that you see the key displayed under the Keys box to the right of the Function box.Ĥ)Press the OK button and now you can press F4 (or if you selected a different key) to automatically insert a row below the current row. For me, F4 was not grayed out, so that was the one I picked. Oddly enough, many keys are grayed out- for instance F6 and F10. On the box to the right, scroll down until you locate Insert Rows.Ĥ)Now in the Shortcut Keys section above, highlight the hotkey you want to assign to the Insert Row function. Then go to the Keyboard tab, then in the Functions section, under Category.ģ) Scroll down until you find Insert. Hotkey to Add a New Row in OpenOffice Calc Spreadsheet Appġ) Go to Tools on the menu bar, then pick Customize.Ģ) Make sure that Calc radio button is selected (vs ) on the upper right. Unfortunately there are not, but thankfully I found out, you can make your own custom hot keys pretty easily. I wished there were a hotkey that allowed me to add a new row, and a hotkey to let me change the background color of a row to let's say, yellow. I did wish that I didn't have to select the row, then go up to the menu bar to achieve what I wanted. I like to highlight certain rows to attribute a certain task done, or ask new rows. I have a list in Calc, the OpenOffice spreadsheet equivalent of Microsoft Excel, which I manage and edit quite often.

#Assign hotkey macro open office plus

Plus Open Office has more life in it has now it is 'owned' by Apache, which is a trusted long time provider of the Apache web server.Īnyways I wanted to share a tip that will help you work faster in OpenOffice Calc which should also apply to LibreOffice since they were based on the same code. I know that LibreOffice is supposedly better, etc, but the one time I tried it I had issues with it messing up the quotes when I tried to export to a tab-delimited file.