Forum Widgets
Latest Discussions
How to not overwrite cells in filtered table using copy and paste values
Hi, I have search for an answer to this question without satisfactory results. I hope someone here at the forum can help me out. The problem is that sometimes when I copy and past a value from one cell into many cells in a filtered table, the value also gets copied into invisible cells. I have found that it may have to do with the selected pasting option. Because it seems as if the problem only occurs (but I am not sure) if I copy and paste “values” (or formulas, or any other pasting option other than the default paste option). Is there any way to make sure that Excel only copies and past even formulas or values into visible cells? Example. Pic 1 - In the table below I will filter column A and only see the rows with “Jan”. Pic 2 - I then write “ok” in the first cell and copy and paste (using keyboard shortcuts, ctrl c, ctrl + spacebar and then ctrl v) that into all the rows matching the value “Jan”. Pic 3 – The result is fine. Pic 4 – I did the same thing but copy and pasted “values” into all visible cells instead of using keyboard shortcuts. The result is as you can see that all cells got the “ok”. Thanks in advance for any help given. Brgs, Victor
Top n vs. Others in Excel
Hi all, I'm seeking some help because I'm kind of new to the more intermediate stuff in Excel. I have an Excel table with the following columns: Subcategory in column A, Brand in column B, Region in column C, Year in column D and Values Month in column E. I want to create a PivotTable and a Pivot line chart from this PivotTable that ranks the Top 5 Brands vs. Other Competitors by each region. For added context: There are 5 subcategories, 3 regions and 25 brands. Currently, I've tried grouping the remaining 20 brands as "Other Competitors" vs. the Top 5 brands within a selected region and possibly all regions (when no selection is made). I'm seeking a solution similar to this... Please mind the colours. I will sort those out later. But, the problem that I'm faced with is that upon selection of a region, the PivotTable won't update to the Top 5 brands of a selected region because they've already been grouped. How can I make this more dynamic so that I'm able to show The Top 5 brands vs. Others? Please help. EDIT: My operating system is Windows 10 (64-bit) and I use Excel 365 (Desktop version). For reference, I've attached a link to a sample file. https://1drv.ms/x/c/b2d878e32a062614/IQC1wcnwLICcQasOfnGcwKn0ASjpXp9xQ6rjnOP10Jal5cc?e=HaXEWd Thank you all once again.Chart from dynamic array challenge
Hi (Excel 365 v2601 b19628.20132 Current Channel / Windows 11 25H2) Initial post edited (& cross posted here on Jan 29, 2026) after further investigations In B6 below an array that dynamically resizes according to the 'START Year' & 'TOPN Cat' variables. The Chart is setup as follow: Select an empty cell > Insert 2-D Line chart Right-click > Select Data… > Chart data range > Select the Serie names & Values (C6:G12) Click Edit under Horizontal (Category) Axis Labels > Select the range with the Years (B7:B12) Check of the Chart data range: Changing 'START Year' works no problem: the Chart data range & Horizonal Axis Label range are properly updated Changing 'TOPN Cat' (the array resizes horizontally) screws up the chart: The Chart data range is properly updated but the Series & Axis Label ranges don't update accordingly Q: Am I doing something wrong, facing a limitation or is this something else? Tried to attach the sample file 3 times... it's available at: Dynamic_Chart_Challenge.xlsx Thanks & any question let me know Lz.
Best way to organize a café / drink menu with many items for easy scanning in Excel?
Hi everyone, I’m using Excel to manage a café-style menu that includes a lot of drink items, categories, and prices. The challenge I’m facing is readability. When everything is in one long sheet, it’s hard for people to quickly scan the menu and find what they want. I’m trying to make this more user-friendly for non-technical users, similar to how customers scan a real menu. In Excel, what approaches work best for this type of use case? For example: Separating items by category (coffee, cold drinks, specials, etc.) Using filters or tables to narrow choices Structuring the sheet in a more menu-style layout instead of a flat list From your experience, what makes menu-style lists easier to understand and navigate in Excel? Any practical advice would be appreciated.Excel formel
I am going to, have the same date pasted in about 50 places for labels. Request: I did Create a cell, AL2 - wrote, 27 Oct Then I want to create a formula in the 20 different places, that picks up 27 Oct from AL2, from the same Excel sheet. I have tried =!AL2, =$AL2... etc. but nothing works 🙁
How to include all matching values in different rows using xlookup
Hi all, Need some help please. I am using "grouped name" as lookup value from another excel to get the email from this table. However xlookup only returns the first occurrence. How can I modify the formula so that =xlookup("123", "fx-Grouped Name", "Email") would pull all the emails not just the first one (email address removed for privacy reasons) please? Thank you for your support.
Date/Data referencing
I am building a spreadsheet for work. My first sheet is an overview and my second sheet is my user input data. The idea is for me to input data everyday into the sheet (each day has a different row) and it automatically references that data in the overview page. I have made it reference the data for day 1 but I would like to be able to change the date on the overview page and have it automatically reference the date for that corresponding date on the input sheet.
Cell drop list of workbook sheets
Hello Is there a way to have a drop list of all the sheets in a workbook in selected cells and the selected sheet from the list, populates other cells in the first sheet? I want to easily see what machines are connected to a list of RJ45 wall points. In the workbook, there is 1 sheet that has a list of wall point and each machine has its own sheet. Each machine sheet has lots of corresponding data that is not pertinent to the RJ45 wall point sheet. My goal is to select a cell next to a given wall point row in the RJ45 wall point sheet, that drops down a list of machines (that are all the machine sheets in the workbook). The dropdown list selection will populate pre-defined adjacent cells with corresponding data from the selected machine sheet. Each cell in the MACHINE NAME column has a drop down list of the sheet names to select from. Once a machine is selected, the hardware names and model columns that are on the same row are populated with the corresponding data on the machine sheet.
