Multiple Inventory entries on the same item
Okay so I'm wondering if there is a way for excel to automatically advance to the next column when entering inventory data so if I need to make another entry on the same item I don't have to advance to the next cell myself. This would be helpful in streamlining inventory and making it foolproof when adding inventory to a specific item (without having to worry about deleting previously entered data). I'm hoping there is a way to do this so I can take a tablet when completing my inventory and avoid the old clipboard and paper.
Moving a column of text data into 3 columns of data?
I have a column of text data cells 1,2,3,4,5,6,7,8,9 and longer. I want to create 3 column of data to graph and manipulate Cell in Columns. 1,2,3 3,4,5 5,6,7 8,9,10 and longer. So i need to create 3 columns of data from 1 column of data. I am using Mac Excel 16 and I can not make this happen. I have tried all sorts of solutions. Help? Thank you,Right click menu not Working in excel on iPad pro
Hi All, I am using Microsoft office on my I pad pro m2. Last few days I am not able to get right click menu in Excel. It’s not working at all. The apple IT guys told me that its from the Microsoft side. Now no one is able to sort this issue. I am on I pad 26.1 update which is the lates version. Please help me on this. Regards.
Consolidating nutrition and price data from multiple sources into one Excel dashboard
I maintain a single Excel workbook that tracks breakfast-menu items calories, macros, allergens, and local prices pulled from several public sources like https://mcd-breakfast-menu.com/. Each source formats its table differently: some list energy in kcal and others in kJ; decimal separators flip between commas and periods; prices appear in four currencies. After each monthly update I hand-copy tables into a Raw sheet and try to normalise them with Power Query and a few LET and LAMBDA functions, but one extra column or unit change breaks my mapping. Has anyone built a durable workflow for problems like this? I am looking for ideas on (1) keeping unit conversions transparent so a non-Excel colleague can audit the maths, (2) alerting me when a source table adds or removes a column so the model does not shift silently, and (3) deciding whether to keep all cleanup in Power Query or move some logic into hidden staging sheets. Any real-world templates or processes would be welcome.
Excel file change date and time
English: I use Excel on my cell phone and recently it stopped updating the file change date. As soon as I make a change to the file it shows the current date and time, which would be the time I last changed the file. But after a few seconds it returns to an old date and time change, how can I solve this? Português: Eu uso o Excel pelo celular e recentemente ele parou de atualizar a data de alteração dos arquivos. Assim que faço a alteração no arquivo ele mostra a data e hora atual, que seria a hora que alterei o arquivo pela última vez. Mas passado alguns segundos ele volta pra uma data e hora de alteração antiga, como posso resolver isso?
Integrate QR or Barcodes into Excel for Ongoing Data Entry into a Single Row?
As we continue to streamline data collection processes, I’m exploring whether it’s possible to use QR codes or barcodes to simplify and automate Excel-based data entry. Specifically, I’m curious if there’s a method that allows multiple scans—each representing a different datapoint—to populate and update a single row over time, rather than creating new rows for each scan. This would be especially useful in scenarios like tracking lab testing, equipment checkouts, or multi-stage workflows where data accumulates progressively. Has anyone implemented a system like this using Exce or any other tools? What hardware or software integrations (e.g., barcode scanners, mobile apps, Excel add-ins) have worked best for you?
With Office 365 Excel Online, Edge iPadoS 17.1.1, how to reference this from other Workbook?
I need help to reference separate Workbook using Office 365 Excel Online on ipadOS 17.1.1. Following steps worked for Windows desktop but not in with Office 365 Excel Online. open two instances of Edge login Office 365 for step 1 Open a workbook A in instance 1 Open a workbook B in instance 2 In cell of Workbook A, type in equal Sign Then click on Workbook B cell
