What is New in Excel for January 2024


  • Staff

 Microsoft Excel Blog:

Happy 2024!! Welcome to our first update of the year, the January update.

This month, we are excited to share that users can now sync form data to Excel for the web. Insert pictures into cells is available to users of Excel on Windows and Mac, and PivotTables has expanded functionality in Excel for iPad.

Many of these features are the result of your feedback. THANK YOU! Your continued Feedback in Action (#FIA) helps improve Excel for everyone.

Excel for Web:
  1. Sync Forms Data to Excel
  2. Date Picker #FIA
Excel for Windows:
  1. Insert Pictures in Cells #FIA
  2. Check Performance
Excel for Mac:
  1. Insert Pictures in Cells #FIA
Excel for iPad:
  1. PivotTables on iPad


 Read more:

 
Last edited:
Wow - the ability to insert pictures in a cell is a feature I have wanted for years.

I often have to reply to clients comments in an Excel s/s and paste images e.g. from a document or simulation, and these float over the cells, and depending on pcs used to read replies, these images can all too easily become misaligned with comments.

Here is an example of the difference.

1706660325366.png

You can also insert in merged cells e.g. if merging in a single cell would mean picture is too small (without significantly increasing row height - column width is less of an issue) as shown below.

This is definitely a significant new feature that I will use (assuming my work's Excel gets updated asap).

1706665058134.png


Note: This above was from release not Insider version of MS Office 365.

I have no idea if this feature will be backported to older versions of MS Office but I suspect not.

I wonder how this would render on an older version of Excel. Perhaps somebody would be kind of enough to try it (@Edwin)?

Here is a link to the spreadsheet.

 

Attachments

  • 1706660112406.png
    1706660112406.png
    16.9 KB · Views: 2
  • 1706660191733.png
    1706660191733.png
    18.2 KB · Views: 1
Last edited:

My Computer

System One

  • OS
    Windows 10 Pro + others in VHDs
    Computer type
    Laptop
    Manufacturer/Model
    ASUS Vivobook 14
    CPU
    I7
    Motherboard
    Yep, Laptop has one.
    Memory
    16 GB
    Graphics Card(s)
    Integrated Intel Iris XE
    Sound Card
    Realtek built in
    Monitor(s) Displays
    N/A
    Screen Resolution
    1920x1080
    Hard Drives
    1 TB Optane NVME SSD, 1 TB NVME SSD
    PSU
    Yep, got one
    Case
    Yep, got one
    Cooling
    Stella Artois
    Keyboard
    Built in
    Mouse
    Bluetooth , wired
    Internet Speed
    72 Mb/s :-(
    Browser
    Edge mostly
    Antivirus
    Defender
    Other Info
    TPM 2.0

My Computers

System One System Two

  • OS
    Windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    ASUS ROG Strix
  • Operating System
    Windows 11
    Computer type
    Laptop
    Manufacturer/Model
    ASUS VivoBook

My Computer

System One

  • OS
    Windows 10 Pro + others in VHDs
    Computer type
    Laptop
    Manufacturer/Model
    ASUS Vivobook 14
    CPU
    I7
    Motherboard
    Yep, Laptop has one.
    Memory
    16 GB
    Graphics Card(s)
    Integrated Intel Iris XE
    Sound Card
    Realtek built in
    Monitor(s) Displays
    N/A
    Screen Resolution
    1920x1080
    Hard Drives
    1 TB Optane NVME SSD, 1 TB NVME SSD
    PSU
    Yep, got one
    Case
    Yep, got one
    Cooling
    Stella Artois
    Keyboard
    Built in
    Mouse
    Bluetooth , wired
    Internet Speed
    72 Mb/s :-(
    Browser
    Edge mostly
    Antivirus
    Defender
    Other Info
    TPM 2.0
For data of that type I'd store in a MySQL type database and then just send the query output to the user -- no probs with pictures or anything else.

I use EXCEL a lot but sometimes I think people are trying to use it as a fully fledged database which is really the wrong application for EXCEL.
Things like MariaDB and MySQL (both free) are very powerful, run on Windows and are much more flexible,

Cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
For data of that type I'd store in a MySQL type database and then just send the query output to the user -- no probs with pictures or anything else.

I use EXCEL a lot but sometimes I think people are trying to use it as a fully fledged database which is really the wrong application for EXCEL.
Things like MariaDB and MySQL (both free) are very powerful, run on Windows and are much more flexible,

Cheers
jimbo
Sledgehammer to crack a nut for my needs.
 

My Computer

System One

  • OS
    Windows 10 Pro + others in VHDs
    Computer type
    Laptop
    Manufacturer/Model
    ASUS Vivobook 14
    CPU
    I7
    Motherboard
    Yep, Laptop has one.
    Memory
    16 GB
    Graphics Card(s)
    Integrated Intel Iris XE
    Sound Card
    Realtek built in
    Monitor(s) Displays
    N/A
    Screen Resolution
    1920x1080
    Hard Drives
    1 TB Optane NVME SSD, 1 TB NVME SSD
    PSU
    Yep, got one
    Case
    Yep, got one
    Cooling
    Stella Artois
    Keyboard
    Built in
    Mouse
    Bluetooth , wired
    Internet Speed
    72 Mb/s :-(
    Browser
    Edge mostly
    Antivirus
    Defender
    Other Info
    TPM 2.0
Sledgehammer to crack a nut for my needs.
Depends on your needs of course but I find using MariaDB for a decent photo and pictures library using a DB works very well -- the EXIF info from a DSLR has just about every decent field in it you could want to query / sort /find etc.

SQL is a very simple query language - IMO much easier than convoluted EXCEL set ups - plus it's fast too since you don't need to store the physical data in the DB but just a link to the physical location. I can see the value of things of thumbnail size in EXCEL sheets but larger photos --- the thing could get very large quickly and take forever to run.

This site has an explanation of how to do it. MariaDB and MySQL have same syntax, both run on Windows and Linux so good for NAS servers of any type and is free. MariaDB is more commonly used on home / small servers.Data can also be returned to EXCEL via the get data function in EXCEL -- ensure that the MariaDB/MySQL OBDC driver is installed on Windows to do this though.


cheers
jimbo
 
Last edited:

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
Excel issue
Having a problem with Excel. I know, we are not supposed to be using Excel for other chores. But the best tool for the job is the one we actually use and like.

I am now organized with Excel. But it attacks like nothing I have ever seen before. I put pictures in comments, close and save. Open the next time and the pictures show only half. Did a search and a lot of people are having this same problem. One solution was to re-do the comments one at a time. The poster had thousands.

I myself have hundreds. Am enclosing an example. Hover over a picture in a comment and half the picture is shown. Two results here of the same comment, one shows the full photo, the other shows half and I don't know why.
 

Attachments

  • aarah.both.jpg
    aarah.both.jpg
    29.5 KB · Views: 1

My Computer

System One

  • OS
    Windows 10 physical Windows 11 virtual
    Computer type
    PC/Desktop
    Manufacturer/Model
    Custom Built
    CPU
    12
    Motherboard
    Asus
    Memory
    128
    Graphics Card(s)
    Nvidia
    Screen Resolution
    1360x768
    Hard Drives
    2
    PSU
    850
    Case
    Cooler Master
    Cooling
    fans
    Keyboard
    ergonomic
    Mouse
    wired
    Browser
    several
    Antivirus
    abast
Back
Top Bottom