Make Office Better Top tips for MS Office & LibreOffice
Issue 633 • 8 – 21 June 2022 4747all customizations’^2 , then save
your toolbar on your computer as
an Exported Office UI file.
To import this file to another
computer, follow the above steps
and this time choose ‘Import
customization file’ in the
dropdown menu, and navigate
to where it’s saved. Note that
when you import the
customization, it will replace your
current toolbar setup. If you think
that you might want to revert to the
customization you currently have, you
should export it before importing a
new one.LIBREOFFICE CALC &
MICROSOFT EXCEL
Get a pop-up calendar for your
spreadsheet
Instead of typing dates into
spreadsheet cells, you can
use a LibreOffice extension
to insert them from a pop-up box.
To do this, you’ll need to install the
calCalc add-on from LibreOffice’s
Extensions site. Visit http://www.snipca.
com/42001, then click the first green
Download button and save it on your
computer. When you first open the
extension, you’ll see it being added to
LibreOffice’s Extensions Manager. Click
‘Add’ at the bottom, navigate to the file
you saved, then double-click it. Close the
Extensions Manager, then restart
Calc.
Now select a cell you want to add
a date to, then hold down the Ctrl
key and right-click. You’ll see the
calendar pop up, with today’s date
in red (^1 in our screenshot below
left), though alternatively you can
click the Today button at the bottom(^2). Click the left and right arrows at
the top^3 to skip to a different
month. Simply click the date you
need to insert it.
For Excel, try the WinCalendar
extension (www.snipca.com/42002). When
you’ve installed it, click the WinCalendar
tab at the top of your spreadsheet,
followed by Show WinCalendar. This will
make the extension float above your
spreadsheet. You can also make it appear
by pressing Ctrl+Shift+C.
ONLYOFFICE
Insert and order your bookmarks
You can insert bookmarks in
OnlyOffice documents, just as
you can in LibreOffice Writer
and Microsoft Word. Click where you
want the bookmark to appear, then
click References at the top, followed by
Bookmark. Name the bookmark (it can’t
contain spaces – it’s OnlyOffice^1 in our
screenshot above right), then click Add
and you’ll see it listed in the ‘Sort by’
menu below. You can show
your bookmarks so they’re
alphabetically listed (‘Name’
(^2) ), or in the order they
appear in the document (‘Location’^3 ).
To go to one, select it then click ‘Go to’^4.
OUTLOOK.COM
Delete your search history
Microsoft keeps a history of all
the searches you make in
Outlook.com. If you’re not keen
on this, you can delete it with a few clicks.
First, click the top-right Settings cog, then
‘View all Outlook settings’ at the bottom.
Now click General on the left (^1 in our
screenshot below), followed by ‘Privacy
and data’^2 then ‘Delete history’^3 and
Continue to confirm. You’ll see there’s
another option – to export your search
history as a spreadsheet^4. Click this, and
your history will be saved as a CSV file.
Export your Quick Access Toolbar to another computer
After you’ve customised the
Quick Access Toolbar to add
the icons you want, you can
export it to another computer, so you
can take the same commands with
you. We’ll explain how to do that but
first, if you’re not using the toolbar,
right-click anywhere on the ribbon at
the top then select ‘Show Quick Access
Toolbar Above the Ribbon’. You’ll see
the toolbar appear to the top right of
your document.
Now customise it by clicking the
down arrow to the right of the icons
(^1 in our screenshot) and ticking/
unticking the tasks shown in the menu.
You can also click More Commands to
bring up the Word Options panel, where
you can add further options, including
cut and paste.
Once you’ve finished, click the Import/
Export dropdown menu, choose ‘Export
MICROSOFT WORD
2
1
1
1
2 3
4
3
2
3
4
1
2