SSMS: Remove highlight in current cell of grid output

Question

SSMS: Remove highlight in current cell of grid output

Aaron N. Cutshall

SSCrazy Eights

Points: 9018
More actions
August 12, 2022 at 6:38 pm

#4075857

I'm trying to capture some screen shots of query results for documentation. I'd like to remove the highlight that's placed on the current cell of the grid output (initially the first row, first column). If there are more columns or rows that fit on the screen, I can scroll to a cell that would be off-screen, click on it, then scroll back to take my screenshot. However, if there are only a few columns or rows, I have no where to hide the highlighted cell. Is there a way that I can turn it off so my screenshots look better?
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
October 14, 2024 at 10:02 am

This was removed by the editor as SPAM
October 14, 2024 at 10:02 am

This was removed by the editor as SPAM
October 14, 2024 at 10:04 am

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

ratbak Ten Centuries Points: 1383 More actions · Answer 1

What version of SSMS? I'm using 18.12.1, and it doesn't select any cell by default -- I have to have clicked on it first.

Aaron N. Cutshall SSCrazy Eights Points: 9018 More actions · Answer 2

I just upgraded to the latest version and it has the same functionality. I thought perhaps it had to do with an automatic switch to the results pane, but that wasn't it. I attached an image of what I'm referencing.

Screenshot 2022-08-12 135046

LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com

ratbak Ten Centuries Points: 1383 More actions · Answer 3

Oh, right, sorry. Yes, I do see that more subtle highlighting on the first cell.

If you don't want that, then O don't know any way short of exporting to Excel and getting your screenshot from that... or maybe an image editor to change the fill.

DesNorton SSC-Insane Points: 24423 More actions · Answer 4

Looking at this from a different angle ....

If you click on the upper left corner, it highlights all the cells. That way you wont have a highlighted cell in the image.

How to post data/code on a forum to get the best help.

Phil Parkin SSC Guru Points: 246992 More actions · Answer 5

Just played around with this & couldn't find a way to solve it. As already suggested, you could

Select All / Copy with headers / Paste to Excel

if you really dislike the highlighting.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

kaj SSCommitted Points: 1608 More actions · Answer 6

Your could try to use Azure Data Studio as an alternative tool for your documentation.

Aaron N. Cutshall SSCrazy Eights Points: 9018 More actions · Answer 7

That's a good point and worth pursuing.

LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com

Jahanif Newbie Points: 2 More actions · Answer 8

Hey, newbie here. I also needed this today and the best 'solution' I could come up with was to add a blank column with blank records at the beginning.

Jahanif Newbie Points: 2 More actions · Answer 9

Hi, a newbie here. I was also searching this today and the best 'solution' I could come up with was to add a blank column with blank records at the beginning.