Related Posts
I just realized I’m the dead participant.

Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.









I keep a spreadsheet of Excel hacks lol. I use paste transpose all the time. One trick that has saved me hours: filling blank cells with values. Say you have a column with a value, several blank cells, another value, more blank cells, etc. If I needed to copy the values into the cells below, it could take a really long time to do them individually. Instead:
Highlight all the cells from the first one down to where you want to copy the last one.
Cntl-G or Alt-5 (both are Go To)
Special
Blanks
Up arrow-Cntl-enter (if the value to be copied is above the blank cells)
Voila!
If it was a number that incremented and it needs to not (i.e. 111 instead of 123), simply type Cntl-D and 123 will change to 111.
Testing corners of a range to see if my data are contiguous or if I have any blank rows/columns that might screw things up. Ctrl-A to select all contiguous data, then Ctrl-period to cycle through the corners of the data.