13th favourite, yes I'm a sad old git...

Feb 24, 2022 2:22 AM

And yeah, I've used the tips.

Original here:. https://imgur.com/gallery/Bmp00Ui

imgur13

Ctrl-G to get special selects. Ctrl-arrows to jump to the start/end of a row/column. W/ shift to select.

4 years ago | Likes 3 Dislikes 0

I use ctrl shift end and home quite a bit

4 years ago | Likes 1 Dislikes 0

And ctrl shift up and down

4 years ago | Likes 1 Dislikes 0

It’s a super simple tip but in all Microsoft products, format painter is my favorite tool.

4 years ago | Likes 8 Dislikes 0

The elusive tip I want is how to cut+paste values only (no formatting)....

4 years ago | Likes 2 Dislikes 0

I usually do ctrl + shift + V to paste as plain text. It will strip off any formatting though like dates.

4 years ago | Likes 1 Dislikes 0

Right click, hover over paste options, paste value only i believe.

4 years ago | Likes 2 Dislikes 0

Yeah, that's my current method, I just miss click when transferring more than a few items from PDFs to excel...

4 years ago | Likes 1 Dislikes 0

Ctrl-v (paste) then Ctrl then T.

4 years ago | Likes 1 Dislikes 0