EXCEL PRO TIP: Snap to Grid
Рет қаралды 7,586
4 жыл бұрынFor access to all pro tips, along with Excel project files, PDF slides, quizzes and 1-on-1 support, upgrade to the full course (75% OFF):
courses.excelm...
FULL COURSE DESCRIPTION:
This course is NOT an introduction to Excel.
It's not about 101-style deep dives, or about showing off cheesy, impractical "hacks".
It's about featuring some of Excel's most powerful and effective tools, and sharing them through crystal clear demos and unique, real-world case studies.
We'll cover 75+ tools & techniques, organized into six categories:
-Productivity
-Formatting
-Formulas
-Visualization
-PivotTables
-Analytics
Demos are self-contained and ranked by difficulty, so you can explore the content freely and master these tools and techniques in quick, bite-sized lessons.
Full course includes LIFETIME access to:
-10+ hours of high-quality video content
-Downloadable PDF eBook
-Excel project files (including data sets & solutions)
-1-on-1 expert support
-100% satisfaction guarantee (no questions asked!)
Happy analyzing!
-Chris (Founder, Excel Maven)
@wayneedmondson1065 4 жыл бұрын
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 8 ай бұрын
My laptop doesn't have an 'Alt' key, but is there another way to do it?
@danielstefansky4172 2 жыл бұрын
should have looked this up like 6 hours ago.... smfh so sad lol. thanks dude
@AlxzAlec 2 жыл бұрын
please just tell me what button to click in order to turn it off
@thomashalverson6962 2 жыл бұрын
@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 2 жыл бұрын
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 2 жыл бұрын
@@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 2 жыл бұрын
@@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!)
@neptv1 4 жыл бұрын
WOW!
ABRACADABRA TV
Рет қаралды 8 МЛН