|
As long as your columns have been set-up to function as a "dataset" first you can easily turn it into a really nice looking table with color, shading, borders and drop-down filters. To do this, place the cursor somewhere (anywhere) into the area where your dataset has content:  Then, press CONTROL T to activate the Table Design macro. Excel will look around from it's current position to find the edges of your dataset and will let you know the cell range that has been identified.  If you don't want the first row to be different in appearance, then un-check the "My table has headers" option (though not recommended). And when ready, click OK. Voila! Your table is now looking really good without a lot of extra steps from you!  Want to learn more about Datasets, sign up for my Excel Targeted Skills Setup a Dataset 1-hour Course by emailing [email protected] or visit the GS Bookings online Calendar.
0 Comments
Leave a Reply. |
About My BlogWelcome. I'm a admittedly a bit obsessed with how software can, and should, make our lives easier. But, to round things out, I'm also interested in the Arts, all kinds of Crafts, Cooking, Gardening, Bird Watching, Feeding the Squirrels and cool Business ideas. Thanks for visiting.
GS Software Consulting.ca
Visit:
www.gssoftwareconsulting.ca to view Course Outlines 
Join me in my guided learning journey series of online, Zoom-delivered, All-in-One foundational Courses & Targeted-Skills Courses with advanced topics. Instructor-led, Fast-tracked, Online Microsoft Office Training.
All Courses start with a concepts presentation followed by a hands-on try-out session brought together with a real-world practice lesson. Learn the most needed and most used software skills and receive a free 1-pager Skills Guide for quick reference. Find out more by visiting my GS Software Consulting.ca website or email me with any questions. Archives
January 2025
Categories
All
|