https://excelwithbusiness.com/wp-content/uploads/2017/10/100-Excel-Tips_EwB.pdf
Paste Special : ALT E S V
Also, Transpose can be very handy at times.
Add Multiple Rows
F4 for Absolute Reference - did you know that pressing F4 repeatedly will toggle through the various combos?
A treasure trove!
No comments:
Post a Comment