![\"man](\"https:\/\/blogarchive.utc.edu\/center-professional-education\/files\/2020\/05\/header-5.jpg\")
<\/p>\n<\/p>\n
In the second installment<\/a> of Stephanie Chastain\u2019s “Quick Excel Tips & Tricks” webinar, she shared with us how to create fun spreadsheet additions. Check out my step-by-step guide on Stephanie\u2019s \u201cEaster Egg\u201d tricks, and learn about topics like changing grid line colors and transforming the shape of comments in Excel!<\/p>\n Gridlines are what help you see each individual cell. To change their color:<\/p>\n <\/p>\n There is a difference between grid lines and borders. Gridlines help you see the cells while working on your screen, while borders are what will show when you print your spreadsheet. Gridlines look like dotted lines versus the solid lines of borders. To add color to your borders:<\/p>\n Note: Stephanie also reminds us that anytime \u201cmarching ants\u201d (aka dots) appear and highlight your text (for example, when copying something), you can always hit Escape to make them disappear.<\/strong><\/p>\n Comments are useful for adding notes to pieces of data in your spreadsheet. Stephanie reviews how to add comments, turn off comments, and change the shape of comments.<\/p>\n To add a comment to a cell:<\/p>\n If you want to hide your comment, simply right-click on the cell with the comment and select Hide Comment.<\/p>\n <\/p>\n Let\u2019s say you are working on a spreadsheet with a large number of comments. To view them all at once:<\/p>\n If you want to hide all your comments, click on Show All Comments to turn them back off.<\/p>\n <\/p>\n Note: When a comment is inserted, you are essentially inserting an image. <\/strong><\/p>\n Autofilters are useful when you have a lot of data in your spreadsheet and need to find a specific piece of information quickly.<\/p>\n Note: If you are using autofilters, it\u2019s important to make sure you have headers in your top cell. <\/strong><\/p>\n <\/p>\n This will bring all your information back onto the spreadsheet, unfiltered.<\/p>\n Formatting is how something looks on the screen or how it\u2019s going to look when you print it out.<\/p>\n Excel makes it easy to freeze headings so you can keep track of the data you are viewing without having to scroll back and forth to see the column labels.<\/p>\n If you need to unfreeze panes, go back to the View Tab, select Freeze Panes, and then select the Unfreeze Panes option. And remember, you can freeze as many rows as you want; just make sure if you are freezing more than your headings to select the Freeze Panes option rather than Freeze Top Row.<\/p>\n You can also freeze columns by selecting that option!<\/p>\n Note: First, Stephanie reminds us how to add things up quickly in Excel. Click on the cell below where you want your data to be added, stay on the Home tab, and click on AutoSum (in the right top-hand corner). Press Enter. Then, you can use the autofill handle and highlight cells all the way across to add up totals for everything you need instead of adding up each column individually.<\/strong><\/p>\n Stephanie covers the ins-and-outs of charts in greater detail in her instructor-led UTC courses.<\/a><\/p>\n Hi! My name is Marah Whitaker (think Laura with an M). I am the Marketing Assistant for UTC Center for Professional Education. During the workday, I spend time writing blog posts, creating content for social media,\u00a0<\/span>developing<\/span>\u00a0email campaigns, and building relationships with our customer base.<\/span>\u00a0<\/span>During my free time, you can find me getting lost in a good book, having spontaneous dance parties, playing piano, and going to Buffalo Wild Wings on Wing Night.<\/span>\u00a0Professionally and personally, I\u00a0<\/span>aspire<\/span>\u00a0to live by the Mr.\u00a0<\/span>Feeny<\/span>\u00a0quote, \u201cDream. Believe. Try. Do Good.\u201d I strive to use my passions to\u00a0<\/span>serve<\/span>\u00a0others and contribute positively to the world around me.<\/span>\u00a0<\/span><\/p>\n Connect with m<\/span>e<\/span>\u00a0on\u00a0<\/span>LinkedIn.<\/span><\/a>\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":" In the second installment of Stephanie Chastain\u2019s “Quick Excel Tips & Tricks” webinar, she shared with us how to create fun spreadsheet additions. Check out my step-by-step guide on Stephanie\u2019s \u201cEaster Egg\u201d tricks, and learn about topics like changing grid line colors and transforming the shape of comments in Excel! SESSION 2 TABLE OF CONTENTS… <\/p>\n
\nSESSION 2 TABLE OF CONTENTS<\/span><\/h2>\n
CHANGING LINE COLORS<\/strong><\/span><\/h3>\n
\n
USING COMMENTS<\/strong><\/span><\/h3>\n
\n
USING AUTOFILTERS<\/strong><\/span><\/h3>\n
\n
USING THE FORMAT PAINTER<\/strong><\/span><\/h3>\n
\n
FREEZING HEADINGS:<\/strong><\/span><\/h3>\n
\n
CREATING A PIVOTCHART<\/strong><\/span><\/h3>\n
\n
\nCHANGING LINE COLORS<\/strong><\/span><\/h3>\n
\n
CHANGING GRIDLINE COLORS<\/strong><\/span> (6:45)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\n
CHANGING BORDER COLORS<\/span> (9:30)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\nUSING COMMENTS<\/strong><\/span><\/h3>\n
\n
ADDING A COMMENT<\/span> (12:22)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\n
SEE ALL COMMENTS<\/span> (13:42)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\n
CHANGING THE SHAPE OF COMMENTS<\/span> (14:14)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\nUSING AUTOFILTERS<\/strong><\/span><\/h3>\n
\n
TURNING ON AUTOFILTERS<\/u>\u00a0(17:22)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\n
TURNING OFF AUTOFILTERS<\/span> (19:23)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\nUSING THE FORMAT PAINTER<\/strong><\/span><\/h3>\n
\n
APPLY FORMATTING<\/span> (21:11)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\nFREEZING HEADINGS:<\/strong><\/span><\/h3>\n
\n
FREEZING HEADINGS:<\/span> (24:55)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\nCREATING A PIVOTCHART<\/strong><\/span><\/h3>\n
\n
\u00a0<\/strong>CREATING A PIVOTCHART<\/span> (27:19)<\/strong><\/h4>\n<\/li>\n<\/ul>\n
\n
\nABOUT THE AUTHOR:<\/h4>\n
![\"Marah](\"https:\/\/blogarchive.utc.edu\/center-professional-education\/files\/2020\/06\/bio.png\")
<\/p>\n