With my copy in column B, starting in cell B2, and with the language short codes “en” for the original language and “no” for Norwegian – what I want to translate the English into, in cells E1 and F1 respectively, the code I place in cell D2 is: =GOOGLETRANSLATE(B2,$E$1,$F$1)
I can drag the formula down to translate all the English in column B.
That’s it really
🙂
By the way – if you have a site that’s randomly in 2 languages, or more – you can use detect language Google Sheets function
Pick a store (leave on all store views put pick a store from the folders below)
Pick a folder –> click “Add Subcategory”
Include in menus – Off canvas & All Sports – don’t include in All Sports if it’s a level 3 sub-sub category – e.g. equipment – kits – men’s kits wouldn’t go in All Sports.
Enable category – No
INCLUDE IN MAIN MENU – NO (unless a main sport top-category page e.g. /cricket or football main page
Category Description Placement – Show at bottom
Category Name – Add H1
Leave menu settings
CONTENT
Add thumbnail image if you have one
Description – Edit with Page Builder – > Apply Template -> Search for “product” -> Use Product Description
APPLY
Click cog icon
Put <p> </p> tags and paste in description for page
“ the em unit means “my parent element’s font-size” in the case of typography”
Percentages
The thing with percentages is that they are always set relative to some other value. For example, if you set an element’s font-size as a percentage, it will be a percentage of the font-size of the element’s parent. If you use a percentage for a width value, it will be a percentage of the width of the parent.
Text-Align
By default, in UK, USA etc. the text will be left aligned.
“text-align: center;” will align the text in the middle of the page or the element
text-align: justify;
Text-align: justify, will stretch the text across the page. Sounds weird but usually looks quite nice. I used to use this in Word for my uni assignments.
Display:inline
There are lots of ways to use “display” to present the text on your webpage.
W3 schools has a table full of all the values, including “inline” which is a pretty popular option
Find the font you like and click it (a card with the font), then, click “+ Select this style”. On the right side, you’ll see a container with the name “Selected family”.
Click “Embed” and choose <link> or @import depending on where you need to add the font (in HTML or CSS).
Copy/paste the codes you need.
If for example, you choose the “Muli” for the body of your webpage/html and “Quicksand” font for your h1s,
Import the font using the following code taken from Google Fonts:
Sub InsertRowsAtIntervals()
'Updateby20150707
Dim Rng As Range
Dim xInterval As Integer
Dim xRows As Integer
Dim xRowsCount As Integer
Dim xNum1 As Integer
Dim xNum2 As Integer
Dim WorkRng As Range
Dim xWs As Worksheet
xTitleId = "KutoolsforExcel"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
xRowsCount = WorkRng.Rows.Count
xInterval = Application.InputBox("Enter row interval. ", xTitleId, 1, Type:=1)
xRows = Application.InputBox("How many rows to insert at each interval? ", xTitleId, 1, Type:=1)
xNum1 = WorkRng.Row + xInterval
xNum2 = xRows + xInterval
Set xWs = WorkRng.Parent
For i = 1 To Int(xRowsCount / xInterval)
xWs.Range(xWs.Cells(xNum1, WorkRng.Column), xWs.Cells(xNum1 + xRows - 1, WorkRng.Column)).Select
Application.Selection.EntireRow.Insert
xNum1 = xNum1 + xNum2
Next
End Sub
Quick post on this which I will update at a later date…
Take a muscle relaxant like Magnesium glycinate
All magnesium is good for relaxing tense muscles, but glycinate is the only form which won’t give you the trots in high doses. It can make you sleepy, so take it in the evenings.
Stretch your Chest
The easiest way to stretch your chest is against a door frame, take a look at the video below for some ideas
Band Exercises
Maintain or increase your range of movement with band exercises. You use it or lose it with flexibility.
Rear Delt Flyes
Perform slowly with a squeeze and hold at the top of the movement
Invest in a Foam Roller
Lacrosse or cricket balls are good too for getting into particularly tight spots.
Hip Flexor Stretches
If you have hunched shoulders, there is a good chance that you have tight hip flexors and a titled pelvis from sitting down all day.
Make sure to stretch your hip flexors every day!
The reverse hyper machine is also excellent for correcting poor posture. It decompresses the spine and promotes blood supply to the lower back. The motion of extending the hips is also good for poor posture which results from sitting down all day.