Just a quick one for all you Microsoft Excel users.
It doesn’t seem possible to paste my SQL rows alongside the the Excel subtotals so I tried the other way round.
No surprises but just doing a straight select -> copy -> paste doesn’t cut the mustard, copying everything, subtotals and all.
Well, a quick google brought me to this useful tip on MrExcel.com
Once you’ve selected your data you just need to go to the “Edit” menu, select “Go To” and then click the “Special” button.
This offers up a handy list of useful options , including the option to choose “Visible Cells Only”.
Click OK and the clipboard is now full of all your subtotals; subtotals that can be pasted as a fresh set of data, just as it appeared when you selected it.
The only problem with this is that Microsoft ditched their menu bar a couple of versions ago and if, like me, you keep up to date with Microsoft Office, then you might struggle to find the “Go To” option.
And that’s where I can add a little extra to the mix – try pressing the Alt + E keys and then the G key; the Go To window should be open for your pleasure,
They may have taken the menu bar away from us but the short-cut keys still work…
And I’m damned if I can find “Go To” in amongst the ribbon toolbars.