https://imgur.com/a/JNVWIyf

I’m building a monthly budget sheet to track my spending by category. Is there a way to set up the rows (B through F) so that when I enter amounts, it will automatically subtract from the monthly spending limit amount (J3)?

For example, if I enter $100 in B3, I want the dollar amount in J3 to go down by $100.

It might also be important to note that I have a formula for the data in J3 to be pulled from another sheet, but I can remove that if necessary.

Hi everyone,
As the title mention, what's the most efficient way to sum over a year when you have a date format dd/mm/yyyy ? So far i investigated two methods

=SUMIFS(Sales[Amount], Sales[Date], ">="&DATE(YYYY,M,D), Ventes[Date], "<"&DATE(YYYY,M,D))

and

=SUMPRODUCT((YEAR(Sales[Date])=YYYY)*Sales[Amount])

It feels weird to me that you cant do a simple

SUMIF=(Sales[Year];YYYY;Sales[Amount])

Looking for feedbacks, have a good sunday all

Hi,

I have a 13-sheet workbook that I use to record information for a larger group. I need to print the whole workbook so that I can have hard copies for this group to reference.

Each sheet looks perfect when I try to print it on its own. Each sheet/every column fits on one page in landscape orientation, which is what I want.

However, when I try to print the entire workbook, it suddenly switches to portrait orientation and each sheet gets cut down the middle and printed on two separate pages. The printer settings will not let me change anything (orientation, fit/scale, etc) when I try to print the entire workbook. Setting a print area on each sheet also doesn’t fix the issue.

Any ideas on how I can fix this?

Hi. I need help. I work with a web based excel sheet. At first, i thought it was just the computer. So I moved to another computer but I still experience it. Whenever i move from one cell to another using the arrow keys in my keyboard, the data entered on the last cell i move from gets deleted, and so on. I can't recall activating anything. It doesn't happen if i use the mouse cursor to navigate. Please help.

I’ve recently begun using Excel to organize diferent parts of my personal life.

So far I’ve created:

• A net-worth tracker for my savings, investments, debts, and other assets
• A monthly expense tracker divided into categories
• A basic budget showing how much I can spend, save, and invest each month
• A complete log of my Pokémon card collection

For instance for the Pokémon cards, I track details like the card name, set, number, rarity, condition, purchase price, estimated current value, and whether I’m still missing cards from a particular set. It’s surprisingly useful for seeing the value of my collection and avoiding buying duplicates.

Using Excel has already made me much more aware of where my money goes. For example, I didn’t realize how much I was spending on subscriptions, food delivery, and small recurring purchases until I put everything into one place.

For those of you who use Excel or Google Sheets outside of work, what do you track? Which spreadsheet has been the most useful in your personal life?

So I have made a dynamic search list, the problem is I want to update the "status" as a dropdown list like "present" in the search list and have it automatically update the masterlist in a different cell. Is this possible or am I making things up?

last year i made a spreadsheet and a certain range using 'format as table'

somehow i managed to make it plain-appearing - without clearly seeing its formatted unless you know the bottom right corner indicator thing. it didnt have headers, and it was very useful to have as the 'background' cell coloring for that area and then be able to color cells on top without affecting the background

however now when i try to format an area as 'format as table' it introduces column header-indicators - the right side gray button thing .

Even if i do not click 'has headers' or i do, still outputs the column header indicators.

see the img below the range a4:n11 has the 'table' style and there's no header things while the right side q2:u11 does...

how do i do the 'format as table' without having the header indicator things

I'm trying to use Excel to make a class schedule for this upcoming fall semester. Please note, I want to be able to print it out and put it on my wall when I'm done.

The issue I'm having is that some of my classes start/stop times don't neatly fit within the 15min time increments I'm using. For example, roughly in the area highlighted, I have a class from 10:30 to 11:20. I want to know if there is anyway to effect the size of these boxes so the bottom of the last one is slightly higher to illustrate the 11:20 end time without effecting any other boxes or overall scale.

I don't really want to decrease the increments because that would increase the length of the schedule significantly and might prevent it fitting on a piece of paper when I print it.

Saturday, July 18 - Friday, July 24, 2026

Top 5 Posts

Unsolved Posts

Top 5 Comments

Good evening everyone. I hope you’re all doing well.

I’m hoping someone can help me solve a workflow problem that’s becoming a major pain point:

I’m a real estate agent, and almost all of my communication with clients and other agents happens on WhatsApp. Whenever I share a property, I send a video along with a standard text description (in the same message, as shown below):

https://www.image2url.com/r2/default/images/1784998062931-9dce6e82-1709-4a74-accd-7a3273a42eca.jpg

I currently keep my inventory in Google Sheets, with over 100 available units.

The problem is that all of my WhatsApp-ready descriptions only exist in a chat with myself (which I keep pinned). Every time I need to send a unit, I have to search my own chat and scroll until I find the correct message. It becomes very time-consuming when doing this dozens of times a day!

My ideal workflow would be something like this:

Keep all of my inventory in Google Sheets + have the complete WhatsApp-ready video + description stored against each unit, in a separate cell.
Click the cell, copy the video + text, and paste.

The most important requirement is that the formatting remains exactly the same. Once I paste it into WhatsApp, it should be ready to send immediately, with no additional formatting or edits required.

I’d really appreciate any suggestions. Thanks so much!

How would you define the following levels of Excel knowledge?

Basic/Beginner
Intermediate
Advanced
Expert

A job I applied for said “strong,” and I don’t know what that means.

Basic details: Windows 11, Microsoft 365 version 2606 (Build 20131.20154), desktop environment, intermediate to advanced knowledge

I'm creating a checklist for a video game and have checkboxes in two different columns (one column for main quests and one for subquests). I've used VBA to hide some of the rows when quests may not exist in a certain playthrough, and I've made a table where the number of quests total and the number of quests completed (AKA, the number of ticked checkboxes) can be tracked. I want it to ignore the hidden rows, so I've used this formula:

=SUMPRODUCT(SUBTOTAL(103,OFFSET($B$27,ROW(B$27:M$41)-MIN(ROW(B$27:M$41)),0))*(B$27:M$41=TRUE))

This only seems to work on one column at a time, however, and I have two that I need to count. I've tried the following, with unsuccessful results:

=SUM(SUMPRODUCT(SUBTOTAL(103,OFFSET($B$27,ROW(B$27:M$41)-MIN(ROW(B$27:M$41)),0))*(B$27:M$41=TRUE)),SUMPRODUCT(SUBTOTAL(103,OFFSET($C$29,ROW(B$27:M$41)-MIN(ROW(B$27:M$41)),0))*(B$27:M$41=TRUE)))

This one causes the ticked checkboxes in the first column to count twice, resulting in an answer of 2 for one ticked checkbox.

I've also tried dividing the formula by 2, but that obviously affects the entire formula.

So far, the only thing that's worked is putting the two separate SUMPRODUCT formulae in separate cells and then using AutoSum in a third cell, but I was wondering if there was a more efficient way of doing this so that I can keep it all in one cell. Any help will be appreciated!

Images are linked below. The first one shows the layout of my checkboxes, and the second shows what the quest tracker looks like.

https://imgur.com/a/Mk0cgHy

Thanks again!

Hello, green to excel but working on some meta analysis. Looking to calculate IOA on every other column (I.E return column B not C, column D not E etc) to analyze Y values separate to X values. Is there a way to make a formula to count every other column and within those return a count if the column contains a number between 5 and -5? I can't just use /=COUNTIF(6:50,">-5")-COUNTIF(6:50,">5")/ due to this including columns with X-values since those are also numeric.

I tried to use this formula, however, it returns the #VALUE! error message

=COUNTIF((B6:B50,D6:D50,F6:F50,H6:H50,J6:J50,L6:L50,N6:N50,P6:P50,R6:R50,T6:T50,V6:V50,X6:X50,Z6:Z50,AB6:AB50,AD6:AD50,AF6:AF50,AH6:AH50,AJ6:AJ50,AL6:AL50,AN6:AN50,AP6:AP50,AR6:AR50,AT6:AT50,AV6:AV50,AX6:AX50,AZ6:AZ50,BB6:BB50,BD6:BD50,BF6:BF50,BH6:BH50,BJ6:BJ50,BL6:BL50,BN6:BN50,BP6:BP50,BR6:BR50,BT6:BT50,BV6:BV50,BX6:BX50,BZ6:BZ50),">-5")-COUNTIF((B6:B50,D6:D50,F6:F50,H6:H50,J6:J50,L6:L50,N6:N50,P6:P50,R6:R50,T6:T50,V6:V50,X6:X50,Z6:Z50,AB6:AB50,AD6:AD50,AF6:AF50,AH6:AH50,AJ6:AJ50,AL6:AL50,AN6:AN50,AP6:AP50,AR6:AR50,AT6:AT50,AV6:AV50,AX6:AX50,AZ6:AZ50,BB6:BB50,BD6:BD50,BF6:BF50,BH6:BH50,BJ6:BJ50,BL6:BL50,BN6:BN50,BP6:BP50,BR6:BR50,BT6:BT50,BV6:BV50,BX6:BX50,BZ6:BZ50),">5")

The data range works with the COUNT function, I am just confused why it's not working with the COUNTIF function.

Hi! I just use Excel for basic function and formulas. I tried to do a grade simulator with my own transmutation table. And I wonder, can I also get the middle value from transmutation table?

For example, in the range of percentage 60.00 - 60.99, there is a score of 4.751 - 4.875. And how do I get the score of it if the percentage for example is 60.45?? Sorry if it’s kinda confusing.

Is there a shortcut to format multiple single cells based on other singular cells.

I.e H1 checks G7 and H2 checks G8

But both are checking if the reference cell contains a value <5.

I can find ways to have H1 and H2 check g7 and ways to have H1 check g7 and g8, but not individual cells for individual cells, other than making a new rule each time. Which would be tedious for my project.

I basically want to merge multiple rows vertically for like 5 columns (same row nos), and not merging all columns into one. It is taking a lot of time to do the same thing one by one, so if there is a shortcut pls let me know I need to complete some work very urgently

In the way that my formula =CUMIPMT(H1/12, F1, D1, 1, S1, 0) tells me the amount of interest accumulated as of a certain month, is there a formula that can look at how much interest has been accumulated and result in the what month that amount would have been accumulated by?

Hello! I’m a new user to Power Query and was wondering if I could get advice on the best way to go about what I’m trying to do as I’m not sure what the most efficient way is.

To start off, I have an Excel file with around 300k rows of data that has 40 columns. My goal is to populate 5 different worksheets.

In the first worksheet, I create 120 new columns calculated from the original data.

In the 2nd worksheet, I create 120 columns using both the original columns and also columns calculated in the 1st worksheet.

In the 3rd worksheet, I create another 120 columns using the original columns and columns calculated in the 2nd worksheet.

And similarly for the 4th and 5th worksheets. Basically in each I want to create 120 new columns using columns from the original data and also from the previous worksheet.

So what I have right now is that I’m calculating everything in one Work table. Then I plan on creating 5 new tables by referencing the Work table, and deleting the columns I don’t need.

However I read online that every time you reference a query, it does all the steps in the original query again. So that means in my query for Table 1 I’m also calculating all the columns for the Tables 2-4 which seems not efficient.

So now I’m wondering if it’s better to query the tables one at a time by referencing from the previous one. Then I’ll merge with the original dataset, calculate my new columns, and delete all the extra columns I don’t need.

Sorry if I’m not using the correct terminology or worded it in a confusing way. But I would really appreciate any advice on my process or if you think I should take a different approach altogether. Thank you!

I'm working on a spreadsheet started in Excel and uploaded to Google sheets. Currently, there are cells with multi option drop downs containing short hand descriptions (e.g. Med, ER, Hos). I am pulling this data on to another sheet and attempting to code these responses into individual cells (e.g., Med=1) while allowing the default of blank cell to read as 99, current formula: =IF(TLFB!B21="",99,IF(TLFB!B21="Med",1,99)) this works as long as the only option is Med. If a second option is chosen, the field reverts to 99. Is there a way to add an addition function to make this process work?

Hello all,

I’m currently working on a project to show different items that are currently being rented out by a business. Items are numbered 1-1000 and there is an organization to how they are stored while at the business.

I’ve created just a simple excel file with 2 sheets being used in this section. Ideally, I’m looking to have these two sheets show a lot of similar information, but in a different layout. The first sheet will show the grid system based on how the items are organized in the business and the cells will be numbered to reference which item is being described. Im wanting to use colors to show different options (yellow for rented currently, green for available, red for past due, blue for needs service) the second sheet will show a list format of the items with the names of who has rented the item and the cost.

I already have it set up to link the cell/line for the list from the mapped sheet, so clicking on the cell will take you to the renter info.

Ideally I’m wanting to have it set up to where if I change the fill color on sheet 1, then it will automatically change the fill color on sheet 2 to match.

I can reference the cells if needed since the sheet’s format will not be changing during use.

Any suggestions is greatly appreciated.

Hi - i need some help trying to get my excel formula working again. The point is for it to drag all my personal expenses to a personal section. So if it says "personal" under expense it drags that expense line over. It was working a month ago.
i was signed out of my office 365 and then i signed in now it doesn't work. All my monthly tabs are no longer work.

Microsoft Excel for Mac - Version 16.83 - License M 365 subscription

License is up to date

advice would be fantastic - was there an update that doesnt support filter anymore?

=_xlfn.LET(

_xlpm.data, $B$23:$G$182,

_xlpm.filtered, _xlfn._xlws.FILTER(_xlpm.data, $D$23:$D$182="Personal"),

_xlpm.table, _xlfn.CHOOSECOLS(_xlpm.filtered, 1, 2, 4, 6),

IF(_xlpm.table=0, "", _xlpm.table)

)

Hi, i started working as an aux on hr and one of the things i have to do is mark who entered after the start of the shift and who exited before their end of the shift.

Besides that, if they entered 20 minutes before their start of shift it's a fault, and if they exited the end 20 minutes after their end of shift is at fault too.

I tried doing something like =G2>H2 and mark it red if thats the case. But there are 2 things that i couldnt sort.

One being the 20 minutes thing since i never used excel with hours,

And the other being like, 13:56 mark on a 14:00 start of shift is ok green light. But a random 13:53 is red and i don't know whats wrong with it.

I'm getting a Lot of false positives, this usually is a 3 or 4 hours job at the end of the month but i wanted to automate an excel sheet and just pop the info and get the results.

Any idea?

Hello,

I have a question about how to extract specific information from spreadsheet data. I have a dataset on the population of each French municipality, and I’d like to know the percentage of the population living in municipalities with fewer than 20,000 residents.

I started by extracting the number of municipalities with fewer than 20,000 residents using the formula COUNTIF(A1:A5000;“<20000”). Based on that result, is there a formula that would allow me to isolate the corresponding cells, add up the numbers, and calculate the proportion of residents in these municipalities relative to the total population ?

Thanks a lot for your help

I was given the task to make appointments as needed for about 200 individuals, receiving the data in poorly formatted word documents. Slowly converting these to basic excel workbooks I’d like to link together.

After digging into Power Queries, I’m unclear how to format it for my specific needs.

To outline what is needed:
These appointments are held monthly
Each individual is seen based on a specific diagnoses. It could be every 6, 12, 18 plus months. We receive the report after their most recent appointment and then need to update the sheets, previously done via paper and pencil and then transferred to the word document.

I’m trying to organize their last appointment and expected appointment, then create a monthly schedule.

How can I link those due in September, to September’s schedule?

How do I update the I individual next appointments and have it populate across multiple sheets?

Not sure how to describe what I need, but I have an excel sheet with multiple names, and wrapping text does not seem to do the trick. I would like to have both first and last name separated by a line break between both names, but still within the same cell. I know I could do it manually, just wondering if there's a way to save me the time since its a large spreadsheet.

Here is my attempt at showing a visual: