EXCEL PRO TIP: Snap to Grid

[@wayneedmondson1065]

Hi Chris.. Snap to Grid is great for those of us with a little OCD.. haha! It always bugs me when things don't align evenly. Snap to Grid to the rescue :)) Thanks for sharing. Thumbs up!!

[@tomada36]

My laptop doesn't have an 'Alt' key, but is there another way to do it?

[@thomashalverson6962]

@1:50 You show a layout of your content with star ratings. Do you have a video series on how you made that layout?

[@ExcelMaven]

I don't believe I have a video on that specifically, but those are built using conditional formatting with icon sets. Here's a good summary: www.myofficetricks.com/create-a-five-star-rating-system-in-microsoft-excel/

[@thomashalverson6962]

@@ExcelMaven What I am interested in is the process by which you made a layout that looks like it is sitting "on top" of the grid. I have been attempting to make something similar, but I find it ENDLESSLY tedious and anytime I adjust one thing, everything moves around. This leads me to believe I am doing it wrong. If you have any resources you could recommend that would be awesome.

[@ExcelMaven]

@@thomashalverson6962 Got it. Honestly those are still icons aligned with the worksheet cells, but I spaced those columns out consistently, removed the gridlines, and used white borders to achieve the style that you see on that sheet (nothing too fancy!)

[@AlxzAlec]

please just tell me what button to click in order to turn it off

[@danielstefansky4172]

should have looked this up like 6 hours ago.... smfh so sad lol. thanks dude

[@neptv1]

WOW!