Span/split columns in MS Word
Hi, I received a PDF that was originally designed in InDesign. The client asked me to convert it to MS Word. The text is set on two columns while Heading 1 and Heading 2 are set on one column. In InDesign is quite simple because there is a paragraph setting that allows me to span a sentence or a paragraph the columns or to split to columns a sentence or a paragraph. For those who are not familiar with InDesign, I will explain: If I set a text to flow on two or more columns but I want the headings to go on one column, I set the paragraph style for heading1 to span the columns. At that point, the InDesign breaks the text so that heading 1 will flow over all columns. On the other hand, if I set the text to flow on a single column, I can choose a bullet or numbered list to go on two columns. I select the paragraph(s) and choose split column by entering the number of columns I want. In MS Word I found no such option. Therefore, I set the MS Word document with infinite section breaks and column breaks. In the beginning, I thought that working with tables instead of sections and columns would be simple. Nevertheless, I decided on this approach as presented in the above screenshot. However, I am wondering if is there an option for doing that much easier and faster. Thank you. Sebastian
Change one click archive folder in Outlook/OWA
Is there any way to change the target folder for "one click archive" in Outlook or OWA? Some time ago there was one way in files -> tools menu, but that point seems not to exist any more. By now you can neither change the folder nor rename it. I startet archiving in "year"-folders. Because of not beeing able to change the folder that functions is useless.
Colormatch function in excel (using VBA code)
I am preparing a scoreboard for different projects. 10 KPIs of different weightage to measure each project performance. Each KPI will have either 3 responses (good, bad, ugly). User will update the response as either good or bad or ugly then i will use conditional formatting to color the cell as Green, orange and Red for good, bad and ugly. Once after all the 10 KPIs response received, based on the colormatch function, i need to formulate the scoreboard. For reference, i am giving exactly those 3 colors in some other cells for the formulae reference. But i am facing errors... even though the response of 1 KPI is in green and it is not matching with the green colored cell (reference cell) because, "good" is mentioned in the cell, where as green reference cell is empty. i cannot update these response to reference cells because each kPI have different responses. Can someone suggest me a solution to derive a scoreboard
Can you create a Button that Opens a Pop-Up with Data from Spreadsheets
Good evening, I have moderate knowledge of excel, and some knowledge of visual basic and am trying to develop a personal trading journal log. My intent is to create a pop-up for trades that I can input a lot of detailed data and an image of the trade that will then auto-populate a brief information row for a quick glance, but will also have a button in the row that populates for each trade that, if clicked, will open a pup-up of all the information given including the picture, comments about the trade in reflection and review, etc. I have been searching for if this is possible and haven't really found any information on it, only things like pop-ups for inputting data. Can anyone help me determine if this is possible, and if so how? Thank you.
Dynamically filter table on basis of range of criteria
Hi, I have a large table (150k rows) loaded to Excel from power query and I want to filter the description column (column N) dynamically on a couple of key words. It should be an AND filter so the column should contain any of these words and then result in a table showing column M, N and AH. Anybody any idea how to realize this keeping a mind the size of the table? many thanks, regards,
Excel Mac Save As Dialog Box
Excel for Mac 16.78.3 Because of other issues on my Mac, I had to remove everything from the Library/PDF Services folder and move it to the desktop temporarily, but then moved it back. After that, Excel now gives me the Save As Dialog Box that includes saving to One Drive. Word and Outlook have the old Dialog Box, which I prefer. How can I revert Excel to the old style dialog? I never want to save to One Drive. If it can't be changed, if I Save to my local drive, is it also going to save to One Drive or will it just save to my computer? Thanks for any help. Thanks for any help.Co-pilot is resurrected Clippy on steroids. Give us ACTUAL options to remove it
I am sick and tired of spending now literal hours of my life finding the newest, most super-secret hidden ways of disabling MS's newest way to chase the dragon of monetizing some new faddish tool. Every single new iteration of their desktop products further hides the malware that is copilot. I don't WANT that intrusive pile of donkey-excrement any more than I did that equally obnoxious Frankenstein's monster's stepfather Clippy back in the Y2K era. MAKE IT SIMPLE. NO ONE WANTS THIS POS.How to transform wide-format data into the structure shown in 'Result' sheet using Power Query?
Hi everyone, I have a dataset in wide format in the "Data" sheet, and I’d like to reshape it using Power Query to match the format shown in the "Result" sheet. What the source looks like (Data sheet): Row 1 contains repeating column headers for measures like Sales, Purchase, Sell value, etc., grouped by date: | Product Brand | Product Name | Region | 01.05 Sales | 01.05 Purchase | ... | 01.06 Sales | 01.06 Purchase | ... | Note: The values in the file are randomly generated using a function, just for demonstration purposes. Rows where the Region column contains values like a1_1, a1_2, a1_3 are subregions, and the row with Region = a1 is the sum of those subregions for that product. What I want to achieve (Result sheet): I need each value in a separate row, with the following columns: Product Brand Product Name Region Date Measure Values Example: Product Brand Product Name Region Date Measure Values Brand A Product A_1 a1 2025-05-01 Sales 15 Brand A Product A_1 a1 2025-05-01 Purchase 22 Brand A Product A_1 a1 2025-05-01 Sell value 32 The Excel file contains two sheets: "Data" – raw data "Result" – expected outcome Can anyone help me write the proper Power Query steps (M code) to achieve this transformation? Thank you in advance! https://docs.google.com/spreadsheets/d/1nMz_TyXRSQNelq-cbUDfSf8ekKezGCTn/edit?usp=sharing&ouid=109036053433195029380&rtpof=true&sd=true
Excel 365 co-authoring initial bubbles
Hi - I have a relatively simple excel sheet that is shared in 365 (via OneDrive) with about 200 people. The little initial bubbles that tell you who is working on which cell is incredibly distracting and sometimes in the way. Is it possible to hide these little bubbles from view while still allowing simultaneous work on the document? Thanks![DataFormat.Error] when refreshing queries in Excel
I have a "master" excel file stored on a SharePoint site which has a number of queries fetching data from other Excel files stored in the same SharePoint folder. Recently, when I pressed "Refresh All", I got an error message stating: [DataFormat.Error] The input couldn't be recognized as a valid Excel document. Immediately after clicking OK, the data seemed to update as expected. The owner of the source workbook was updating data and had autosave turned on when I went to refresh the queries. I should also note that each "Source" file from which the data is updated have permissions set up such that only myself and one other individual can view/update the file on SharePoint. Any ideas on what might have caused this error?
