Business Articles, Software Tips, About GS, sometimes a Recipe & more!
Here's an interesting difference about how Excel Online treats multiple lines within versus Excel Installed. If using Alt+Enter to insert more than one line with one cell in one row, when the entry is copied and pasted into an Worksheet that's using Excel Installed version, it creates a cell that is split. This may be fine, depending upon what's been done, but if you are copying data from an online Worksheet into an installed Worksheet and want to try the content as a true dataset, you may be setting yourself for more work than hoped. In the clip below, in Cell A1, 3 entries were added and Alt+Enter was used at the end of the first 2 entries to push the text down to look like it's on a separate line: Then after using Copy and Paste from the online Worksheet into an installed Worksheet, there's a difference. Row 1 has now been altered to instead be 3 Rows (notice the gray borders): That's fine if you don't have any other plans for the Worksheet, but if you are wanting to use features like Sorting, you'll get an error and will need to unmerge the entry to have all 3 "Updated..." entries be all on one Row and if you have a large dataset, this could turn into a lot of extra work.
0 Comments
When reviewing a list of entries, sometimes it's helpful to quickly count how many of your cells contain text. For example, when collecting a list of potential attendees to an event.
To do this, click into an empty Cell where you want the result to be displayed. Then enter: =Countif(A2:A25,"*"). This function will know that you want Excel to review all Cells from the range of A1 to A25, look to see which Cells have an entry of any time, and with the count these to result in a total number of signed-up attendees. |
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.caVisit:
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
|