Sunday, 19 October 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))))

Tuesday, 15 July 2014

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

Friday, 6 June 2014

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.

Tuesday, 22 April 2014

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:
  1. Go to Control Panel and select  "User Accounts"
  2. Change "User Account Control Settings"
  3. Select “Never Notify”
Give the user access to the font directory and modify the registry key permissions:

Directory:
    1. Open the command prompt using Administrator Privileges (right click cmd, “run as administrator”)
    2. Type and enter "attrib –r –s c:\windows\fonts" (this will allow you to complete the next step)
    3. Open Windows File Explorer, right click on the fonts folder and choose "Properties"
    4. Click the "Security" tab
    5. Click "Advanced"
    6. Click the "Owner" tab
    7. Click the "Edit" button
    8. Change the "Current Owner" to yourself
    9. Check the "Replace owner on subcontainers and objects" box
    10. Click "OK" on the pop-up box stating "You must close the window completely for the changes to take in effect"
    11. If you are not the intended user you'll need to edit the "Permissions" of the "Fonts" folder and allow "Full Access" for the intended user or security group.
Registry key:
    1. Run "regedit"
    2. Browse to : "HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\WINDOWS NT\CURRENT VERSION\FONTS"
    3. Right click on "Fonts"
    4. Select "Permissions..."
    5. Give "Full Control" to "Users"