There’s a useful article on The Entrepreneurial Tech about this.
All posts by
Multipart objects
Move 1 part of a multipart object on its own Direct selection tool Select the multipart object Right click the part you want to move > Isolate selected compound path
.Windows 10 How To
Device manager, network connections, etc, etc, quick access menu!!! Right click the start button Device Manager Type: devmgmt.msc
Split screen in Windows 10
Dragging Grap the window you want to snap and drag it to the edge. Once in the top left/right corner you’ll see a translucent border confirming it will snap. To make it full height you can then drag downwards (before you release mouse) Keyboard (easier!) Press and hold the Windows key and the Left or […]
Multi line
Make cell multi line Use ALT+ENTER to add a lin break. Ensure “Wrap Text” is turned of for the cell
Binary functions
Binary AND type functions You can’t
Convert values
Rounding values Round Down & Convert to 10’s Convert To Hex Convert To Binary
Query cell content
Does Cell Contain Text Segment
Combining cell content
Combining text from different cells
Freeze panes
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.”