Posts

Showing posts from 2014

Filling the G-Apps: Vertical Text in Google Spreadsheet

Vertical text in Google Drive is not something that exists yet however you can do within it's standard formatting however you can produce the same effect using a calculation where " LABEL " is the text you want displayed vertically: =ARRAYFORMULA(CONCATENATE((MID( " LABEL ", ROW(INDIRECT("YY1:YY"&LEN( " LABEL " ))), 1)&CHAR(10))))

Basic Web Browser Tips

Web browsers have all been redesigned in the last couple of years to allow you to view multiple websites within one browser window. Below is a small list of the most commonly used shortcuts that you might not already know about: ● Ctrl+Tab: Switch between your open tabs ● Ctrl+Shift+Tab: Reverse switch between your open tabs ● Ctrl+Click: Opens a link in a new tab ● Shift+Click: Opens a link in a new window ● Ctrl+T - Opens a new browsing tab ● Ctrl+Shift+T - Closed a browser tab by accident? No problems, this will bring it back

Filling the G-Apps: Domains

In Google Apps for Business Gmail you have 2 options for applying domains but they have their own restrictions. Add-on Domain Will give you the ability to add any email address from an applied domain to a user but we need to manually add each email address to each user. It also means that Google Apps can be accessed using these domains as well i.e. https://mail.google.com/a/companydomain.com. The only drawback is that you need to manually add the domain as you add each User or Group. Alias Domain Automatically adds the email address to every user & group in the organisation but you can't use the domain for any address other than the user name i.e. useralias@companydomain.com rather than user@companydomain.com or request@companydomain.com.

Giving Access the the Windows Fonts Folder on a Network

To give network users access to be able to add fonts the Fonts folder you'll need to complete the following processes: UAC (User Accounts Control) security will need to be reduced or disabled: Go to Control Panel and select  "User Accounts" Change "User Account Control Settings" Select “Never Notify” Give the user access to the font directory and modify the registry key permissions: Directory: Open the command prompt using Administrator Privileges (right click cmd, “run as administrator”) Type and enter "attrib –r –s c:\windows\fonts" (this will allow you to complete the next step) Open Windows File Explorer, right click on the fonts folder and choose "Properties" Click the "Security" tab Click "Advanced" Click the "Owner" tab Click the "Edit" button Change the "Current Owner" to yourself Check the "Replace owner on subcontainers and objects" box Click "OK&