Forum Widgets
Latest Discussions
underline in cells not present after leaving cell
I am trying to insert a header on a page and in the left header cell, insert text and underline. The text and underline can be inserted and is displayed when the cell is highlighted, but when I leave the cell the text remains, but the underline disappears. Printing the document the text is printed, but the underline is not. The underline is intended to be a "marked" space to write in text on the printed document. I've tried different methods to apply the underline, but the same issue occurs. Any suggestions?
'apostrophes
new problem only on this computer. using excel now my spreadsheets are useless as they now have an apostrophe added to the beginning of each cell eg 'Alec '8482 '1=3 is there a button I need to unclick or something??? it has to be on this computer as I sent an unaffected workbook from another computer but it read the same once opened on this computer. hence this computer must have something activated to put ' on every cell. does anyone have any solutions to this please?Keep a number as "General"?
How do we keep a column of numbers as type General? For example, I have column L. I highlight column L. I set type of the entire column L to General. I go into several cells in column L and confirm that they are type General as I had set them to be. So I enter a general number into my cell that I set as a general cell. Excel decides that, no, what I really really want is for that cell to be set to Accounting which means that the cell displays ###### unless I widen it, at which point it becomes a dollar figure. But I'm not dealing with dollars. I'm dealing with general. Which is what I had set the column to be. So I have to go back EVERY TIME I enter data into a cell and switch it back to General which is what I already set it to in the first place. This would make some sense if I had entered 1/17/2025 and it decided to change what I told it (General) to a date, even though I had already told it that I want it to be general and therefore display the '1/17/2025' that I had entered. But if I enter '10230' into a cell that I had specified needed to be General, Excel should not decide that I wanted it to be $10,230.00. I did not. How do we prevent Excel from overriding our settings?
Excel Javascript API: Question about Bindings
Hello, I've got a question about using Bindings in the Excel/Office Javascript API, especially regarding listening to binding updates. There are ways to listen to updates to specific bindings using https://learn.microsoft.com/en-us/javascript/api/excel/excel.binding?view=excel-js-preview#excel-excel-binding-ondatachanged-member But what I'm looking for is listening for updates on newly created bindings. This is especially relevant in the Excel Online / OneDrive sync. If one instance of Excel creates a binding, I want all other instances to receive an update about it. Something like this: await Excel.run(async context => { context.workbook.bindings.onAdded.add((...) => {...}); });
Spreadsheet Compare Highlight Function
Hello I would like to know if rows can be highlighted in the compared files using the Spreadsheet Compare program. I want the rows changed, rows deleted and the rows with entered values changed highlighted in different colors respectively on the compared sheets by the Spreadsheet Compare program itself. Is it possible? Basically, the Spreadsheet Compare program takes in two spreadsheets - Old Data and New Data. I want the added rows detected in the new data sheet to be highlighted green, the changed rows should be highlighted yellow in the new data sheet and the deleted rows should be highlighted red in the old data sheet. I would like to know if there's any way to accomplish this using Spreadsheet Compare or any external method. I'd greatly appreciate any help! Thanks!
HELP! Consolidating data in spreadsheet without data loss
I have a dataset that I'm trying to consolidate into unique records without losing any data. Each observation has an SSID number, and there are duplicate entries in the SSID number column. I don't want to de-dupe the records using Excel's de-duplicate, because there is information across multiple rows/columns that I would like to consolidate. Here's an example (with fake IDs to preserve confidential information): My duplicate ID is highlighted with conditional formatting. I'd like one observation for student #1234, but that preserved both the grade in Column D, and the 'yes' in Column C that appears in the second row for student #1234. Using Excel's native de-duplicate or consolidate data functions means I lose either the grade in column D or the yes in column C. Any way to do this?
