Gloria Smith.ca
  • Gloria Smith's Blog
  • About GS
  • Terms & Privacy
All About GS Instructor-led Online MS Office Courses, Other GS Services, & Software Tips!

Excel Online & Excel Multiple Lines in a Cell

10/15/2023

0 Comments

 
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:
Picture
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): 
Picture
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
    Gloria Smith

    ​About My Blog

    Welcome.  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.
    Welcome to GS Software Consulting in London, Ontario Canada
    Visit GS Software Consulting
    GS Brochure

    GS Software Consulting.ca

    GS Course Calendar
    GS Course Brochure
    Course Selection by Job Map
    Using Zoom - One-Pager
    Visit:
    ​ www.gssoftwareconsulting.ca to view Course Outlines
    GS Bookings Online
    Word-Excel-PowerPoint
    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

    April 2025
    March 2025
    January 2025
    December 2024
    November 2024
    September 2024
    August 2024
    July 2024
    May 2024
    January 2024
    December 2023
    November 2023
    October 2023
    September 2023
    July 2023
    May 2023
    April 2023
    August 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2020

    Categories

    All
    Business Article
    Courses
    Excel Tips
    Other
    PowerPoint Tips
    Recipes
    Training
    Word Tips

Visit GS Software Consulting.ca to see & sign-up for my MS Office Online Courses
or Order a GS Developed MS Access Database 
  • Gloria Smith's Blog
  • About GS
  • Terms & Privacy