admin – Page 2 – Jem's How To

Don’t select all the rows, just select the row below the row or rows you want to freeze. If you want to freeze columns, select the cell immediately to the right of the column you want to freeze. View tab > Freeze Panes command > choose “Freeze Panes.”

Cell Formatting

Don’t allow cell content to overflow cell (hide excess) Select Cells > Right click > Format Cells > Alignment > Horizontal = Fill

Tit-Bits

Effects

Using Effects Many menu items are disabled while playing, recording, or pausing a track. To enable them, press the Stop button.

Export

Export selection to a new file File > Export > Export Selected Audio

.Audacity General

Audacity is a brilliant free audio editing application, available from https://www.audacityteam.org/

Divorce, breaking up, arrghh

Here’s a nifty little web app a friend of mine came across that’s really good for couples with kids who are dealing with separating. Her ex was really controlling and manipulative and tried to make her life hell in the end. She got them using the 1 Message app and says it helped a lot […]

Importing Stripe transactions into Quickbooks Online

Currently Stripe doesn’t provide Quickbooks online integration, you have to pay a pricely sum to some other 3rd party to have this basic feature…except you don’t. Here’s how to manually export and import your stripe transactions. Creating Stripe manual import account in Quickbooks Online Accounting > Chart of Accounts > NewAccount Type: Cash at bank […]

All posts by

Query cell content

Combining cell content

Freeze panes