I use shortcut keys as much as possible, so it’s very easy that OOoAuthors.org has published an appendix with the default Calc shortcut keys. I prefer to have them all together in one Calc sheet, which I added to this post.

Download Calc Default Shortcuts Keys

Source

How wonderful it is to start a new spreadsheet with a new, blank, page in front of you. However, as I have done from an early age onward, I always feel the need to immediately change some basic things. In my Commodore 64 days this used to be: poke 53280,0 / poke 53281,0 to change the background color of my computer screen to black. In spreadsheets I usually change the following:

• I change header and footer information to be able to identify printed pages.
• I change the basic font to Verdana (just a personal preference).
• I add a documentation sheet to my spreadsheet. Since I keep forgetting — I know I’m not the only one — to document my spreadsheets.

The poking of my C64 couldn’t be automated (hence I still remember the codes), but, with the use of spreadsheets, it is very easy to change the defaults in any Calc spreadsheet.

1. Open the Standard spreadsheet template spreadsheet (or a blank one)
2. Make all the changes you like to have
3. go to File -> Templates -> Save
4. Select a name and a category for your template
5. click ok
6. done!

If you want to make the template your default one:

1. go to File -> Templates -> Organize
2. select the template (within the category)
3. right-click the template and select ’set as default template’
4. done!

My printing calculator spreadsheet isn’t a very complex one by any stretch of the imagination, however I use it frequently. Because of it’s lack of sophistication I wouldn’t have shared it on this blog until a colleague of mine saw me use it and wanted a copy immediately.

The printing calculator spreadsheet is the replacement I use for the old trusted calculator with the paper strip. I find it far easier to use than the ‘original’ calculator, especially when trying te find errors in an addition.

How does it work? Enter numbers in the yellow cells and the SUM formula at the start of the columns and rows adds the numbers (I told you it’s not very complicated). The worksheet is formatted to be printed on one page, so if need be, you can also print the numbers.

Download: Printing Calculator.ods